How to Freeze a Row in Excel: Step-by-Step Guide for Any Row

Ever scrolled halfway down a spreadsheet and lost sight of the header row, then spent ten seconds hunting for it? That’s exactly why Excel’s Freeze Panes feature exists. This guide walks you through exactly how to freeze a row in Excel — whether it’s the top row, the first few rows, or even a specific row that isn’t at the very top. You’ll also learn the subtle difference between freezing on screen and repeating rows on paper.

Menu location: View tab › Freeze Panes ·
Freeze Top Row: Locks only first row ·
Freeze Panes: Locks rows above, columns left of selected cell

This key facts table summarizes the most important reference information.

How to freeze specific rows in Excel?

Freezing the first row only

The fastest way to keep the top header visible is the Freeze Top Row option. Go to the View tab, click Freeze Panes, and select Freeze Top Row. A thin line appears under row 1, and that row stays put when you scroll (Microsoft YouTube tutorial).

Freezing the first column only

If your first column contains labels you want to keep visible, use Freeze First Column from the same menu. That locks column A while the rest of the sheet scrolls horizontally (Microsoft YouTube tutorial).

Freezing multiple rows starting from top

To freeze more than one row (say rows 1–3), click any cell in row 4 (the first row you want to scroll). Then go to View > Freeze Panes > Freeze Panes. All rows above the selected cell become frozen. The same principle applies to columns: select a cell in column D to freeze columns A–C (Maryland Dept. of the Environment guidance).

How to freeze a row in Excel that isn’t the top row?

Using Freeze Panes with offset selection

You cannot freeze a row in the middle of the sheet directly — only rows above the selected cell are locked. To freeze row 5, for example, select cell A6 and choose Freeze Panes. Rows 1–5 become frozen; rows 6 downward scroll normally (Capterra). This feels counterintuitive to many users because the freeze point is below the target row.

Frozen rows below header rows

If your sheet has a multi-row header (rows 1–3) and you want to freeze rows 1–3, select any cell in row 4 before using Freeze Panes. That locks the header block (Microsoft YouTube tutorial).

Limitations of freezing non-top rows

Freeze Panes always freezes from the top of the sheet down to the row above your selection. According to a Microsoft Tech Community discussion, users often expect to freeze any arbitrary row, but the feature only locks contiguous rows from the top.

The implication: the “freeze any row” request is a feature mismatch, not a bug, and understanding this prevents wasted effort.

How to freeze multiple rows in Excel?

Freezing more than one row from top

Select the cell directly below the last row you want frozen. For rows 1–4, select cell A5, then View > Freeze Panes > Freeze Panes. The line appears between row 4 and 5 (Coding Temple).

Freezing rows and columns simultaneously

Select the cell that is below the rows and to the right of the columns you want frozen. For example, to freeze rows 1–3 and columns A–B, select cell C4. Then apply Freeze Panes. Everything above and left of C4 locks (Microsoft YouTube tutorial).

• Rows frozen: 1–3
• Columns frozen: A–B
• Scrollable: everything else

Freeze Panes vs Freeze Top Row

Freeze Top Row is a quick shortcut that always locks row 1. Freeze Panes is more flexible — it can lock any number of rows and columns based on where you place the cursor (Microsoft YouTube tutorial).

The pattern: Freeze Top Row is a convenience, Freeze Panes is the power tool.

How to freeze a row in Excel on Mac?

Using View menu on Mac

On Excel for Mac, open the View tab on the ribbon. You’ll see the same Freeze Panes dropdown with Freeze Top Row, Freeze First Column, and Freeze Panes. The logic is identical to Windows (Coding Temple).

Keyboard shortcuts for Mac

There is no built-in keyboard shortcut for freezing panes on Mac. Some users create a custom shortcut via System Preferences > Keyboard > App Shortcuts, but the default requires using the menu (Microsoft Tech Community).

Differences between Windows and Mac

Functionality is the same, but the Mac ribbon layout may have the Freeze Panes button under a different grouping. If you’re on macOS, ensure the worksheet is scrolled to the top-left before freezing (Maryland Dept. of the Environment guidance).

The catch: Mac users lose the keyboard shortcut convenience enjoyed on Windows, though the underlying functionality is identical.

How to freeze a row in Excel so it prints on every page?

Setting print titles

Freeze Panes only affects the onscreen view — it does not carry over to printed pages. To repeat a row on every printed page, go to Page Layout > Print Titles. In the Rows to repeat at top field, enter the row range (e.g., $1:$1 for row 1) (Capterra).

Rows to repeat at top

Click the collapse dialog button, select the row(s) on the sheet, then OK. The header will appear at the top of each printed page, even if you haven’t frozen it on screen (Coding Temple).

Difference from freeze panes

Freeze Panes is a display convenience; Print Titles is a layout setting for PDFs and paper. They work independently. You can use both together — freeze on screen and repeat in print.

The implication: screen freeze and print repeat are two distinct tools; forgetting this leads to broken printouts.

“Select the cell below the rows and to the right of the columns you want to keep visible when you scroll.”

— Microsoft Support documentation (official Microsoft tutorial)

“Freezing rows in the middle of a worksheet can feel counterintuitive because you must select the row below the data row you want frozen.”

— Microsoft Tech Community discussion (Microsoft Tech Community)

There’s a real consequence to treating Freeze Panes as a print feature: your PDFs will miss the header, and your audience will have to flip back to the first page to remember what column C means. For anyone preparing a spreadsheet for review — a monthly report, a budget overview, or a data inventory — the difference between screen freeze and print repeat is critical. The fix is two clicks in Page Layout, but only if you know it exists.

Related reading: How to Freeze a Row in Excel (Coding Temple) · How to Freeze a Row in Excel (Capterra)

Once you have frozen the desired rows, you may also want to protect your data by locking cells in Excel to prevent accidental edits.

Frequently asked questions