Excel’s Freeze Panes feature is supposed to make large spreadsheets easier to work with by keeping important rows or columns visible while you scroll.
Read this article to learn more about using the freeze feature in Excel.
But sometimes it doesn’t work the way you expect.
Excel might freeze the wrong rows. Your column headings may still disappear. The Freeze Panes option might be unavailable, or you may have trouble freezing both a row and column at the same time.
Most of these problems have simple solutions.
Here are some of the most common Excel Freeze Panes problems and how to fix them.
Problem 1: Excel Freezes the Wrong Rows
This is probably the most common Freeze Panes problem.
Suppose you want to freeze only Row 1, but Excel freezes several rows instead.
The problem is usually the cell you selected before choosing Freeze Panes.
Excel freezes every row above the selected cell.
For example:
If you select A5 and then choose:
View → Freeze Panes → Freeze Panes
Excel freezes Rows 1 through 4.
How to Fix It
First remove the current frozen panes:
View → Freeze Panes → Unfreeze Panes
Then select the correct cell.
If you want to freeze only Row 1, you can simply choose:
View → Freeze Panes → Freeze Top Row
You don’t need to select a particular cell first.
Problem 2: Excel Freezes Too Many Columns
The same rule applies to columns.
Excel freezes every column to the left of your selected cell.
For example, if you select D1 and use Freeze Panes, Excel freezes:
- Column A
- Column B
- Column C
If you only wanted Column A frozen, this isn’t the result you expected.
How to Fix It
Go to:
View → Freeze Panes → Unfreeze Panes
Then choose:
View → Freeze Panes → Freeze First Column
If you want to freeze a custom number of columns, select the column immediately to the right of the columns you want frozen.
For example:
Freeze Columns A and B → Select C1
Then choose:
View → Freeze Panes → Freeze Panes
Problem 3: I Can’t Freeze a Row and Column at the Same Time
Excel can freeze rows and columns simultaneously.
The trick is selecting the correct cell first.
Suppose you want:
Row 1 to remain visible when scrolling down.
and:
Column A to remain visible when scrolling right.
Select:
B2
Then go to:
View → Freeze Panes → Freeze Panes
Why B2?
Excel freezes everything:
Above the selected cell
and:
To the left of the selected cell
Row 1 is above B2, and Column A is to the left of B2.
Both will therefore remain frozen.
Another Example
If you want to freeze:
Rows 1 and 2
and:
Columns A and B
select:
C3
Then choose:
View → Freeze Panes → Freeze Panes
Problem 4: Freeze Top Row Freezes the Wrong Row
The Freeze Top Row command always freezes the first row of the worksheet.
It doesn’t mean “freeze whichever row is currently at the top of my screen.”
Suppose your column headings are in Row 4.
If you choose:
View → Freeze Panes → Freeze Top Row
Excel will freeze Row 1—not Row 4.
How to Fix It
If you need Rows 1 through 4 to remain visible, select:
A5
Then choose:
View → Freeze Panes → Freeze Panes
Remember that Freeze Panes works from the beginning of the worksheet.
You can’t use it to freeze only Row 4 while allowing Rows 1 through 3 to scroll normally.
Problem 5: My Headers Still Disappear When I Scroll
If your column headings still disappear, first check whether the correct row is actually frozen.
Your headings aren’t necessarily in Row 1.
For example:
Row 1: Monthly Sales Report
Row 2: Updated October 2026
Row 3: Product | Region | Sales | Profit
In this case, choosing Freeze Top Row freezes only the report title.
Your actual headings in Row 3 will still disappear when you scroll.
How to Fix It
Select:
A4
Then go to:
View → Freeze Panes → Freeze Panes
Rows 1 through 3 should now remain visible.
Problem 6: I Can’t Find Unfreeze Panes
Once something is frozen, Excel changes the Freeze Panes menu.
Go to:
View → Freeze Panes
You should see:
Unfreeze Panes
Select it to remove the existing frozen area.
After that, you can create a different Freeze Panes setup.
This is useful because you don’t need to somehow “edit” your existing frozen panes.
Simply unfreeze them and start again.
Problem 7: Freeze Panes Is Grayed Out
If the Freeze Panes option is unavailable or grayed out, check what you’re currently doing in Excel.
First, make sure you aren’t actively editing a cell.
Press:
Enter
or:
Esc
to finish or cancel the current cell edit.
Then try the Freeze Panes menu again.
You should also check your current workbook view.
Go to the:
View tab
and switch to:
Normal
Then check Freeze Panes again.
If the command is still unavailable, try saving the workbook, closing Excel, and reopening the file.
In managed work or school environments, certain workbook or application restrictions can also affect which commands are available.
Problem 8: Freeze Panes Seems to Have Disappeared
You open a spreadsheet that you thought had frozen rows, but they no longer appear frozen.
First, scroll to the top-left area of the worksheet and check again.
Frozen panes can sometimes be less obvious depending on where you’re currently positioned in a large worksheet.
Look for a dividing line underneath the frozen rows or to the right of the frozen columns.
Then try scrolling.
If the rows or columns move with everything else, Freeze Panes isn’t currently active.
You can recreate it through:
View → Freeze Panes
Problem 9: There’s a Strange Line Across My Spreadsheet
You may notice a dark or slightly thicker line running across your worksheet.
Before assuming something is wrong, check whether it marks a frozen pane.
For example, if Row 1 is frozen, Excel may display a dividing line underneath it.
If Column A is frozen, you may see a vertical line to its right.
This line helps show where the frozen area ends and the scrollable portion begins.
It doesn’t affect your spreadsheet data.
If you don’t want the frozen area anymore, choose:
View → Freeze Panes → Unfreeze Panes
Problem 10: My Spreadsheet Is Divided Into Multiple Scrollable Sections
If your worksheet appears to be divided into sections that can scroll independently, you may be using Split rather than Freeze Panes.
The two features can look similar, but they work differently.
Freeze Panes keeps selected rows or columns visible while the rest of the worksheet scrolls.
Split divides the Excel window into separate sections that can scroll independently.
How to Fix It
Go to:
View → Split
If Split is currently active, selecting it again should remove the split.
You can then use:
View → Freeze Panes
to create the frozen area you actually want.
Problem 11: Freeze Panes Doesn’t Repeat My Headers When Printing
This isn’t actually a Freeze Panes problem.
Freeze Panes controls what stays visible on your screen.
It doesn’t automatically repeat your headings at the top of every printed page.
For example, freezing Row 1 will keep Row 1 visible while you scroll in Excel, but that doesn’t mean Row 1 will automatically print on every page.
How to Repeat Headers When Printing
Use Excel’s Print Titles feature instead.
Go to:
Page Layout → Print Titles
From there, you can specify which rows should repeat at the top of each printed page.
A simple way to remember the difference is:
Freeze Panes = screen
Print Titles = printing
Problem 12: I Only Want to Freeze One Row in the Middle of the Spreadsheet
Suppose you want Row 10 to remain visible while Rows 1 through 9 continue scrolling.
Unfortunately, that’s not how Freeze Panes works.
Frozen rows always begin at the top of the worksheet.
If you select A11 and use Freeze Panes, Excel freezes:
Rows 1 through 10
It doesn’t freeze only Row 10.
The same limitation applies to columns.
Frozen columns always begin with Column A.
Problem 13: I Selected the Row, but Excel Froze Something Else
You don’t normally need to select an entire row or column when using the custom Freeze Panes command.
Instead, select a cell that tells Excel where the frozen area should end.
Remember:
Excel freezes the rows above your selected cell and the columns to its left.
For example:
| You Want Frozen | Select |
|---|---|
| Row 1 | A2 |
| Rows 1–2 | A3 |
| Column A | B1 |
| Columns A–B | C1 |
| Row 1 + Column A | B2 |
| Rows 1–2 + Column A | B3 |
| Row 1 + Columns A–B | C2 |
| Rows 1–2 + Columns A–B | C3 |
Then choose:
View → Freeze Panes → Freeze Panes
If you’re having trouble remembering how Freeze Panes works, this table solves most selection problems.
Problem 14: I Froze the Top Row, but I Also Need the First Column
The commands Freeze Top Row and Freeze First Column are convenient shortcuts, but if you need both at the same time, use the regular Freeze Panes command.
First choose:
View → Freeze Panes → Unfreeze Panes
Then select:
B2
Now choose:
View → Freeze Panes → Freeze Panes
This freezes both:
Row 1 + Column A
If you need more rows or columns frozen, move your selected cell accordingly.
Problem 15: Freeze Panes Isn’t Keeping the Part of the Spreadsheet I Expected
When Freeze Panes produces a strange result, look at the cell you selected before turning it on.
That’s usually the answer.
Imagine you selected D6.
Excel interprets that as:
Freeze everything above Row 6
and:
Freeze everything to the left of Column D
That means:
Rows 1–5
and:
Columns A–C
will remain frozen.
If that isn’t what you wanted, unfreeze the panes and select a different cell.
Problem 16: The Frozen Area Takes Up Too Much of My Screen
You can technically freeze many rows and columns, but that doesn’t always mean you should.
For example, freezing the first 15 rows on a laptop screen could leave very little room for the rest of your spreadsheet.
If the frozen section feels too large:
- Go to View → Freeze Panes → Unfreeze Panes.
- Decide which information you actually need to see while scrolling.
- Select a new cell.
- Apply Freeze Panes again.
Usually, freezing only the column headings and perhaps one identifying column provides the best balance.
For example:
Row 1 + Column A
is a useful setup for many large spreadsheets.
Problem 17: Freeze Panes Doesn’t Work the Same in My Version of Excel
The exact location or appearance of Excel commands can vary depending on which version you’re using.
Excel for Windows, Excel for Mac, Excel for the web, and mobile versions of Excel don’t always have identical interfaces or feature sets.
If the instructions in this guide don’t exactly match what you see, look for Freeze Panes under the View options in your version of Excel.
The basic idea remains the same: frozen rows and columns stay visible while you scroll through the worksheet.
The Most Important Freeze Panes Rule
If you remember only one thing from this guide, make it this:
Excel freezes everything above and to the left of your selected cell.
Suppose you select:
C4
Excel freezes:
Rows 1 through 3
and:
Columns A and B
That one rule explains most unexpected Freeze Panes behavior.
Quick Troubleshooting Checklist
If Freeze Panes isn’t working the way you expect, try these steps:
- Go to View → Freeze Panes → Unfreeze Panes.
- Decide exactly which rows and columns you want to remain visible.
- Select the cell immediately below those rows and to the right of those columns.
- Go to View → Freeze Panes → Freeze Panes.
- Scroll down and to the right to test the result.
- If the worksheet is divided into independently scrolling sections, check whether Split is enabled.
- If Freeze Panes is unavailable, exit cell-editing mode and switch to Normal view.
- Remember that Freeze Panes doesn’t control which headings repeat when printing.
In most cases, unfreezing the worksheet and selecting the correct cell before freezing it again will solve the problem.
Bottom Line
Most Excel Freeze Panes problems aren’t caused by Excel being broken.
They’re caused by the way Excel determines what should stay frozen.
The key rule is:
Rows above the selected cell are frozen.
Columns to the left of the selected cell are frozen.
So if you want to freeze Row 1 and Column A, select B2 before choosing Freeze Panes.
If Excel freezes the wrong area, don’t worry about trying to modify the existing frozen panes. Simply choose:
View → Freeze Panes → Unfreeze Panes
Then select the correct cell and try again.
Once you understand how the selected cell controls Freeze Panes, the feature becomes much easier to use.