How to Freeze Panes in Excel

Freeze Panes locks chosen rows and columns in place so they stay on screen while the rest of the sheet scrolls. In a large financial model this keeps your period headers across the top and your line-item labels down the left always visible, so a number deep in the grid never loses its row and column context.

What freezing does and when to use it

Freeze Panes splits the sheet into fixed and scrolling regions. Rows above and columns to the left of your chosen point stay pinned while you move through the data.

Use it on any sheet too wide or too tall to fit one screen: a monthly P and L with many periods, a long schedule of assumptions, or a transaction list. The moment you lose sight of the header while scrolling, freezing is the fix.

Step by step

The trick is that Excel freezes everything above and to the left of the active cell, so select the right cell first.

1. To freeze just the top row, go to View > Freeze Panes > Freeze Top Row.
2. To freeze just the first column, go to View > Freeze Panes > Freeze First Column.
3. To freeze both, click the cell below and to the right of the area you want pinned.
4. With that cell selected, go to View > Freeze Panes > Freeze Panes.
5. To undo, go to View > Freeze Panes > Unfreeze Panes.

Select B2 to pin both row 1 and column A at once before choosing Freeze Panes.

A model use case

On a model with twelve forecast months across the top and forty line items down the side, select B2 and freeze. The month headers and the line-item labels both stay put, so when you scroll to row 38 and column N you still know it is, say, Net Income for October.

On a wide multi-year output, freeze a few header rows and the label column together by selecting the cell just inside the data block. It makes review and data entry far less error prone.

• Pins headers and labels so deep cells keep their context.
• Freeze Top Row and Freeze First Column are one-click shortcuts.
• Freezing is a view setting and changes no data.

Pitfalls and limits

The most common mistake is selecting the wrong active cell, which freezes more or fewer rows and columns than intended. Remember it pins everything above and left of the selection, so to freeze the top two rows you select a cell in row 3.

Freeze Panes and Split are mutually exclusive; turning one on clears the other. Frozen panes are saved with the workbook and travel to whoever opens it, so unfreeze before sharing if a recipient expects a normal view. Printing ignores frozen panes, which is what Print Titles is for instead.