Freeze Panes in Excel: Keep Headers in View

Freeze panes in Excel keeps chosen rows and columns on screen while you scroll, so the header row and the ID column never disappear. Click the cell below and to the right of what you want to keep, then choose View > Freeze Panes > Freeze Panes. This guide is for anyone working with long lists, from a 500-row export at work to a data set in a timed Excel test.

What does Freeze Panes do in Excel?#

Freeze Panes locks rows at the top and columns at the left of the sheet, so they stay visible while the rest scrolls. A thin line shows where the frozen area ends.

Without it, you scroll down to row 240 and see a column of numbers with no idea which one is "Amount" and which is "Tax". With the header row frozen, the labels sit above the data the whole time. Freeze the first column too, and the order ID or employee name stays on the left while you scroll across many columns.

Freezing changes only what you see. It doesn't move, sort or protect any data, and every formula works exactly as before.

How to freeze panes in Excel step by step#

The rule is simple: Excel freezes every row above the selected cell and every column to the left of it.

1. Press Ctrl+Home (Mac: fn+⌃←) to go to A1, so the top of the sheet is in view.
2. Click the cell just below the last row and just right of the last column you want to keep. For headers in row 1 and names in column A, click B2.
3. Go to the View tab and choose Freeze Panes > Freeze Panes.

Use this table to pick the right cell:

Step 1 matters more than it looks. Freeze Panes freezes what is on screen at that moment, so if rows 1 to 30 are scrolled out of view when you freeze, they stay hidden above the frozen line. Jumping to A1 first avoids that. The guide to moving around Excel with the keyboard covers Ctrl+Home and the other jumps.

Freeze Top Row and Freeze First Column#

For the most common case, a single header row, you don't need to select anything. Go to View > Freeze Panes > Freeze Top Row. To keep only column A in view, choose Freeze First Column.

These two options are quick, but you can't combine them. Choosing Freeze First Column after Freeze Top Row replaces the first freeze. To keep both, click B2 and use Freeze Panes instead.

Freeze panes keyboard shortcuts (Windows and Mac)#

Excel has no single-key shortcut for freezing, but Windows has fast Alt key sequences. Press the keys one after another, not together:

The first sequence works both ways: when panes are frozen, the same keys unfreeze them.

On a Mac, there is no Alt key sequence. Use the ribbon: on the View tab, choose Freeze Panes, Freeze Top Row or Freeze First Column. In Excel for the web, the same commands are under View > Freeze Panes.

If you work with the keyboard, pair this with the jumps that move you to the end of the data in one press. Our list of Excel shortcuts that make you look fast in a test puts them in the order worth learning.

How to unfreeze panes#

To remove the freeze, go to View > Freeze Panes > Unfreeze Panes. When panes are frozen, the first menu item changes its name from Freeze Panes to Unfreeze Panes, so it's the same place you clicked to freeze.

To move a freeze, for example from row 1 to row 3, unfreeze first, click the new cell, then freeze again.

Why is Freeze Panes greyed out or not working?#

Freeze Panes is greyed out in two common situations, and both have a quick fix:

• You're still editing a cell. If the cursor is blinking inside a cell, most ribbon commands are disabled. Press Enter or Esc first.
• The sheet is in Page Layout view. Freeze Panes isn't available there. Go to View > Normal.

Other problems look like Freeze Panes "isn't working":

• The wrong rows are frozen. You selected the wrong cell. Remember: rows above, columns to the left. Unfreeze and try again.
• Rows are missing above the line. You froze while scrolled down. Unfreeze, press Ctrl+Home, then freeze again.
• The frozen line is in the middle of the screen. You clicked a cell far down or far right. That freezes a large block, leaving little room to scroll.

Freeze panes vs Split vs Excel tables#

Freezing is the right tool for headers, but Excel has two related features that solve similar problems:

Freezing also has no effect on printing. To print the header row on every page, use Page Layout > Print Titles and set Rows to repeat at top. Our guide to printing an Excel sheet neatly walks through it.

Tips for working with long lists#

Freezing works best combined with fast navigation and selection:

• Freeze before you start scrolling. It's the first thing to do when you open a long export.
• Put totals above the header. A total in row 1 with headers in row 2, frozen at A3, keeps the answer visible while you scroll. The exercise on this page builds that layout.
• Jump instead of scrolling. Ctrl+↓ (Mac: ⌘↓) moves to the last filled cell, and the frozen headers tell you where you are.
• Select with Shift. Ctrl+Shift+↓ (Mac: ⌘⇧↓) selects to the bottom of the data. See how to select ranges fast in Excel.

When you clean a long list, freezing pairs well with Find and Replace in Excel and with Paste Special for converting formulas to values.

Practise it#

Freezing is about moving through big sheets with confidence. Practise the moves that go with it in Move around the sheet, where you use Enter, Tab, Ctrl+Home and the Name Box, then jump to the edge of your data to cross hundreds of rows in one key press. The exercise on this page adds the total that a frozen top row keeps in view.