Freezing a row in Excel is one of those features you didn't know you needed — until the moment you're scrolling through 500 rows of data and you've completely lost track of what each column means. It's a simple trick, but it saves real time. Practice with the free Excel practice test on PracticeTestGeeks (16 questions with answer explanations).
This guide walks you through exactly how to freeze a row in Excel, how to freeze multiple rows at once, and how to unfreeze them when you're done. You'll also find steps for freezing columns, since the process is nearly identical and just as useful.
When you freeze a row, it stays visible at the top of your screen no matter how far down you scroll. Think of it like pinning a sticky note to the top of your spreadsheet. Your header row — the one with labels like "Name," "Date," "Amount" — stays locked in place while all the data below it scrolls normally.
This is especially helpful when you're working with large datasets, financial reports, or any spreadsheet where losing track of your column headers would cause mistakes. Excel calls this feature Freeze Panes, and you'll find it under the View tab.
The fastest way to freeze just the first row — your header row — takes three clicks.
That's it. A thin gray line appears just below row 1, confirming it's frozen. Now scroll down — your header row stays right where it is.
One important note: Freeze Top Row always freezes row 1, regardless of which cell you have selected. If your actual headers are in row 2 (maybe row 1 has a title or logo), use the manual freeze method described below instead.
What if you need to keep the top two or three rows frozen? Excel handles this too — you just need to select the right cell before you apply the freeze.
A gray line will appear below row 2, and both rows will stay locked as you scroll. The rule is simple: whatever rows are above your selected cell get frozen.
This same logic applies if you want to freeze a row that isn't at the very top. If your headers start at row 3 (because rows 1 and 2 have merged title cells or a logo), click A4 and then use Freeze Panes.
Freezing a column works exactly the same way — just in the horizontal direction. If you want your first column (column A) to stay visible as you scroll right:
To freeze multiple columns, click the cell in the first row of the column to the right of the ones you want frozen. Want to freeze columns A and B? Click cell C1, then go to View → Freeze Panes → Freeze Panes.
You can freeze both rows and columns simultaneously — which is useful for wide spreadsheets where you need to keep both your headers and your row labels visible at the same time.
You'll see a gray line both below row 1 and to the right of column A. Now you can scroll in any direction and your headers stay in place.
This combination freeze is especially handy for financial models, project trackers, and comparison tables where you need to keep both column headers and row identifiers visible at all times. If you're working regularly with large data tables, it's worth building your broader Excel features knowledge — freeze panes is just one of dozens of view controls that make data work faster.
Facts verified Oct 17, 2026 against Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business. Dates that have passed are removed automatically.
Facts verified Oct 17, 2026 against Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business. Dates that have passed are removed automatically.
| Item | Detail | Official source |
|---|---|---|
| Number of questions (Excel Associate (MO-210)) | 33-37 questions | certiport.pearsonvue.com |
| Number of questions (Excel Expert (MO-211)) | 23-27 questions | certiport.pearsonvue.com |
| Time limit | 50 minutes (60 minutes seat time) | Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business |
| Passing score | 700 on a 1–1000 scale | certiport.pearsonvue.com |
| Retake policy | Wait 24h after 1st fail, 48h before each later retake; no annual limit | Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business |
| Validity | Valid 5 years (earned on/after Sept 23, 2025) | certiport.pearsonvue.com |
| Delivery | Proctored live-in-the-application exam via Certiport Authorized Testing Centers (in-center or remote-proctored) | Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business |
| Eligibility | No formal prerequisites; about 150 hours of instruction and hands-on experience recommended | Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business |
| Score release | Score report at end of exam; also in Certiport profile | certiport.pearsonvue.com |
Facts verified Oct 17, 2026 against Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business. Dates that have passed are removed automatically.
Interactive Excel resources on PracticeTestGeeks, free to start:
Unfreezing is even easier than freezing. Once you've applied any freeze to a spreadsheet, the Freeze Panes menu changes to show an Unfreeze Panes option.
That removes all frozen rows and columns at once. There's no way to unfreeze just the rows while keeping the columns frozen — it's all or nothing. If you want to keep columns frozen but remove the row freeze, unfreeze everything and then re-apply just the column freeze.
If the Freeze Panes option is grayed out or not behaving as expected, here are the most common reasons:
Freeze Panes only works in Normal view. If you're in Page Layout or Page Break Preview mode, the option gets disabled. Go to View → Normal to switch back, then try again.
A protected sheet or workbook can prevent you from changing view settings. Check under the Review tab to see if sheet protection is turned on. You'll need to unprotect it first — which requires the password if one was set.
Files saved in .xls format (the old Excel 97-2003 format) sometimes behave oddly with freeze panes. Save the file as .xlsx and try again.
Excel only allows one freeze at a time. If there's already a freeze active, Freeze Top Row and Freeze First Column won't do what you expect — they'll replace the existing freeze rather than add to it. Unfreeze first, then reapply with the right settings.
The process is essentially the same in both Excel Online (the browser version) and Excel for Mac:
Freeze settings are saved with the file — so a freeze you applied in the desktop app carries over when you open the file in a browser or share it with a colleague. They'll see the same locked rows you set up, no explanation needed.
A few practical things worth knowing once you start using freeze panes regularly:
Understanding these view controls is part of building real proficiency with Excel spreadsheet work. Once you've mastered freeze panes, the next logical step is learning how to use named ranges, data validation, and conditional formatting — the tools that turn a basic spreadsheet into something genuinely powerful.
There's no direct one-key shortcut for freeze panes, but you can use the keyboard to navigate there quickly:
So the full keyboard sequence to freeze the top row is: Alt → W → F → R. Sounds like a lot — but after doing it a few times, your fingers remember it automatically.
If you use freeze panes constantly and want even faster access, you can add it to the Quick Access Toolbar (the small icons in the top-left corner of Excel) so it's always one click away regardless of which tab you're on.
Let's be concrete. Here are the situations where freezing rows makes a real difference:
In every one of these cases, scroll down without a frozen header and you're constantly scrolling back up to check what each column means. It's a small friction point — but multiplied across a workday, it adds up fast.
Try these questions from our free Excel practice tests. The correct answer and an explanation follow each question.
How do you freeze the top row in Excel so it remains visible while scrolling down?
Answer: B. View tab → Freeze Panes → Freeze Top Row
On the View tab, clicking Freeze Panes and then Freeze Top Row locks row 1 in place during vertical scrolling.
Which tab on the Excel ribbon contains the 'Freeze Panes' option?
Answer: A. View
Freeze Panes is located in the Window group on the View tab.
What happens when you freeze panes in Excel?
Answer: B. Selected rows or columns remain visible while scrolling
Freezing panes locks specific rows or columns so they stay visible as you scroll through the worksheet.
In what year was Microsoft Excel first released for Windows?
Answer: A. 1987
Excel 2.0 for Windows was released in 1987. The first version of Excel (1.0) was actually released for the Macintosh in 1985.
The most common reason is that your sheet is in Page Layout view rather than Normal view. Go to View → Normal, and the option should become available. Sheet protection can also disable it — check under Review → Unprotect Sheet if that's the case.
Yes. Click on the first cell of the row immediately below the rows you want to freeze (e.g., click A3 to freeze rows 1 and 2), then go to View → Freeze Panes → Freeze Panes. Any rows above your selected cell will be frozen.
No — freeze panes only controls what you see on screen while scrolling. If you want a header row to repeat on every printed page, set that up separately under Page Layout → Print Titles → Rows to repeat at top.
Click the cell that sits below the rows and to the right of the columns you want frozen. To freeze row 1 and column A simultaneously, click cell B2. Then go to View → Freeze Panes → Freeze Panes.
Go to View → Freeze Panes → Unfreeze Panes. This removes all active freezes (both rows and columns) at once. If you want to change which rows are frozen, unfreeze first and then reapply the freeze from the correct cell.
Yes. Excel Online supports freeze panes under the View menu with the same options: Freeze Top Row, Freeze First Column, and Freeze Panes. Freeze settings you apply in the browser version are saved with the file.
Absolutely. Freezing a row only locks its position on screen during scrolling — it doesn't prevent you from clicking, editing, or entering data in those cells. You can still interact with frozen cells exactly as normal.
People sometimes confuse freeze panes with Excel's Split feature. Here's the difference: split divides your spreadsheet window into two or four independent scrollable sections. Each section can scroll to a different part of the sheet at the same time. Freeze panes keeps specific rows or columns locked while everything else scrolls freely.
For most everyday use — keeping header rows visible while scrolling through data — freeze panes is the right tool. It's simpler, saves with the file, and doesn't visually change your spreadsheet layout. Split view is better when you need to compare data from two distant areas of the same sheet simultaneously.
Freeze panes is one of those Excel features that feels slightly awkward the first couple of times, then becomes completely automatic. The key insight: always select the cell below and to the right of what you want to freeze before clicking Freeze Panes. Once that logic clicks, you'll never have to look it up again.
From there, it's worth exploring the broader set of view controls and data tools that make Excel genuinely productive. Things like conditional formatting, VLOOKUP, PivotTables, and named ranges — the skills that separate basic users from people who can actually build something useful. If you're preparing for a role that requires Excel proficiency, or just want a benchmark for where you stand, an Excel skills test can help you identify gaps before they show up on the job.
If you're aiming for a formal credential, the Microsoft Excel certification path is worth exploring — the MOS (Microsoft Office Specialist) exam validates your skills against an industry-recognized standard that hiring managers recognize. And if you're just starting out or want a structured overview, the Excel features guide covers the full toolkit from formulas to formatting.
Whether you're managing budgets, tracking project milestones, or trying to make sense of a data export — knowing how to freeze rows in Excel makes the whole process less frustrating. It's a small feature with a real impact on how smoothly your day goes.