If you’ve ever scrolled down a huge spreadsheet and lost track of which column is which, you already understand why I consider Freeze Panes one of the most quietly essential features in Excel. It keeps your header row (or first column, or both) visible on screen no matter how far you scroll. In this guide, I’ll walk you through every way I use Freeze Panes, plus a few tricks that took me years to discover.
What Freeze Panes Actually Does
Freeze Panes locks specific rows and/or columns in place so they stay visible while the rest of the sheet scrolls freely. It’s purely a viewing convenience — it doesn’t change your data, formulas, or formatting in any way. It just controls what stays “pinned” on your screen.
This is different from Split, which divides your window into separate scrollable panes. Freeze Panes locks a section in place; Split lets both sections scroll independently. I’ll touch on the difference again later.
When I Use Freeze Panes
- Working with a dataset that has hundreds or thousands of rows, where I keep forgetting what each column means.
- Reviewing a wide spreadsheet where the first column (like Employee Name or Product ID) needs to stay visible while I scroll right through months of data.
- Building financial models where both the top row (headers) and left column (line items) need to stay in view at all times.
Step-by-Step: Freezing the Top Row
This is the most common use case — keeping your header row visible as you scroll down.
- Go to the View tab.
- Click Freeze Panes.
- Choose Freeze Top Row.
That’s it. Now, no matter how far down you scroll, Row 1 stays visible at the top.
Step-by-Step: Freezing the First Column
If your important data is in the leftmost column instead:
- Go to the View tab.
- Click Freeze Panes.
- Choose Freeze First Column.
Now Column A stays visible while you scroll horizontally through the rest of your columns.
Step-by-Step: Freezing Both Rows and Columns Together
This is the one that took me a while to fully understand. If I want, say, the top 2 rows AND the first 2 columns frozen at the same time:
- Click the cell that is one row below and one column to the right of where I want the freeze to happen. For example, to freeze the first row and first column, I click cell B2.
- Go to View > Freeze Panes > Freeze Panes (the first option, not “Freeze Top Row”).
Excel freezes everything above and to the left of the cell I selected. So if I click cell C3 before freezing, I’ll lock the first two rows and the first two columns simultaneously.
Practical Example
Let’s say I’m working with a spreadsheet tracking monthly expenses: Column A has expense categories, Row 1 has month names (Jan, Feb, Mar…), and the data spans 24 months across many rows of categories.
- I click cell B2.
- I go to View > Freeze Panes > Freeze Panes.
Now, as I scroll down through dozens of expense categories, the month headers in Row 1 stay visible. And as I scroll right through 24 months of columns, the expense category names in Column A stay visible too. I never lose track of what I’m looking at.
Unfreezing Panes
To remove the freeze:
- Go to View > Freeze Panes.
- Click Unfreeze Panes.
This option only appears once you’ve already frozen something — otherwise you’ll just see the freeze options.
Freeze Panes vs. Split: What’s the Difference
I get asked this a lot, so here’s the simple version:
- Freeze Panes locks a row/column in place — it stays fixed while everything else scrolls.
- Split (View > Split) divides your screen into two or four independently scrollable sections. Both sections can scroll separately, which is useful for comparing two different parts of a large sheet side by side, but neither section is “locked.”
I use Freeze Panes 90% of the time because I usually just want my headers visible. I reach for Split only when I need to compare, say, row 5 and row 5,000 on screen at once.
Common Mistakes I See
- Selecting the wrong cell before freezing. People often click a header cell itself instead of the cell just below and to the right of the freeze point, which produces unexpected results.
- Trying to freeze in the middle of a merged cell region, which Excel doesn’t handle well — freeze points should generally avoid merged cells.
- Forgetting they’ve frozen panes, then getting confused when scrolling behaves strangely on a shared file.
- Freezing too many rows/columns, which defeats the purpose by leaving very little scrollable area on smaller screens.
- Confusing Freeze Panes with Print Titles. Freeze Panes only affects on-screen viewing — it does NOT repeat headers when you print. For that, you need Page Layout > Print Titles (which I’ll mention below).
Troubleshooting Tips
- If Freeze Panes doesn’t seem to work, check that you’re not inside a table with the wrong cell selected — click a plain cell first.
- If the freeze line appears in the wrong place, unfreeze, click the correct cell (one row below, one column right of your intended freeze point), and freeze again.
- If your headers aren’t repeating when you print, that’s expected — Freeze Panes is a screen-only feature. Use Page Layout > Print Titles > Rows to Repeat at Top for printed headers instead.
- If the freeze line seems to have disappeared after reopening the file, check that you saved after applying it — Freeze Panes settings are saved with the workbook.
Real-World Use Cases
- Accountants freezing the account name column while scrolling through months of transactions.
- Teachers freezing the header row while scrolling through a long list of student names and grades.
- Project managers freezing both the task name column and date header row in a Gantt-style tracker.
- Data analysts freezing headers while reviewing thousands of rows of raw survey or sales data.
- HR teams freezing the employee name column while scrolling across monthly attendance columns.
Best Practices I Follow
- Freeze only what you actually need — usually just the top row, or the top row plus first column. Over-freezing wastes screen space.
- Combine Freeze Panes with Print Titles if you plan to both view and print the sheet — they serve different purposes and you’ll likely want both set up.
- Set up Freeze Panes early when building a large spreadsheet, so you don’t lose track of headers while you’re still populating data.
- If sharing a file with others, leave Freeze Panes applied before saving — it makes the sheet far more usable for whoever opens it next.
- Remember that Freeze Panes is per-worksheet, not per-workbook. If you have multiple sheets, you’ll need to set it up on each one individually.
Freeze Panes is one of those features that feels almost too simple to write about, but once you get used to having your headers always in view, working without it feels genuinely uncomfortable. It’s a two-click habit that saves you from constantly scrolling back up to check what a column means.