If you have ever scrolled down a large spreadsheet and lost track of which column is which because your header row disappeared off the top of the screen, freeze panes is the answer. It locks one or more rows or columns in place so they stay visible no matter how far you scroll. It is one of those features that looks minor but makes working with large datasets significantly less frustrating.
Why Freezing Rows and Columns Matters
Most spreadsheets have a header row — column names like “Date”, “Customer”, “Invoice Number”, “Amount”. When your data runs to hundreds of rows, as soon as you scroll down past row 20 or so, those headers disappear. You end up having to scroll back to the top constantly to remind yourself what each column contains.
The same problem can happen horizontally. If you have many columns and scroll right, you lose the first column (often containing names or IDs) and can no longer tell which row is which.
Freeze panes solves both problems. The frozen rows and columns scroll with your screen position — except they do not move. Everything else scrolls normally while they stay put.
How to Freeze the Top Row
This is the most common use case. If row 1 contains your column headers, here is how to lock it in place:
- Click anywhere in the spreadsheet — it does not matter which cell you are on for this specific option.
- Go to the View tab on the ribbon.
- Click Freeze Panes in the Window group.
- Select Freeze Top Row from the dropdown menu.
A thin dark line will appear below row 1, indicating it is frozen. Scroll down and row 1 stays visible at all times.
How to Freeze the First Column
If column A contains names, IDs, or other identifiers you want to keep visible when scrolling right:
- Click anywhere in the spreadsheet.
- Go to View > Freeze Panes.
- Select Freeze First Column.
A thin dark line appears to the right of column A. Scroll right and column A stays locked on the left side of the screen.
How to Freeze Both a Row and a Column at the Same Time
Neither “Freeze Top Row” nor “Freeze First Column” lets you do both at once — that is what the main “Freeze Panes” option is for, and it uses your cell selection to decide what to freeze.
The rule is: Excel freezes everything above and to the left of the selected cell. So to freeze row 1 and column A simultaneously:
- Click on cell B2 — one column to the right and one row below where you want the freeze to start.
- Go to View > Freeze Panes.
- Select Freeze Panes (the first option in the list, not “Top Row” or “First Column”).
Row 1 and column A are now both frozen. You will see a dark line below row 1 and to the right of column A. Scroll in any direction and both stay visible.
Freezing Multiple Rows or Columns
You can freeze more than one row or column using the same technique. The key is to select the right starting cell:
- To freeze the top 3 rows (rows 1, 2, and 3), click on cell A4, then go to View > Freeze Panes > Freeze Panes.
- To freeze the first 2 columns (columns A and B), click on cell C1, then freeze panes.
- To freeze both the first 3 rows and the first 2 columns, click on cell C4, then freeze panes.
The pattern is always the same: click on the cell that is directly below and to the right of everything you want frozen.
What the Freeze Line Looks Like
After applying freeze panes, Excel shows a slightly thicker, darker grey line along the boundary of the frozen area. This line does not print — it is just a visual indicator on screen. If you do not see it, check your zoom level — at very high zoom the line can be easy to miss.
The frozen rows and columns will also remain at the top and left of the screen even as you scroll through thousands of rows.
How to Unfreeze Panes
To remove any freeze panes setting:
- Go to View > Freeze Panes.
- Click Unfreeze Panes.
This removes all freeze panes in one go. There is no way to unfreeze just one axis while keeping the other — you would need to unfreeze everything and then set up a new freeze for just the part you want to keep.
Common Mistake: Freeze Panes Is Greyed Out
If the Freeze Panes option appears greyed out and unclickable, it is almost always because your spreadsheet is in cell edit mode. Press Escape to exit edit mode, then try again. This happens when you have double-clicked into a cell (or pressed F2) and Excel is waiting for you to finish editing.
Freeze Panes can also be unavailable if the workbook is protected. If that is the case, you will need to unprotect the sheet first via Review > Unprotect Sheet.
Split Panes as an Alternative
Split panes are a similar but different feature. Instead of locking rows or columns in place, Split creates a divided view of the same sheet — you can scroll each pane independently. This lets you compare two distant parts of your spreadsheet side by side.
To create a split, go to View > Split. Excel splits the view at your current cell position. You can drag the split dividers to adjust where the division is.
Split panes and freeze panes cannot be used at the same time. If you apply one, the other will replace it.
Split panes are less commonly used than freeze panes, but they are handy when you need to cross-reference data from different parts of the same sheet — for example, comparing row 5 with row 500 without switching back and forth.
