How to freeze rows and columns in Excel

The short answer

To keep your headers on screen while you scroll: View > Freeze Panes > Freeze Top Row. To keep the first column on screen instead: View > Freeze Panes > Freeze First Column.

For anything else, there is one rule to remember, and it is the rule that stops the guessing: Excel freezes everything above and to the left of the cell you have selected.

The rule, applied

Select the cell that marks the first thing you want to be able to scroll, then choose Freeze Panes > Freeze Panes.

• Keep row 1 visible: select A2.
• Keep rows 1 to 3 visible: select A4.
• Keep column A visible: select B1.
• Keep row 1 and column A visible: select B2.
• Keep rows 1 to 2 and columns A to B: select C3.

Every case is the same instruction. Click the top-left cell of the part that should move, then freeze.

The two shortcut options (Freeze Top Row, Freeze First Column) are just this rule with the selection made for you, which is why they ignore whatever cell you were on.

Freezing the wrong rows is not a mistake, it is a two-second undo. Unfreeze Panes appears in the same menu, and there is nothing to lose by trying.

Fixing the usual problems

It froze the wrong rows. Go back to Freeze Panes > Unfreeze Panes, select the correct cell, and freeze again. The menu item changes name once something is frozen, which throws people the first time.

Nothing appears to be frozen. Look for a thin grey line where the freeze sits. If your window is scrolled so that the frozen rows are already out of view when you freeze, the result looks broken. Press Ctrl+Home to jump back to the top left, then freeze.

The option is greyed out. Switch to Normal on the View tab. Freeze Panes is unavailable in Page Layout view and while you are mid-edit in a cell.

It does not print that way. Freezing is a screen-only setting. To repeat headers on every printed page, use Page Layout > Print Titles > Rows to repeat at top. Two different features, and people mix them up constantly. Microsoft's Excel support documents both, and the Microsoft 365 Excel page shows which version you are on.

Freeze, split, or table

Three features overlap here, and picking the right one saves fiddling.

• Freeze Panes pins rows or columns while everything else scrolls. Best for headers on a long list.
• Split (View > Split) makes independent panes with their own scrollbars, so you can look at row 5 and row 4,000 at once. Best for comparing distant parts of one sheet.
• Format as Table (Ctrl+T) replaces the column letters with your header names as you scroll down. Best when you want the header behavior plus filtering, banding and structured references.

If the sheet is a list of records, a table is usually the better answer, because it brings filter arrows and automatic ranges with it. Freezing is the right tool when the layout is not a simple list, such as a report with a title block above the data.

When this is all you need

If you scroll past your headers a dozen times a day, this single setting is a real fix and no course is required. Take it and go.

The reason to learn more is the shape of the work, not the toolbar. If your day involves rebuilding the same summary by hand every week, the skill you are missing is pivot tables and lookups, not view settings. That is what the Excel certificate is for, with Excel data analysis after it, both inside the Business & Productivity school on one subscription.

Small tools like this are worth learning precisely because they are small. Ten of them add up to a spreadsheet that stops fighting you.