Freeze panes lock rows or columns in place so they remain visible as you scroll. When you have a spreadsheet with 500 rows and you've scrolled down to row 300, frozen headers mean you always know what each column represents.
All freeze options are under View tab → Freeze Panes.
Freeze the Top Row
The most common freeze. Keeps row 1 visible no matter how far down you scroll.
- Click any cell (your cursor position doesn't matter for this one)
- View → Freeze Panes → Freeze Top Row
To unfreeze: View → Freeze Panes → Unfreeze Panes (this option replaces the Freeze options when something is already frozen).
Freeze the First Column
Keeps column A visible as you scroll right — useful for spreadsheets with many columns where the row labels are in column A.
- View → Freeze Panes → Freeze First Column
Freeze Specific Rows and Columns Together
This lets you freeze any number of rows at the top, any number of columns on the left, or both simultaneously.
The rule: Excel freezes everything above and to the left of the selected cell.To freeze row 1 AND column A:
- Click cell B2 (one row below and one column to the right of what you want frozen)
- View → Freeze Panes → Freeze Panes
To freeze the first 3 rows:
- Click cell A4 (one row below the last row you want frozen)
- View → Freeze Panes → Freeze Panes
To freeze the first 2 columns:
- Click cell C1
- View → Freeze Panes → Freeze Panes
The Freeze Panes Keyboard Shortcut
There is no single dedicated key for freezing panes, but the ribbon sequence is
fast once you know it.
| Sequence | What it does |
| Alt W F F | Freeze at the selected cell (or unfreeze if already frozen) |
| Alt W F R | Freeze Top Row |
| Alt W F C | Freeze First Column |
Freezing on a Mac
The rule is identical, only the menu location moves. On recent versions the
Freeze Panes button sits directly on the View tab, not inside a dropdown.
- Click the cell below and to the right of everything you want locked
- View → Freeze Panes
- Choose Freeze Panes, Freeze Top Row, or Freeze First Column
Freezing in Excel for the Web
Excel in a browser supports freezing, with one difference worth knowing: it only
offers the two simple options plus a general freeze, and the choice is saved to
the file for everyone who opens it.
- View → Freeze Panes
- Pick Freeze Top Row, Freeze First Column, or Freeze Panes
Split Panes
Split panes divide the window into separate scrollable sections — different from freezing. Splitting lets you view two different parts of the same worksheet simultaneously, like comparing data at row 5 with data at row 500.
To split: Click where you want the split → View → Split.The window divides into 2 or 4 panes (depending on whether you clicked a row border, column border, or cell intersection). Each pane scrolls independently.
To remove the split: View → Split again (it toggles), or double-click the split bar. Freeze vs. Split: Freeze locks one region while the other scrolls. Split creates two independent scrollable regions — neither is locked.Frequently Asked Questions
Why is Freeze Panes greyed out?
The most common reason is that the workbook is in Page Layout view or Page Break Preview. Freeze Panes only works in Normal view. Switch back: View → Normal.
The option is also unavailable if the sheet is protected. Unprotect the sheet first: Review → Unprotect Sheet.
Can I freeze rows in the middle of the spreadsheet?
No. Excel can only freeze rows at the top and columns at the left. You cannot freeze row 50 while scrolling through rows 1–49. If you need to compare a header row with data far below it, use Split Panes instead.
Does freezing affect printing?
No. Freeze panes only affect the on-screen view. For print headers (repeating rows at the top of every printed page), go to Page Layout → Print Titles → Rows to repeat at top.
Freeze Panes froze the wrong rows. Why?
Because Excel freezes everything above and to the left of the selected cell,
not the rows you highlighted. Selecting rows 1 to 3 and choosing Freeze Panes
freezes rows 1 and 2 only, since the active cell sits in row 3.
Click a single cell in column A, one row below the last row you want locked,
then freeze. To lock rows 1 to 3, click A4.
Freeze Panes is not working at all. What should I check?
In order:
- Are you in Normal view? Page Layout and Page Break Preview both disable it
- Is the sheet protected? Review → Unprotect Sheet
- Is the workbook shared or in a legacy co-authoring mode? Freezing can be
- Is a cell being edited? Press Esc first, because the ribbon is inert while
Can I freeze panes on more than one sheet at once?
No. Freezing is per worksheet, and grouping sheets does not carry it across. You
have to set it on each sheet, though the setting is saved with the file so you
only do it once.
Does freezing panes slow a large workbook down?
No. It is a view setting and costs nothing at recalculation time. If a large
sheet feels slow while scrolling, the cause is usually volatile formulas or
conditional formatting rules over whole columns, not the frozen panes.
My freeze line disappeared after reopening the file — did Excel lose it?
Freeze panes are saved with the workbook. If the line isn't visible, check: (1) you might be in Page Layout view — switch to Normal, (2) the freeze might still be active but the line is at the top of the visible area — scroll up to row 1 to see if row 1 is fixed.
Practice it
Freezing panes is muscle memory, so it is worth doing once on a sheet big enough
to need it. The interactive Excel exercises run in
the browser with no download, and the keyboard shortcut lessons
drill the Alt ribbon sequences this page uses.