How to Freeze Panes in Excel
For just the top row: View → Freeze Panes → Freeze Top Row. For just the first column: Freeze First Column. Neither needs anything selected.
For anything else — two rows, or rows and a column together — the rule is: click the cell below and to the right of everything you want frozen, then View → Freeze Panes → Freeze Panes.
To freeze rows 1 and 2 plus column A, click B3. That single rule is what everyone gets wrong, and it explains almost every "freeze panes froze the wrong thing" complaint.
The two one-click options
Excel provides shortcuts for the two most common cases, and they ignore your selection entirely:
| Option | Freezes |
|---|---|
| Freeze Top Row | Row 1 only |
| Freeze First Column | Column A only |
If your headers are in row 1, Freeze Top Row is all you need.
The rule for everything else
Excel freezes everything above and to the left of the cell you have selected, as Microsoft's freeze panes documentation describes. Once that clicks, the rest follows.
| To freeze | Select |
|---|---|
| Row 1 | A2 |
| Rows 1–2 | A3 |
| Rows 1–3 | A4 |
| Column A | B1 |
| Columns A–B | C1 |
| Row 1 and column A | B2 |
| Rows 1–2 and column A | B3 |
| Rows 1–3 and columns A–B | C4 |
Then View → Freeze Panes → Freeze Panes.
The pattern: your selected cell is the first cell that will scroll. Everything above and left of it stays put. Selecting A1 freezes nothing, because there is nothing above or to the left of it.
Unfreezing
View → Freeze Panes → Unfreeze Panes. The menu item only appears when something is frozen, which is itself a quick way to check.
You cannot have two frozen regions at once — applying a new freeze replaces the old one, so there is no need to unfreeze first.
When Freeze Panes is greyed out
Three causes, in order of likelihood:
- You are in Page Layout view. Freezing only works in Normal view. Switch via View → Normal, or the small view buttons at the bottom right.
- A cell is in edit mode. If the cursor is inside a cell, press Esc first.
- The sheet is protected. Some protection settings block it — unprotect the sheet, apply the freeze, then reprotect.
Freeze versus Split
Sitting next to Freeze Panes is Split, which does something related but different.
| Freeze Panes | Split | |
|---|---|---|
| Locked area scrolls | No | Yes — independently |
| Shows the same cells twice | No | Yes, if you scroll to them |
| Best for | Keeping headers visible | Comparing distant parts of one sheet |
Split gives you two or four independently scrollable views of the same sheet — useful for comparing row 5 against row 5,000. If you applied Split by accident and rows seem duplicated, that is why: View → Split toggles it off.
Printing headers on every page
A related need that freezing does not address. Frozen panes affect the screen only, not printing.
For headers to repeat on every printed page, use Page Layout → Print Titles → Rows to repeat at top, and enter $1:$1 for the first row.
These are separate settings, so a sheet can have one without the other. It is a common surprise when a printout arrives with headers only on page one.
The same job in Google Sheets
Sheets handles this more intuitively — you specify how many rows to freeze rather than working it out from a selected cell.
View → Freeze, then choose 1 row, 2 rows, up to the current row, or the column equivalents. There is also a thick grey bar at the edge of the grid that you can drag directly to set the freeze point.
A file frozen in one application keeps its frozen panes when opened in the other.
Two related problems on large sheets: why your Excel file is slow and large covers making it manageable in the first place, and why a formula is not calculating covers results that will not appear.
Frequently asked questions
How do I freeze panes in Excel?
For row 1 only, View → Freeze Panes → Freeze Top Row. For anything else, click the cell below and to the right of everything you want frozen, then View → Freeze Panes → Freeze Panes.
How do I freeze the top row and first column together?
Click cell B2, then View → Freeze Panes → Freeze Panes. Excel freezes everything above and to the left of the selected cell.
How do I freeze the top two rows?
Click A3 — the first row that should scroll — then View → Freeze Panes → Freeze Panes. Selecting A2 freezes only row 1.
Why is Freeze Panes greyed out?
Usually because you are in Page Layout view; switch to Normal view. It is also disabled while a cell is in edit mode (press Esc) and on some protected sheets.
Why did it freeze the wrong rows?
Because the freeze point comes from the selected cell, not from what you highlighted. Whatever is above and to the left of that cell gets frozen — so select the first cell that should scroll.
What is the difference between Freeze and Split?
Frozen panes stay fixed while the rest scrolls. Split creates independently scrollable views of the same sheet, so the same cells can appear twice. Freeze is for headers; Split is for comparing distant areas.
Why don't my frozen headers print on every page?
Freezing affects the screen only. For printing, use Page Layout → Print Titles → Rows to repeat at top, entering $1:$1 for the first row.
Conclusion
Freeze Top Row covers most cases in one click. For everything else, remember the rule: select the first cell that should scroll, and Excel freezes everything above and to the left of it.
If it is greyed out, check you are in Normal view. And if you need headers on a printout rather than a screen, that is Print Titles — a completely separate setting.
Related: why your Excel file is slow and large covers navigating big sheets, and Windows keyboard shortcuts covers moving around faster.
Comments