You lock cells in Excel while scrolling by using Freeze Panes, which pins rows or columns so they stay visible as you move through the sheet. Select the cell below and to the right of what you want to keep on screen, then choose View > Freeze Panes > Freeze Panes. The separate "lock cells" feature, enabled through Format Cells > Protection, does something different: it blocks edits and only takes effect when you also protect the worksheet.
The two mechanisms Excel calls "locking"
The confusion starts with naming. Microsoft uses "lock" for two unrelated behaviors that live in different parts of the program, and neither one controls scrolling the way most people assume.
Freeze Panes is a view setting. It has nothing to do with security or editing. When you freeze, Excel records the split position and keeps the frozen rows or columns rendered in a fixed band while the rest of the sheet pans underneath. The frozen area consumes screen real estate, so a frozen top row of 20 pixels stays put but shortens the visible scrollable region by that amount.
Cell locking lives under Format Cells > Protection tab. The "Locked" checkbox is checked by default on every cell in a new workbook, which surprises people. Checking or unchecking it changes nothing until you turn on sheet protection via Review > Protect Sheet. At that moment, locked cells reject edits and unlocked cells accept them. The lock is an authorization flag, not a display setting.
The practical consequence: if your goal is to keep headers visible while scrolling, freeze panes is the tool. If your goal is to stop a colleague from overwriting formula cells, you need protection, and you likely need to unlock the input cells first.
What freeze panes actually does to the worksheet
Freezing works by inserting a visual divider and re-anchoring the frozen band's position relative to the window rather than the sheet. Excel does not duplicate cells or create a separate copy. The frozen rows render in place, and the scrollable region's origin shifts.
Three freeze modes exist. Freeze Top Row pins row 1 only. Freeze First Column pins column A only. Freeze Panes pins everything above and to the left of your selected cell, which is how you freeze both a header row and a label column at once. The full command is the one to learn; the two presets are shortcuts for the common single-axis cases.
The selection rule is the part people get wrong. Excel freezes everything above and to the left of the active cell, never the cell itself. If you select B2 and freeze, row 1 and column A stay visible. If you select A2, only row 1 freezes because there is nothing to the left of column A. A common error is selecting the header row you want to keep and freezing, which pins everything above the header instead and leaves the header scrolling.
Keyboard access varies by platform. On Windows, Alt then W then F then F reaches Freeze Panes. On Mac, the menu path is View > Freeze Panes with no default single-key shortcut.
Quantified context: where freezing saves real time
Freezing pays off in proportion to how far you scroll and how often you glance back at labels. A sheet with 5,000 data rows scrolled at roughly 40 rows per wheel notch requires dozens of return trips to the header without freezing.
Consider a typical monthly reconciliation: a header row plus three identifier columns, then 400 to 2,000 transaction rows. With the header frozen, each row's look-up requires zero scroll-backs. Without it, users typically scroll to the top every 10 to 20 rows to re-check a column meaning, which multiplies into hundreds of extra actions per session.
Freeze panes also reduces entry errors. Misaligned data entry, where a value lands under the wrong header because the header scrolled away, is a recognized source of spreadsheet errors in audit and finance workflows. Keeping labels on screen is a cheap structural control, cheaper than retroactive reconciliation.
There is a hard structural limit worth knowing: frozen panes cannot extend into the middle of a printed page differently than on screen, and extremely tall frozen bands, say 15 rows, can leave fewer than 10 usable rows on a laptop display. Freeze the minimum that carries meaning, usually one header row and one to three label columns.
Edge cases that break freezing
Split view is not freeze. The View > Split command creates draggable dividers that let you view two regions of the same sheet with independent scrollbars. Splits move when you drag them and are easy to disturb; freeze panes are fixed until you unfreeze. They look similar and behave differently.
Tables interact with freeze panes awkwardly. If you convert a range to an Excel Table (Ctrl+T), the table's own header row can behave like a frozen band within the table's scroll context, and freezing above a table can produce doubled headers. Freezing still works, but audit the result visually before distributing the file.
Freeze state is saved with the workbook and travels to recipients. A sheet frozen at a strange position, or frozen with the cursor parked in an odd cell, will look broken to whoever opens it. Freezing also persists across the .xlsx round trip but is view-specific per sheet, so each worksheet needs its own freeze setting.
Filters and frozen rows coexist, but the filter dropdown arrows sit in the header row. If you freeze row 1 and later insert a row above it for a title, the freeze boundary does not move automatically, and the header shifts down out of the frozen band. Insert title rows before freezing, not after.
Protected sheets add another layer. On a protected worksheet, some ribbon commands, including certain view changes, can be restricted depending on the protection options you enabled. If Freeze Panes appears grayed out, check whether the sheet is protected and whether "Format columns" or "Format rows" permissions were withheld.
Warning: selecting the header row itself before freezing pins the wrong band; select the first data cell instead. Warning: freezing is saved in the file, so a mispositioned freeze ships to every recipient. Warning: locked-cell protection does nothing until Protect Sheet is turned on. Warning: inserting or deleting rows above a freeze boundary does not shift the boundary reliably.
The misconceptions worth correcting
The biggest misconception is that locking cells stops scrolling or editing of the view. It does neither. Locking is inert without protection, and even with protection the locked cells remain fully visible and scrollable; they simply reject changes.
A second misconception is that unlocked cells stay editable on a protected sheet. They do, but only if protection was enabled with the default "Select locked cells" and "Select unlocked cells" permissions intact and editing allowed. If a user cannot type into an unlocked input cell, the protection dialog options, not the cell formatting, are usually the cause.
A third is that freeze panes works like a spreadsheet header that follows you into print. It does not. Printing uses print titles, configured separately under Page Layout > Print Titles, to repeat rows or columns on every printed page. Freezing affects only the on-screen view. A counterintuitive detail: many users set up freeze panes and assume their printed report will repeat headers, then discover page two has none.
Finally, people assume Mac and Windows behave identically. The commands exist on both, but menu locations, shortcuts, and some ribbon groupings differ, and files frozen on one platform generally preserve the freeze on the other.
Comparison of the three approaches
| Approach | What it controls | Persists in file | Requires protection | Best for |
|---|---|---|---|---|
| Freeze Panes | On-screen visibility while scrolling | Yes, per sheet | No | Keeping headers visible |
| Split | Independent viewing regions | No, view-only and transient | No | Comparing distant rows side by side |
| Lock cells + Protect Sheet | Edit authorization | Yes, with protection on | Yes | Protecting formulas and structure |
| Print Titles | Repeated rows on printed pages | Yes | No | Multi-page printed reports |
| Table header behavior | Header within table scroll | Yes | No | Structured, filterable data ranges |
Practical actions with concrete steps
To freeze a header row and label column together, click the first data cell, typically B2 if row 1 holds headers and column A holds labels. Then choose View > Freeze Panes > Freeze Panes. Confirm the thin divider lines appear and test by scrolling down 20 rows and right 3 columns.
To freeze only the top row, use View > Freeze Top Row. To freeze only column A, use Freeze First Column. To remove any freeze, choose View > Freeze Panes > Unfreeze Panes, which appears in the same menu position once a freeze is active.
To lock formula cells against editing, select those cells, open Format Cells (Ctrl+1), go to Protection, and confirm Locked is checked. Then unlock the input cells by unchecking Locked on them. Finally, go to Review > Protect Sheet, set an optional password, and confirm. Test by attempting to edit a formula cell, which should be rejected.
For repeated print headers, go to Page Layout > Print Titles, set "Rows to repeat at top" to $1:$1, and preview the print. Do this separately from freezing; they do not substitute for each other.
Threshold guidance on scope: freeze one header row and no more than three label columns on a laptop screen; keep the frozen band above roughly 15 percent of viewport height so the scrollable region stays usable. If you need more than that pinned, consider splitting the workbook into a summary sheet and a detail sheet instead.
Limitations and what none of this fixes
Freeze panes cannot pin cells in the middle of a sheet, only the top and left edges. It cannot follow a moving "current row" indicator the way some database tools do. It does not survive being undone by another user who unfreezes and saves, and it offers no audit trail of who changed the view.
Cell locking is not encryption. Protection with or without a password deters casual edits but is not a security boundary against a determined user; Microsoft documents worksheet protection as a convenience control, not a defense against malicious intent. For sensitive data, use workbook-level encryption and file permissions, not cell protection alone.
Neither feature changes how Excel recalculates or stores data. Frozen views and locked cells have no effect on formulas, values, or file size beyond trivial metadata. If a workbook is slow, freezing a large band can slightly increase rendering work because the frozen region redraws on each scroll, though the effect is small for a header row.
These instructions apply to current desktop Excel on Windows and Mac. Web and mobile versions expose freeze panes but with reduced ribbon options, and protection dialogs differ, so verify the exact menu labels on your platform before teaching the steps to others.