How to Freeze Panes in Excel

Freeze Panes locks specific rows and/or columns in place so they stay visible while you scroll through the rest of the sheet. Use View → Freeze Panes → Freeze Top Row or Freeze First Column to lock a single row or column, or click the cell just below and to the right of what you want locked and choose Freeze Panes to lock a row and a column together.

How do I freeze the top row or the first column?

These are the two single-axis presets — use them when you only need to lock one row or one column, not both at the same time.

Freeze the top row

Steps:
1. Click any cell in your data
2. View tab → Freeze Panes
3. Click "Freeze Top Row"

Result: Row 1 stays visible when scrolling down
Use when: You have headers in row 1

Freeze the first column

Steps:
1. Click any cell in your data
2. View tab → Freeze Panes
3. Click "Freeze First Column"

Result: Column A stays visible when scrolling right
Use when: You have row labels in column A

How do I freeze a row and a column at the same time?

Click the cell diagonally below and to the right of the last row and column you want frozen — Excel freezes everything above and to the left of that cell in one action. There's no separate "freeze rows and columns" command: Freeze Top Row and Freeze First Column are just presets for the single-axis cases, and clicking a cell like B2, then running plain Freeze Panes, is what covers both at once.

Freeze row 1 AND column A:
1. Click cell B2 (one row down, one column right of A1)
2. View tab → Freeze Panes → Freeze Panes
3. Scroll anywhere → row 1 and column A both stay visible

Freeze rows 1-2 AND columns A-B:
1. Click cell C3
2. View → Freeze Panes → Freeze Panes
3. Rows 1-2 and columns A-B stay visible while scrolling

Freeze several columns only (wide sheet, no header row to lock):
1. Click cell D1
2. View → Freeze Panes → Freeze Panes
3. Columns A-C stay visible when scrolling right

General rule: click the cell at the intersection of the
first row and first column you want to keep scrollable.

Rule of thumb: click B2 for the typical data table with a header row and a label column — it's the combination people reach for most often. Before freezing, press Ctrl+Home to confirm you're at A1, since the freeze is relative to your current scroll position, not to the data itself.

How do I unfreeze panes in Excel?

Unfreezing removes the current freeze entirely. Excel supports only one freeze per sheet, so applying a new freeze automatically unfreezes the old one too.

Steps:
1. View tab → Freeze Panes
2. Click "Unfreeze Panes"

Note: closing and reopening the file does NOT undo a
freeze — the setting is saved with the file, so
collaborators will see it too. Unfreeze first if you
don't want to share it that way.

How is Split view different from Freeze Panes?

Split creates draggable dividers that let you scroll two or four sections of the same sheet independently, while Freeze Panes locks specific rows or columns in place with no independent scrolling of the frozen area.

Freeze Panes:
- Locks rows/columns permanently in place
- Only the unfrozen area scrolls
- One freeze per sheet — a new freeze replaces the old one

Split (View → Split):
- Creates 2 or 4 resizable panes
- Each pane scrolls independently
- Useful for comparing two distant parts of a large sheet
  side by side, not just keeping headers visible

Use Split when you need to view and compare two separate sections of a large sheet at once (row 5 next to row 5,000). Use Freeze Panes when you just need headers or labels to stay put while scrolling through the rest.

Why does Freeze Panes stop working or appear greyed out?

The most common causes are being in Page Layout view, working on a protected sheet, or clicking the wrong cell relative to what should freeze — all three take seconds to check.

Freeze Panes option is greyed out:
→ Check the View tab: are you in Page Layout view or
  Page Break Preview? Freeze Panes only works in Normal
  view — switch back with View → Normal

Can't freeze at all / nothing happens:
→ The sheet may be protected. Review tab → Unprotect
  Sheet (enter the password if one was set)

Freeze applies to the wrong rows/columns:
→ You clicked the wrong cell. Unfreeze first
  (View → Freeze Panes → Unfreeze Panes), press
  Ctrl+Home to return to A1, click the correct cell,
  then freeze again

Freeze line is invisible or hard to see:
→ Scroll to confirm: if the expected rows/columns stay
  put, it IS frozen — the divider line (a thin dark line
  in Excel 2016+, thicker in older versions) is just
  faint in some themes

Why did my freeze break after inserting rows or merging cells?

Freeze Panes tracks a fixed cell position, not the content in it — inserting rows above the freeze point or merging cells across the freeze boundary can shift what's actually locked without updating the freeze automatically.

Inserting rows above a freeze:
Freeze was set at B2 (row 1 + column A frozen).
Inserting a new row 1 pushes old row 1 to row 2 — the
freeze boundary itself does NOT move to compensate, so
you may now be freezing the wrong row. Re-freeze at the
correct cell after inserting rows.

Merged cells crossing the freeze boundary:
A merged cell that spans, say, A1:B1 while your freeze
is set at B2 can make the frozen/unfrozen split behave
inconsistently. Avoid merging cells that straddle the
row or column where the freeze boundary sits.

Freezing inside an Excel Table:
Freeze Panes still works inside a Table, but adding or
removing Table rows/columns shifts the data the same way
a manual insert does, which can shift the freeze boundary
with it.

If you insert or delete rows often, consider converting the range to an Excel Table — Tables handle structural changes more predictably than a plain range with a manual freeze.

What keyboard shortcuts freeze or unfreeze panes?

Excel has no single dedicated shortcut key for Freeze Panes, but the ribbon access keys let you drive the whole menu from the keyboard.

Windows (ribbon access keys):
Alt, W, F, F  →  Opens the Freeze Panes menu
Alt, W, F, R  →  Freeze Top Row
Alt, W, F, C  →  Freeze First Column

Mac:
No direct keyboard shortcut — use View → Freeze Panes

Combine it with Ctrl+Home to jump to A1 first: press Ctrl+Home, then Alt, W, F, F, and you can reset a freeze in about four keystrokes without touching the mouse. See more Excel keyboard shortcuts for similar time-savers.

What are common mistakes when freezing panes?

• Clicking a cell in row 1 or column A instead of below-and-right of both: clicking A1 freezes nothing; clicking B1 freezes only column A, not row 1 too
• Not scrolling to the top-left first: Freeze Panes is relative to your current scroll position — press Ctrl+Home before freezing to avoid freezing the wrong rows
• Expecting multiple independent freeze areas: only one freeze setting exists per sheet; a second freeze replaces the first, not adds to it
• Forgetting the freeze saves with the file: collaborators will see your freeze when they open it — unfreeze before sharing if that's not intended

What are best practices for freezing panes?

• Always freeze headers in large datasets
• Use a B2 freeze for most data tables (row 1 + column A)
• Unfreeze before sharing if recipients prefer a different view
• Test by scrolling after freezing to confirm the right rows/columns are locked
• Combine with filters for easier data exploration