How to Freeze a Row in Excel: The Complete Guide (2026)

Scroll down 200 rows into a spreadsheet, and suddenly you can’t remember which column is “Quantity” and which one is “Unit Price.” So you scroll back up, check the headers, scroll back down, lose your place, and repeat the whole cycle again. If that sounds painfully familiar, Excel’s Freeze Panes feature is exactly the fix you’ve been missing.

This guide walks through every way to freeze a row (or several rows) in Excel — on Windows, Mac, and the web — along with freezing columns, freezing both at once, keyboard shortcuts, and how to fix it when freezing isn’t working the way you expect.

What Freezing Rows Actually Does

Freezing a row locks it in place at the top of your window so it stays visible no matter how far down you scroll. Excel calls this feature Freeze Panes, and it works by splitting your worksheet into a locked section and a scrollable section — everything above (and, if you choose, to the left of) your selected point stays fixed, while the rest of the sheet scrolls normally underneath it.

This is especially useful for spreadsheets with a header row containing column labels, since it means you never lose track of what each column represents, even deep into a dataset with thousands of rows.

How to Freeze the Top Row Only (Quickest Method)

If you just want to lock the very first row of your spreadsheet, Excel has a one-click shortcut command for exactly that.

On Windows

1. Open your spreadsheet in Excel.
2. Click Freeze Panes.

You’ll immediately see a thin, slightly darker line appear beneath row 1, confirming it’s now frozen.

On Mac

1. Open your document in Excel for Mac.
2. Switch to the View tab in the ribbon.
3. Click the Freeze Top Row icon.

The process and result are identical to Windows — a darker line appears at the bottom edge of row 1, and it now remains fixed as you scroll.

Keyboard Shortcut (Windows)

If you’d rather skip the ribbon entirely, press the following keys in sequence (not held together): Alt, then W, then F, then R. This applies the Freeze Top Row command instantly.

Mac doesn’t have a direct built-in keyboard shortcut for this specific command, so you’ll generally need to use the View tab. If you want a shortcut anyway, you can create a custom one by mapping the View menu command to a key combination through your Mac’s keyboard shortcut settings.

How to Freeze Multiple Rows

The “Freeze Top Row” button only ever locks the single first row. If you need to freeze more than one — say, both a title row and a header row directly beneath it — you’ll need the more flexible Freeze Panes command instead.

1. Click on the cell directly below the last row you want frozen. For example, if you want to freeze the first three rows, click on the first cell in row 4 (cell A4).
2. Go to the View tab.
3. Click Freeze Panes (the main button, not the Freeze Top Row option).
4. Select Freeze Panes again from the dropdown menu.

Excel freezes everything above your selected cell, leaving the rest of the sheet scrollable beneath it. There’s no fixed limit on how many rows you can freeze this way — you could freeze 2, 10, or even 50 rows, as long as you click the correct cell first.

The Golden Rule for Freeze Panes

Whichever cell is currently selected becomes the top-left corner of the scrollable area once you apply Freeze Panes. Everything above that cell (and everything to its left, if applicable) gets locked in place. Keeping this rule in mind makes it much easier to predict exactly what will freeze before you click the button.

How to Freeze Columns Instead of (or Along With) Rows

The same logic applies if you want to lock columns rather than rows — useful when you have row labels or identifiers running down the left side of your sheet that you want visible while scrolling horizontally.

Freezing the First Column Only

1. Go to the View tab.
2. Click Freeze Panes.
3. Select Freeze First Column.

Freezing Multiple Columns

1. Click the cell directly to the right of the last column you want frozen.

How to Freeze Both Rows and Columns at Once

This is where the “Golden Rule” mentioned earlier really comes in handy. To lock both a set of rows at the top and a set of columns on the left simultaneously:

1. Click the cell that sits just below your last frozen row and just to the right of your last frozen column. For example, to freeze rows 1–3 and columns A–B at the same time, click cell C4.

Everything above and to the left of your selected cell locks in place together, while the remaining area of the sheet scrolls freely in both directions.

How to Freeze Rows in Excel Online (Web Version)

The web version of Excel follows essentially the same logic as desktop, using the same View tab controls. Click your reference cell (or just the top row if you’re doing a simple single-row freeze), go to View, and select the appropriate Freeze Panes option from there — the interface differs only slightly in layout from the desktop ribbon, not in function.

How to Unfreeze Rows or Columns

If you want to remove a freeze and go back to normal scrolling:

1. Go to the View tab.
2. Click Freeze Panes.
3. Select Unfreeze Panes from the dropdown (this option only appears once something is currently frozen).

This removes all frozen rows and columns at once — there’s no way to unfreeze just the rows while keeping the columns frozen (or vice versa) without reapplying a fresh freeze afterward.

Common Mistakes That Trip People Up

• Using “Freeze Top Row” when you actually need multiple rows frozen. This is one of the most common mix-ups — Freeze Top Row only ever locks row 1, regardless of which cell you have selected. If you need more than one row frozen, you have to use the full Freeze Panes command with the correct cell selected first.
• Selecting the wrong cell before applying Freeze Panes. Since Excel freezes everything above and to the left of your active cell, clicking the wrong starting point is the most common reason a freeze doesn’t lock what you expected.
• Not being in Normal View. Freeze Panes options may be greyed out or unavailable if you’re currently in Page Layout or Page Break Preview view. Switch back to Normal view (found on the View tab) before attempting to freeze anything.
• Trying to freeze panes in Excel Starter or other limited editions. Some lightweight or trial versions of Excel have reduced feature sets where Freeze Panes may not be fully available.
• Forgetting that blank rows or columns can interfere. Cleaning up unnecessary blank rows and columns before freezing tends to produce more predictable, cleaner results, especially in larger, more complex spreadsheets.

How Freezing Interacts With Other Excel Features

• Filters and sorting: Freezing panes doesn’t interfere with your ability to filter or sort data — your frozen header row stays in place and continues to display filter arrows normally if you’ve applied a filter to that row.
• Excel Tables: If your data is formatted as an official Excel Table, the header row already has some built-in “sticky” behavior when scrolling under certain conditions, but combining that with an explicit Freeze Panes command still works and can offer more consistent control, especially if your table doesn’t span the entire width of your view.
• Printing: Freeze Panes is purely a screen-viewing feature — it has no effect on your printed output. If you want your header row to repeat on every printed page, you’ll need to use the separate Print Titles feature (found under the Page Layout tab), rather than relying on Freeze Panes.

Freezing vs. Splitting the Window: What’s the Difference?

Excel also offers a separate feature called Split, also found on the View tab, which is often confused with Freeze Panes. Splitting divides your worksheet into multiple independently scrollable sections, letting you view two different parts of the same large sheet side by side. Unlike freezing, a split doesn’t lock any specific row or column in place — both sections can scroll freely and independently. If your goal is simply to keep a header visible, Freeze Panes is almost always the better tool; Split is more useful when you need to compare two distant sections of the same sheet simultaneously.

Tips for Working With Frozen Panes

• Freeze only what you actually need. Freezing too many rows or columns can eat into your visible screen space, especially on smaller monitors or laptops.
• Clean your data first. Remove stray blank rows or columns near your intended freeze point, since these can occasionally cause unpredictable results.
• Combine with Print Titles for a consistent experience. If you want your header both visible while scrolling and repeated on every printed page, set up Freeze Panes for the screen and Print Titles separately for printing — they don’t automatically sync with each other.
• Double-check your active cell before freezing. A quick glance at the Name Box (in the top-left corner, showing your currently selected cell) confirms exactly what will freeze before you click the button.
• Remember the freeze doesn’t survive certain view changes. Switching to Page Layout view, for instance, can temporarily make the Freeze Panes options unavailable, though your existing freeze typically remains active once you switch back to Normal view.

Frequently Asked Questions

1. What’s the difference between “Freeze Top Row” and “Freeze Panes”? Freeze Top Row is a quick, one-click shortcut that always locks only the first row, regardless of which cell is selected. Freeze Panes is more flexible and freezes everything above (and optionally to the left of) whichever cell you’ve selected, letting you lock multiple rows and columns at once.

2. Can I freeze more than one row in Excel? Yes. Click the cell directly below the last row you want frozen. There’s no fixed limit to how many rows can be frozen this way.

3. Is there a keyboard shortcut to freeze rows in Excel? On Windows, press Alt, then W, then F, then R in sequence to freeze the top row. Mac doesn’t have a default built-in shortcut for this, though you can create a custom one through your keyboard shortcut settings if you’d like a quicker way to trigger it.

4. Why is the Freeze Panes option greyed out or unavailable? This usually happens if you’re currently in Page Layout or Page Break Preview view rather than Normal view. Switching back to Normal view on the View tab typically resolves it.

5. Does freezing rows affect how my spreadsheet prints? No. Freeze Panes only affects on-screen scrolling behavior. If you want your header row to repeat automatically on every printed page, use the separate Print Titles feature under the Page Layout tab instead.

6. Yes. Click the cell that sits just below your last row to freeze and just to the right of your last column to freeze, then apply Freeze Panes as usual — everything above and to the left of that cell locks together.

7. How do I unfreeze rows or columns once they’re frozen? Go to View > Freeze Panes > Unfreeze Panes. This removes all currently frozen rows and columns at once, and you’d need to reapply a new freeze afterward if you only want to unlock part of what was frozen.

8. Freeze Panes locks a specific row or column in place while the rest of the sheet scrolls beneath or beside it. Split divides your window into separate, independently scrollable sections without locking anything in place, which is more useful for comparing two distant parts of a large sheet side by side.

Conclusion

Freezing a row in Excel is one of those small features that quietly saves an enormous amount of scrolling frustration once you know how to use it properly. For a simple single header row, Freeze Top Row gets the job done in a single click. For anything more complex — multiple header rows, locked columns, or both combined — the full Freeze Panes command, paired with a correctly selected reference cell, gives you complete control. Once it’s set up, you’ll wonder how you ever managed a large spreadsheet without it.