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
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.
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.