One of the most annoying things in Excel is losing your header row the moment you scroll down.
You start with a clean table. Everything makes sense. Then you move a little farther down the sheet, and suddenly you can’t remember which column is which. Now you’re stuck scrolling back up just to check whether you’re looking at Date, Category, Amount, or Total.
The good news is that Freeze Panes can fix this.
Once you use it, your headers stay visible while you scroll through the rest of the worksheet. It’s one of the simplest ways to make a spreadsheet easier to read.
If you’re working with more than a few rows of data, frozen headers can save you time and frustration.
Instead of guessing what each column means, you can keep your labels in view the whole time. This is especially helpful for:
budgets
expense trackers
customer lists
inventory sheets
gradebooks
any spreadsheet with lots of rows
It is a small feature, but it makes a big difference.
(For Mac, see below.)
If your headers are in the very first row, Excel makes this easy.
Open your worksheet.
Go to the View tab.
Click Freeze Panes.
Choose Freeze Top Row.
Figure 1.
That’s it. Now when you scroll down, the top row will stay in place.
Sometimes your worksheet has a title at the top, or a few blank rows, and the actual headers start lower down. In that case, do this instead:
Click the row number to select the row just below the headers you want to keep visible.
Go to the View tab.
Click Freeze Panes.
Choose Freeze Panes from the dropdown menu.
Excel will freeze everything above the row you selected.
So if your headers are on row 1-3, select row 4 first, then use Freeze Panes.
If you have names or labels in the first column and want them to stay visible while you scroll to the right, you can also freeze the first column.
To do that:
Go to the View tab.
Click Freeze Panes.
Choose Freeze First Column.
This is useful when your spreadsheet is wide and you need to keep row labels in sight.
What if you need to freeze header rows and a column at the same time? That is just as simple.
Select the single cell that is just below the header row and just to the right of the column you want to freeze.
Figure 2.
For example, if the lowest header row is Row 3, and you also want to freeze Column A, you would select cell B4.
Go to the View tab.
Click Freeze Panes.
Choose Freeze Panes.
If you want to remove the frozen section later:
Go to the View tab.
Click Freeze Panes.
Choose Unfreeze Panes.
That returns the worksheet to normal scrolling.
On a Mac, there are no shortcut options like Freeze Top Row or Freeze First Column. Instead, you select the row below what you want to freeze, or the column to the right of what you want to freeze, or the single cell below and to the right if you want to freeze both a row and a column.
Figure 3.
Remember to click the row number on the left of the row, or the column letter at the top of a column to select entire rows or columns.
Then click Window at the very top of the Mac screen, and choose Freeze Panes.
If you click the wrong row before choosing Freeze Panes, Excel will freeze the wrong section of the worksheet. This is where many beginners get tripped up.
So remember this rule:
Click below the row you want to keep visible.
Click to the right of the column you want to keep visible.
If you want to freeze both at the same time, click the single cell that is below the row and to the right of the column you want to freeze.
That one rule will save you a lot of confusion.
Freeze Panes is one of those Excel features that feels minor until you start using it. Then you wonder how you ever worked without it.
If your headers keep disappearing when you scroll, this is the fix. It takes only a few seconds, and it makes large worksheets much easier to use.