How to Freeze Panes in Excel — Top Row, First Column, Any Cell, and When It's Grayed Out

Three ways to freeze — top row, first column, or from a cell

The practice file is a made-up stationery shop's sales sheet: row 1 holds the headers No. · Item · Jan–Dec · Total, and rows 2–61 hold 60 items (columns A–O). On this PC the Excel window at 100% shows only 18 rows and columns up to S, so the header disappears after a few turns of the mouse wheel.

If a single header row is all you need, Freeze Top Row is quickest. On this PC it froze only row 1 no matter which cell was selected (it was E10 at the time). When you also need a column on the left — the item names here — use Freeze Panes.

Which cell to select — rows above it and columns left of it

Microsoft's help puts it this way: select the cell below the rows and to the right of the columns you want to keep visible when you scroll. These are the cells tested on this PC:

• Row 1 + columns A:B → select C2 (froze 1 row above · 2 columns left)
• Row 1 + column A → select B2 (1 row · 1 column)
• A two-row header (rows 1–2) → select A3 (2 rows, no columns)
• Columns A:B only → select C1 (2 columns, no rows)

1. 1Scroll to the top first (with nothing frozen, Ctrl+Home jumps to A1 — Microsoft's keyboard shortcut list). Trap 1 below explains why.
2. 2Select the cell just below the rows and just right of the columns you want to keep (C2 here).
3. 3View tab > Freeze Panes > Freeze Panes.
4. 4To undo it, same place: Unfreeze Panes — while panes are frozen, that's what the first item in the menu reads. On this PC, running the same command again on a frozen sheet also unfroze it.

Trap 1 — freezing while scrolled down hides your header

Freeze Panes doesn't start at row 1 — it starts at whatever row is at the top of the screen. With the sheet scrolled down to row 15, freezing from C20 put the line under row 19 and froze five rows, 15–19. Scrolling all the way up afterwards still started at row 15: rows 1–14, header included, were out of reach.

Trap 2 — freezing from A1 splits the screen in the middle

With A1 selected there are no rows above and no columns to the left. On this PC, choosing Freeze Panes from A1 drew the lines roughly in the middle of the window, freezing rows 1–9 and columns A–I (where exactly depends on the window size). Excel's own built-in message text also says freezing doesn't work while the top-left cell is selected.

If you only meant to lock the header, unfreeze and use Freeze Top Row, or select A2 and use Freeze Panes.

Freeze Panes is grayed out — Page Layout view

With the sheet frozen at C2, switching to View > Page Layout turned freezing off, and Freeze Panes, Freeze Top Row and Freeze First Column all became gray (unclickable). Switching back to Normal view did not bring it back — the sheet was simply unfrozen. Excel's built-in message for this says Page Layout view isn't compatible with Freeze Panes and that continuing unfreezes the sheet.

So if the button is gray, go back to Normal view (View > Normal, or the view buttons at the bottom right) and freeze again. In Page Break Preview the freeze stayed on.

Printing the header on every page — freezing doesn't print

Freezing only affects the screen. Saved to PDF with C2 frozen, the sheet came out as 4 pages, and page 2 started straight with '43 Stapler (blue) …' — no header. For printed pages you set the repeating rows separately: Page Layout tab > Print Titles.

When the sheet is also too wide for one page (here Jan–Aug on one set of pages and Sep–Total on the next), the later pages only got No. and Item after adding $A:$B to Columns to repeat at left. Per Microsoft's help, Print Titles opens the Sheet tab of the Page Setup dialog; type $1:$1 into Rows to repeat at top, or click the box and then the row 1 heading. The command is gray while you're editing a cell or when no printer is installed.

Where people get stuck

• No Freeze Panes on the View tab: Microsoft says a missing View tab usually means Excel Starter, which doesn't support every feature
• Freeze Panes is gray: check whether you're in Page Layout view — switching to it grayed out all three commands on this PC
• The lines are in the wrong place: you froze while scrolled (Trap 1) or from A1 (Trap 2) — unfreeze and redo it from the top
• The freeze vanished: after a trip through Page Layout view it stayed off; freeze again in Normal view
• Page 2 of the printout has no header: freezing doesn't print — Page Layout > Print Titles > Rows to repeat at top $1:$1

Practice

Open the practice file (sales sheet, nothing frozen) and try this:

1. 1Press Ctrl+Home, select C2, then View > Freeze Panes > Freeze Panes.
2. 2Scroll to row 40 and column I (July for Notebook (blue)). If I40 shows 50 and you can still see the header row and columns A:B, it worked.
3. 3Page Layout > Print Titles → Rows to repeat at top $1:$1 · Columns to repeat at left $A:$B → OK. Check in Print Preview (Ctrl+P) that all 4 pages show the headers.

The answer file is saved frozen at C2 with those print titles ($1:$1 and $A:$B).

FAQ