How to Freeze Panes in Excel

Introduction

You scroll down to row 50 and can't remember which column is Revenue and which is Cost. You scroll back up to check the headers, lose your place, and start over. Freeze Panes locks rows or columns in place so they stay visible no matter how far you scroll.

The Spreadsheet

Here's a quarterly sales report:

	A	B	C	D	E
1	Rep	Region	Q1	Q2	Q3
2	Sarah	East	8200	9100	8800
3	James	West	7500	6900	7200
4	Maria	East	11300	10800	11500
5	David	South	6400	7100	6800
6	Priya	West	9400	8800	9100
7	Marcus	South	5800	6200	5900

In a real workbook this might run 20 or 200 rows, with more columns stretching off screen to the right. Scrolling in either direction hides the labels you need to make sense of the numbers.

Freeze Top Row

The most common case. Go to View > Freeze Panes > Freeze Top Row. A thin line appears below row 1, and that row stays pinned as you scroll down.

Now you can scroll to row 50 or row 500 and the column headers remain at the top. Every column still has its label.

This option always freezes row 1 regardless of which cell is selected. If your headers are in row 3 (because rows 1 and 2 hold a title or blank space), this shortcut won't help. Use the custom option covered below.

Freeze First Column

Go to View > Freeze Panes > Freeze First Column. A thin line appears to the right of column A, and that column stays visible as you scroll right.

This is useful when column A contains names, IDs, or dates that give context to every row. Scroll right through columns F, G, H and you can still see which rep each number belongs to.

Like Freeze Top Row, this always freezes column A regardless of where your cursor sits.

Choosing What to Freeze

The first two options are shortcuts for common cases. The Freeze Panes option at the top of the menu gives you full control. It freezes everything above and to the left of the selected cell.

To freeze the header row and the rep names at the same time, select cell B2, then go to View > Freeze Panes > Freeze Panes.

Everything above row 2 (the header) and to the left of column B (the rep names) is now locked. Scroll down and the headers stay. Scroll right and the names stay.

The rule is simple: the freeze point is always above and to the left of the active cell.

Selected Cell	What Freezes
B2	Row 1 + Column A
C3	Rows 1-2 + Columns A-B
A4	Rows 1-3, no columns
D1	Columns A-C, no rows

Key takeaway: Select the cell where scrollable content should start. Everything above it and to the left of it stays locked in place.

If your headers span two rows (a title in row 1 and column names in row 2), select a cell in row 3 to freeze both rows above it.

Unfreezing

Go to View > Freeze Panes > Unfreeze Panes. This option replaces "Freeze Panes" in the menu whenever a freeze is active. All locked rows and columns return to normal scrolling.

You can only have one freeze configuration at a time. To change what's frozen, unfreeze first, select a new cell, and freeze again.

Freeze Panes vs Print Titles

Freeze Panes only affects what you see on screen. It has no effect on printing. If you print a multi-page spreadsheet, the headers still only appear on the first page.

To repeat headers on every printed page, go to Page Layout > Print Titles and set the rows to repeat at top. This is a separate setting from Freeze Panes, and you'll usually want both: Freeze Panes for scrolling, Print Titles for printing.

Conclusion

Freeze Top Row and Freeze First Column handle the standard cases. For anything else, select the cell where free scrolling should begin and use Freeze Panes to lock everything above and to the left.

For auto-expanding data ranges with built-in sorting and filtering, see our guide on Excel Tables. For summarizing large datasets without scrolling through every row, check out our guide on pivot tables.