How to Freeze a Row in Excel So Headers Stay Visible

Picture scrolling down a sheet with hundreds of rows, only to realize the column headers vanished three screens ago. That’s exactly what frozen panes fix.

Freezing keeps your header row or key columns in place while the rest of the sheet scrolls, so every number still has its label.

The short answer: select the cell in the row just below the one you want to keep visible, then turn on Freeze Panes from the View tab.

This guide covers that on Windows and Mac, plus unfreezing, fixes, and keyboard routes for keeping your hands off the mouse.

How to Freeze a Row in Excel

Scroll far enough down a long spreadsheet and the column titles disappear, leaving you to guess what each number means. Freezing a row pins it in place so the labels stay on screen.

Keep headers visible as you scroll

A frozen row stays put at the top of the window while the rest of the sheet moves beneath it. Your headers remain visible no matter how far you scroll, so you can see what a number means as well as where it sits. Nothing gets lost.

In large data, that context matters most. Pinned headers keep you oriented across hundreds of lines and make distant rows easier to compare, since the row you’re reading and its labels stay on screen together.

Consider a freelance bookkeeper who runs a home office and tracks invoices for six clients in one workbook. With the header row frozen, she can scroll from January to December and still see which column holds the amount paid.

Freezing works for columns too, so a label column can stay put as you move across a wide sheet.

Ways frozen rows save you time

The payoff shows up in four places:

• Faster, accurate data entry. Headers in view mean you type each value into the right column without checking every few rows.
• Better data analysis. Seeing a figure beside its label makes patterns easier to spot and misreadings less likely.
• More professional presentation. A sheet with a pinned header is easier for teammates to follow and looks polished.
• Improved productivity. Less scrolling and re-checking adds up across a workday.

Freezing Rows Step by Step

Freezing a row in Excel doesn’t lock one row so much as lock everything above a line. Here’s how to place that line, from a simple header to trickier layouts.

Lock the top row in place

Start with Freeze Panes on the View tab, the fastest way to keep column headings visible. Go to View > Freeze Panes, choose Freeze Top Row, then scroll down to confirm the first row stays put.

If you’d rather start from a cell, select A2 and then choose Freeze Panes. Excel locks everything above A2, which is the same top row.

Think of a home office bookkeeper tracking a few hundred invoices. With the header row frozen, the column names stay in view as the list scrolls, so there’s no trip back to the top to check which column holds the due date. Your headers stay put.

The quickest keyboard route runs through the View tab. On Windows, press Alt to show the ribbon’s key tips and reach Freeze Panes without the mouse. Ctrl+F12 isn’t a freeze shortcut, so it won’t lock anything for you.

The menu path is the same on both systems, and only the modifier key changes:

Task	Windows	Mac
Open Freeze Panes	View tab > Freeze Panes	View tab > Freeze Panes
Modifier in shortcuts	Ctrl	Cmd

Keeping several rows fixed at once

Pulling more than one row into the locked area uses the same command from a different starting point. Select the row just below the rows you want to keep, in column A, then go to View > Freeze Panes.

Everything above that line stays put while the rest of the sheet scrolls, so a three-row title block stays locked as one.

Freezing a row other than the first

Want a totals row or a section header to stay visible? Scroll that row to the top of the window, or select the cell directly below it, then use the Freeze Panes option. Anything above that line is frozen too, so the rows above can’t scroll out of view.

Fix both rows and columns together

To lock headings and a label column together, select the cell just below and to the right of the area you want fixed, not the header itself. The table shows what each choice locks:

Selected cell	What stays fixed
B2	Row 1 and column A
C3	Rows 1 and 2, plus columns A and B
C4	Rows 1 to 3, plus columns A and B

Whatever cell you pick, the freeze runs back to A1, so the fixed block always starts in the top-left corner.

How to freeze only the first 3 columns?

Use View > Freeze First Column to lock column A alone. Scroll left so column A is first on screen before you choose it. Freeze First Column can’t be combined with Freeze Top Row, so for both, use a cell selection instead.

To freeze the first two or three columns, select C1 for two columns or D1 for three, then choose Freeze Panes.

Turning off Frozen Panes

Frozen panes are a lifesaver until they start getting in your way. When you want the whole sheet to scroll again, here’s the fix, and it’s just one command.

Remove all freezes in one go

Start on the View tab and select Freeze Panes, the same menu you used to lock the labels in place. Then choose Unfreeze Panes. In one step, every frozen row and column releases at once.

Consider a home office bookkeeper who froze the top row and first column of a household budget so the labels stayed visible while she scrolled through a year of transactions.

When her year-end review is done and she needs to check a payment from March, one menu pick on Unfreeze Panes clears every freeze instead of making her hunt down each one.

Unfreezing is less about fixing your sheet and more about resetting how it scrolls. Need the labels pinned again later? Reapply the freeze from the same View menu whenever you’re ready. Scrolling is yours again.

When Frozen Panes Won’t Cooperate

Most freeze problems have a handful of causes, and each has a quick fix. Here’s what we’d check first.

When Freeze Panes is grayed out

If the command is dimmed, press Enter or Esc to leave cell editing mode first, since Excel won’t freeze while you’re typing in a cell.

Then check whether the worksheet is protected (Review tab, Unprotect Sheet) and whether row 1 is hidden, unhiding it if so. Finally, remove any split panes from the View tab and any earlier freeze, since either one can block a new freeze.

Fixing the wrong row being frozen

A freelance bookkeeper checking 400 expense lines on a laptop found her freeze had locked the wrong rows at the top. Three fixes get it right:

• Unfreeze, then reposition. Clear the old freeze before you set a new one, using Unfreeze Panes on the Freeze Panes menu.
• Scroll to the correct position. Bring your target row to the top of the window, since Excel freezes the rows above your selected cell.
• Use the Freeze Panes option. Select the cell directly below the last row to keep, then choose Freeze Panes.

Once the freeze covers row 1, her headers stay in view through all 400 lines.

Scrollbar gone or data out of view

• Too many rows frozen. A big frozen block leaves little room to scroll, so unfreeze and freeze only what you need.
• Filters applied before freezing. A filter or sort set up before the freeze can leave the data out of step with the headers.
• Reapply sorts/filters after. Once the freeze is set, bring them back so the data lines up underneath.

Freeze first. Filter second.

Freezing Versus Splitting Your Panes

Both tools keep part of your sheet on screen while the rest scrolls, but they solve different problems. Pick the wrong one and you’ll spend the afternoon scrolling anyway.

How the two approaches differ

Freeze Panes locks chosen rows or columns in place while the rest of the sheet moves beneath them. The frozen area is static: it doesn’t resize or split into a second view. Consider a home-office bookkeeper tracking 400 invoices in one sheet.

Freezing the header row keeps “Client” and “Amount” visible however far down she scrolls to log a payment.

Split divides the window into two or four panes, each with its own scroll bar and a divider you can drag to resize. Every pane can show a different part of the same sheet. Split areas stay flexible, while frozen ones stay put.

Split is the better pick for cross-referencing. Put the monthly summary in the top pane and the detail rows near the bottom in the other, and you can read across without flipping back and forth.

Choose Freeze when you need a fixed reference that never leaves the screen. Choose Split when you need two distant sections visible at once and want to adjust as you go. Freeze for labels, split for comparisons.

Freezing changes what you see, not what you can change. Locking is a separate feature for protecting content. To lock specific cells, start by flipping the default: every cell is locked, but that only matters once sheet protection is on.

Select the cells people should be able to edit, press Ctrl+1 (Cmd+1 on a Mac), and uncheck Locked on the Protection tab. Then open the Review tab and choose Protect Sheet.

Tips for Bigger, More Complex Sheets

Once a sheet runs past a screenful, frozen rows start doing real work. Here’s how to keep them useful without crowding your data.

Managing frozen rows in busy sheets

Freeze only what’s needed. Lock the header row or the two rows you check most, and leave the rest free to scroll. Each frozen row takes space at the top of your screen, so screen space shrinks fast.

Consider a home office bookkeeper tracking invoices on a laptop. She freezes just the header row with Date, Client and Amount, so after scrolling 400 rows she never hunts for a label. Freeze fewer rows, not more.

Frozen rows stay during sorting, so headers never scroll away when you reorder the list. Combine with filters the same way: narrow a long list, and the labels stay put.

To freeze rows in Google Sheets, open View, choose Freeze, and pick a row option like 1 row. To freeze columns, use the same submenu and pick a column option like 1 column to keep your first column visible when you scroll sideways.

Pairing frozen rows with macros and filters

Macros with frozen rows: if a macro sorts or filters your data, freeze the header row first, so you can check its results against labels you can still see.

Filters, sorts, conditional formatting: each keeps your data readable with headers pinned, so highlights and filtered results line up with the labels above them.

When you print, freezing doesn’t carry over to paper. In Excel, go to Page Layout, choose Print Titles, and set your header row under Rows to repeat at top.

Frozen panes are one of those small settings that quietly save a lot of scrolling. Once your headers stay put, every number has its context, and you stop guessing which column you’re looking at. It takes seconds once you’ve done it a couple of times.

If the sheet ever stops behaving, the unfreeze and troubleshooting steps are there to get you back on track. Your headers stay put, and your hands stay on the keys.