Freeze Rows and Columns
To keep a header row and an ID column visible at once, click B2 first — the split lands just outside the selected cell, one row up and one column to its left. It never splits on the selection itself, which is the whole reason clicking inside row 1 leaves the headings scrolling away. Freeze Top Row and Freeze First Column ignore the selection entirely and always pin row 1 or column A, so only the plain Freeze Panes command cares where you happen to be standing. A sheet holds one frozen region and no more, which is why a band in the middle cannot be pinned and why choosing again simply replaces whatever was set before.
The formula
Freeze row 1 onlyView > Freeze Panes > Freeze Top Row (selection ignored)Freeze column A onlyView > Freeze Panes > Freeze First Column (selection ignored)Freeze rows 1-2select A3, then View > Freeze Panes > Freeze PanesFreeze columns A-Bselect C1, then View > Freeze Panes > Freeze PanesFreeze row 1 and column Aselect B2, then View > Freeze Panes > Freeze PanesUndo any of the aboveView > Freeze Panes > Unfreeze PanesA worked example
An order table with headings in row 1, order IDs in column A, and 400 rows of data running down to row 401.
Click B2, then View > Freeze Panes > Freeze Panes
A thin grey line appears under row 1 and to the right of column A, and both stay visible while you scroll in either direction. The usual mistake is clicking inside row 1 or column A first — the freeze always lands above and to the left of the selection, so pinning row 1 means standing on row 2.
Which one do I need?
| If you want to… | Use |
|---|---|
| Only the heading row needs to stay visible | View > Freeze Panes > Freeze Top Row, which pins row 1 no matter which cell is selected |
| Only the first column needs to stay visible | View > Freeze Panes > Freeze First Column, which likewise always pins column A |
| The headings occupy the top two or three rows rather than just row 1 | Select A3 (or A4), then View > Freeze Panes > Freeze Panes — stand one row below the last row you want held |
| A heading row and an ID column both need to stay put | Select B2, the cell diagonally inside the corner you want pinned, then View > Freeze Panes > Freeze Panes |
| Freeze Panes is greyed out on the ribbon | You are in Page Layout view, or a cell is still in edit mode — press Esc, switch to View > Normal, and the option returns |
| Two distant parts of the same sheet need to be visible at once, each scrolling on its own | View > Split rather than Freeze Panes: split panes scroll independently, frozen ones never do |
| "Freezing a formula" so its references stop shifting when it is copied | That is an absolute reference built with $ signs — a different feature that happens to share the word |
| The headings must reappear at the top of every printed page | Page Layout > Print Titles > Rows to repeat at top; freezing is a screen setting and never reaches paper |
| The range is already a real Excel Table | Scrolling inside a Table swaps the column letters for its heading labels automatically, which often removes the need to freeze anything |
| You are in Google Sheets rather than Excel | View > Freeze > 1 row, or Up to current row — Sheets freezes by a count of rows, not by the selected cell |
Frequently asked questions
Why does Freeze Panes freeze the wrong rows?
Because the split lands above and to the left of the selected cell rather than on it. Selecting row 2 freezes only row 1, and selecting the row you actually want held leaves it scrolling. Count one row down and one column right from the corner you want pinned, then apply Freeze Panes.
Can I pin a row somewhere down the middle of a sheet?
No. A worksheet supports exactly one frozen region, and it always starts at the top-left corner because it is defined as whatever sits above and left of your selection. To hold a band further down while the rest keeps moving, use View > Split instead, which creates panes that each scroll on their own.
Why is Freeze Panes greyed out?
Two things disable it. The sheet is in Page Layout view, where freezing is unavailable — switch back with View > Normal. Or a cell is still in edit mode with the cursor blinking inside it, which greys out most of the ribbon; press Esc or Enter first and the option comes back.
Does freezing panes change what gets printed?
No. Freeze Panes affects the screen only and leaves the printout untouched, which catches out anyone whose headings vanish after page one. Repeating headings on paper is a separate setting: Page Layout > Print Titles > Rows to repeat at top, entered as $1:$1 for the first row.
New guides and tools, once a month
DE + EN · double opt-in · no spam