To freeze a row in Excel, click the row header below the rows you want locked — say row 2 if row 1 holds your headers — then go to View > Freeze Panes > Freeze Panes. One click pins everything above and left of that selection. The command lives on the View tab in the Window group on every Excel desktop and mobile build, and the shortcut is Alt+W, then F, then F on Windows. The one catch: Freeze Panes locks columns to the left of your cell too, so pick a cell in column A.
What Freeze Panes Actually Locks Based on Where You Click
The selection point is the whole mechanism. Excel freezes every row above the active cell and every column to its left, so a cell in B2 pins row 1 and column A in one move. That behavior comes from the Windows desktop documentation for Excel 2016 and later, which describes Freeze Panes as locking rows and columns based on the selected cell rather than on any separate setting. If you only want a row, put the active cell in column A.
To lock a single header row, select cell A2 and choose Freeze Panes. Rows 1 freezes; nothing else moves. To lock the top three rows, select A4 — rows 1 through 3 stay visible while row 4 scrolls beneath them. The row headers give you a visual cue: a slightly thicker line appears under the last frozen row, separating the locked strip from the scrolling region.
The lock applies to the worksheet, not the workbook. Each sheet tracks its own frozen point, so freezing row 1 on "January" leaves "February" unfrozen until you set it there. That matters more than most guides admit: a monthly workbook with twelve tabs means twelve separate freeze operations, and Excel doesn't copy the setting when you duplicate a sheet unless you right-click the tab and use Move or Copy with "Create a copy" checked.
Gridlines reveal whether the freeze took. A frozen row keeps its horizontal gridline intact while the rest of the sheet scrolls past; if you see the split line vanish, you froze the wrong cell. Press Alt+W, F, F in sequence on Windows or use View > Freeze Panes on Mac's ribbon, and check the row header boundary before you start entering data.
Step by Step: Locking the Top Row in Under Ten Seconds
Follow this order on any Windows or Mac desktop build. It takes one selection and two ribbon clicks, and the failure handling after the steps covers the two things that go wrong.
1: Click the header for row 2 on the left edge of the grid — the gray numbered strip. The entire row highlights. If your header sits across rows 1 and 2, click row 3 instead. 2: Open the View tab on the ribbon. On Windows, Window group; on Mac, the same tab carries the Freeze Panes button. 3: Click Freeze Panes. A small dropdown opens with three commands: Freeze Panes, Freeze Top Row, Freeze First Column. 4: Choose Freeze Panes. The thin divider line appears below row 1, and the View tab now shows Unfreeze Panes in the same spot. 5: Scroll down. Row 1 stays put while rows 2 and beyond move under it. Press Ctrl+Home (Cmd+Home on Mac) and the active cell snaps to A2, not A1, because A1 is inside the frozen strip.
If nothing appears to freeze, your workbook is probably in Page Layout view — Freeze Panes greys out there. Switch to Normal view via View > Normal. If the command is disabled entirely, check whether the sheet is protected: Review > Unprotect Sheet, and you'll need the password the author set. And if rows freeze but the divider line sits under the wrong row, you selected the wrong cell; click Unfreeze Panes and repeat from step 1.
Why Freeze Top Row and Freeze First Column Behave Differently
Using Freeze Top Row skips the selection step but forces row 1 as the boundary. Microsoft's own command descriptions treat it as a shortcut: it always locks row 1, no matter which cell you had active, and it replaces any existing row freeze rather than adding to it. That's convenient for a clean header in row 1 and useless if your headers sit in rows 1–2, because it will freeze only the first.
Freeze First Column mirrors the logic for column A. Run both commands and Excel freezes A1's row and column together — the intersection behavior most people want for a wide table with a label column. Run Freeze Top Row after custom Freeze Panes and the earlier custom freeze is discarded; the commands don't stack, they replace.
Table objects flip the whole question. Press Ctrl+T to convert a range into an official Excel Table and the header row pins automatically as you scroll — no View tab required. That's the version-specific difference worth knowing: Excel 2007 introduced Tables, and from 2010 onward the header behavior has been consistent. If your data qualifies as a table, you may never need Freeze Panes at all.
The trade-off: Tables bring filter buttons and structured references, which change formulas and can break a carefully built layout. For a plain report sheet, Freeze Panes keeps the original formatting. For anything you'll filter and sort repeatedly, the Table header does the job and survives row insertions.
The Column Trick Nobody Mentions When You Only Want Rows
Freeze Panes always locks columns too, and that surprises people who select B2. The fix is simple: keep the active cell in column A. Select A2 for one header row, A5 for four header rows, and the column side locks nothing because there is no column to the left of A. Excel treats the selection edge as the boundary, so the leftmost position is the safe one.
If you genuinely need both a frozen row and a frozen column — a name column plus a header row — select the cell just below and just right of both. Headers in row 1 and labels in column A mean selecting B2. The divider lines then run horizontally under row 1 and vertically beside column A, and the top-left corner cell A1 stays pinned in place while everything else scrolls.
Ambidextrous users should note the Excel for Mac ribbon calls the group Window just like Windows, but the menu path in Excel 2011 and earlier was Window > Freeze Panes — an older layout some offices still run. In Excel for the web, the View tab carries Freeze Panes with the same three commands, and the setting saves with the file, so a freeze applied in the browser shows up when the file opens on desktop.
One edge case: merged cells inside the frozen strip. If row 1 contains a merged header spanning A1:F1 and you freeze at A2, scrolling works fine. But if the merged cell crosses the freeze boundary — say a merged A1:B2 with the freeze at B2 — Excel refuses the freeze or produces a confusing partial lock. Unmerge, freeze, remerge if the layout allows, or move the merge entirely above the boundary.
How to Freeze Multiple Rows and Columns Together
Want rows 1–3 and columns A–B locked at once? Select C4. The rule is mechanical: the first unfrozen cell is the selection, so the row above it and the column left of it are the last frozen ones. Row 3 is above C4, column B is left of C4, and everything beyond scrolls. Three seconds, done.
This scales to any table shape. A financial model with five header rows and two label columns freezes at C6. A grading sheet with a name column and two header rows freezes at B3. There's no dialog box, no row-count field, no column picker — the click is the configuration, which is why the same command feels different on every sheet.
Unfreezing is the same path in reverse: View > Freeze Panes > Unfreeze Panes. The command only appears after a freeze exists; a fresh sheet shows the three freeze options instead. On Windows the keyboard route Alt+W, F, F toggles freeze on, and there is no default shortcut for unfreezing beyond navigating the same menu.
One practical check before you commit: freeze after your headers are final. Inserting a row above a frozen row pushes the boundary down automatically and the freeze follows, but inserting rows inside the frozen strip while other users edit the same file can trigger a repair prompt in shared workbooks. Excel's co-authoring in Microsoft 365 handles freeze changes reasonably well, but older shared-workbook mode (.xls compatibility) is where sync conflicts cluster.
Freeze Panes vs Split: Choosing the Right Tool for the Job
Freeze Panes and Split look similar in the View tab and do different jobs. Here's how they line up on the dimensions that matter when you're mid-task.
| Feature | Freeze Panes | Split |
|---|---|---|
| What it locks | Rows above and columns left of selection, permanently pinned | A movable divider creating two or four independently scrolling panes |
| Number of frozen areas | One per worksheet | Up to four panes, each scrolling separately |
| Divider line | Thin, not draggable | Thick gray bar, draggable with the mouse |
| Best for | Keeping headers visible while scrolling a long list | Comparing two distant regions of the same sheet side by side |
| Keyboard path (Windows) | Alt+W, F, F | Alt+W, S |
| Behavior on scroll | Frozen strip stays, everything else moves | Each pane scrolls on its own; you can park row 200 next to row 2 |
| Where it lives in the file | Saved with the workbook per sheet | Saved with the workbook per sheet |
Split wins when you're reconciling two blocks of data far apart on one sheet — pin the top pane at row 1 and scroll the bottom pane to row 400, and both stay visible. Freeze Panes wins for the everyday case: one header row, hundreds of data rows, scroll down and read.
The hidden cost of Split is that it's easy to trigger by accident. Double-clicking the thin rectangle above the vertical scrollbar splits the window, and many users do it while aiming for the scrollbar itself. The divider is also draggable, which means a stray mouse drag silently changes your view. Freeze Panes has no drag handle, so once set it stays put.
If you need frozen headers on a printed page rather than on screen, neither command helps. That's Page Layout > Print Titles > Rows to repeat at top, which is a different feature with a different purpose — on-screen freezing does not carry into print output, a distinction Microsoft's support pages make explicitly and one that trips up anyone building a print-ready report.
Excel for the Web and Mobile: Where the Freeze Commands Live
Excel for the web hides the command in plain sight. View tab, Freeze Panes button, same three options. The behavior matches desktop down to the selection rule, and the setting saves into the .xlsx file, so a freeze set in the browser appears on desktop and vice versa. What the browser lacks is Split — no split-view command exists there.
The free Excel mobile apps on iOS and Android handle freezing through a longer path. On iPhone, tap the cell, open the ribbon's View section, and Freeze Panes appears as a toggle; Android follows a similar View menu route. Both platforms freeze based on the selected cell with the same above-and-left rule. Small screens make the divider line nearly invisible, so verify by scrolling rather than by looking for the line.
Frozen panes and Windows itself are separate things. Pressing Win+Ctrl+D creates a new virtual desktop, and Win+Ctrl+Left or Right switches among them — useful when you keep one workbook for reference and another for entry, but unrelated to freezing rows inside a sheet. Excel keeps each window's freeze state tied to the workbook view, so the same file opened in two windows can show different scroll positions but the same frozen boundary.
Regional builds matter in one narrow way: Excel's ribbon labels are localized, so "Freeze Panes" appears as "Geld vast" in Dutch, "Figer les volets" in French, and "Paneles inmoviles" in Spanish-language builds. The Alt+W, F, F sequence maps to the localized menu order, which is why Microsoft recommends the key sequence over hunting ribbon labels in a translated interface.
Common Freeze Failures and How to Recover
The most common freeze failure isn't a bug — it's freezing the wrong thing. A user selects B2 expecting row 1 to freeze and watches column A vanish into a fixed strip instead. Unfreeze Panes, click A2, freeze again. Total recovery time: about four seconds, and no data is affected.
The second failure is a workbook stuck in Page Layout or Page Break Preview. Both views disable Freeze Panes because they're print-layout modes, and the command greys out with no explanation. View > Normal restores it. A related case: protected worksheets disable the command until you unprotect, and shared workbooks sometimes show stale freeze lines after a co-author edits the header rows — closing and reopening the file clears the display.
The third failure is purely visual. The freeze is active but the divider line is so faint on high-resolution screens or with certain zoom levels that users assume it failed and freeze again, which replaces the first freeze with an identical one — harmless but confusing. At 100% zoom the line shows clearly; below 70% it can disappear into the gridlines.
One genuine repair case exists: inserting rows or columns can shift a frozen boundary in older Excel versions and corrupt the saved view state, producing an error when the file reopens. Excel 2016 and later handle boundary shifts automatically, and Microsoft 365 has no known issue with the operation. If a file from Excel 2013 or earlier misbehaves, unfreeze, save, and re-freeze after the structural edit — the sequence avoids the corrupted state.
FAQ
Does freezing a row affect printing or exporting to PDF?
No — the frozen row appears only once at its original position when printed or exported, not repeated on every page. To repeat a header row on each printed page, use Page Layout > Print Titles and enter the row range in "Rows to repeat at top," which is a separate setting from the on-screen freeze, per Microsoft's support documentation.
Why is the Freeze Panes button greyed out?
Three causes cover nearly every case: the sheet is in Page Layout or Page Break Preview view, the worksheet is protected, or the workbook is open in a restricted mode such as Protected View. Switch to Normal view first, then check Review > Unprotect Sheet — a forgotten password blocks the command entirely.
Does a frozen row count as data when I sort or filter?
The freeze is a view-only setting and never alters cell values, sort order, or filter results. Excel sorts the full range regardless of what's frozen, though sorting a range that excludes the frozen header row can push the headers out of the frozen strip — select the entire data range including headers, or convert the range to a Table with Ctrl+T.
Can I freeze a row in Google Sheets the same way?
Google Sheets has its own command, View > Freeze > 1 row, which differs from Excel's cell-selection approach: Sheets asks how many rows or columns to lock rather than where you click. The file formats are not interchangeable for this setting — a freeze applied in Sheets does not transfer to Excel when you download as .xlsx, so reapply after conversion.
Do frozen rows slow down a large workbook?
No measurable impact — the freeze is a display property, not a calculation. A workbook with 500,000 rows and a frozen header scrolls at the same speed as the same file unfrozen, because Excel renders the frozen strip from cached screen data rather than recalculating it. The bigger performance drag in large files comes from volatile formulas and excessive conditional formatting.
What's the fastest way to freeze row 1 in every sheet of a workbook?
There's no built-in multi-sheet freeze, so the fastest route is a short macro: loop through Worksheets, activate each, and set ActiveWindow.FreezePanes = True after selecting A2. Microsoft's VBA documentation for the Window object confirms the property. Without macros, the manual path is one View > Freeze Panes click per tab.
Can two people freeze different rows in a shared workbook?
Each user's freeze is stored per view, and co-authoring in Microsoft 365 keeps your scroll and freeze state separate from your collaborator's. In legacy shared-workbook mode (.xls compatibility format), freeze changes sync as part of the file state and can conflict — that's one more reason Microsoft has pushed teams toward co-authoring in OneDrive or SharePoint.