How to Lock Cells in Excel for Scrolling

What this does

The mechanism surprises most people: in a new sheet every cell already carries the Locked attribute, yet that attribute does nothing until you protect the sheet. So locking works in two layers. The Locked checkbox under Format Cells ▸ Protection marks which cells should be frozen, and Review ▸ Protect Sheet is the switch that actually enforces it. To make only some cells uneditable, you unlock the ones people should still type in (uncheck Locked for them), then Protect Sheet so the still-locked cells become read-only. The same idea underpins a lot of everyday Excel work, so the few minutes spent getting it right here pay back across every sheet you build afterwards. Treat it as a pattern, not a one-off, and it stops being something you look up and starts being something you reach for. Treat “lock cells in excel for scrolling” as a small repeatable workflow rather than a one-off click you hope to remember next time. Use a small test block before the live file, so any surprise in the affected cells shows up while it is still harmless. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. That turns a workspace setting that makes a big sheet comfortable to navigate into a method you can reuse, explain, and defend when the workbook leaves your screen.

A worked example

A form has input cells in column B and a calculated formula in column C that must not be touched. Select B2:B20, open Format Cells (Ctrl+1) ▸ Protection, and uncheck Locked — those input cells are now exempt. Leave column C as-is (still Locked). Now Review ▸ Protect Sheet, optionally set a password, and click OK. People can type freely in column B, but any attempt to edit the formula in C2 is refused with "the cell is protected". Lock cells when you are handing a sheet to other people and want them to fill in some fields without breaking your formulas, headers or layout — budget templates, data-entry forms, shared trackers. It guides input to exactly the right places while keeping the working parts of the model safe. When the result is not what you expected, undo straight away rather than repairing it by hand — undo restores the sheet exactly, while manual fixes tend to leave small inconsistencies behind that surface later.

In Google Sheets

Google Sheets has no Format Cells ▸ Protection ▸ Locked property. Protection there is set with Data ▸ Protect sheets and ranges: protect a range, or protect the sheet and tick "Except certain cells" for the inputs others may edit. Google notes that a protected sheet cannot lock cell formatting while still allowing edits to input values. The aim was to get you unstuck fast and leave you a little more capable than a copy-paste would. The answer is at the top and the detail above shows why it holds — so the next time a colleague asks, you can answer without reaching for search. If you take one thing from this page on “lock cells in excel for scrolling”, make it the order of checks rather than the individual clicks: confirm what is selected, apply the step, and look at the result before moving on. That small routine is what keeps Excel work predictable when the same task comes back in a slightly different workbook.

Common mistakes

• Ticking Locked and expecting it to work without protecting the sheet — the Locked attribute does nothing until Protect Sheet is on.
• Forgetting that all cells start Locked, so protecting the sheet without unlocking inputs freezes the entire sheet.
• Unlocking the cells you meant to protect by mistake — Locked must stay ticked on the formulas you want read-only.
• Confusing this cell-level locking with file encryption; locking controls editing, not whether the file opens.

Frequently asked questions