Excel Row Freeze Shortcut and How to Use Freeze Panes

In Excel for Microsoft 365 on Windows, press Alt, then W, F, and R to freeze the top row. Press the keys in sequence—not all at once—and Excel keeps row 1 visible as you scroll down.

The Windows shortcut and what it does

The sequence Alt, W, F, R is a ribbon KeyTips shortcut for View > Freeze Panes > Freeze Top Row. Start by tapping Alt, release it, then press W, F, and R in order. It is not a single four-key combination. KeyTips appear as small letter labels on the ribbon as you navigate, and those labels can vary with Excel’s language or interface changes. If the sequence does not match your screen, follow the labels shown or use the ribbon path.

Freeze Top Row pins the worksheet’s first row at the top of the grid. It does not pin whichever row is currently selected, and it does not freeze the first column. The setting affects how the sheet appears while scrolling; it does not move, protect, or otherwise change the cell contents.

Freeze the top row from the ribbon

If you prefer not to use KeyTips, or the shortcut labels differ in your installation, the menu command is straightforward:

Open the worksheet you want to change.
Select the View tab.
Choose Freeze Panes in the Window group.
Select Freeze Top Row.

Scroll down to check the result: row 1 should remain visible while the rows beneath it move. The command is useful when a data list has headings such as Date, Customer, Region, and Amount in the first row. Without a frozen heading row, those labels disappear as soon as you scroll far enough to move row 1 offscreen, making it harder to tell which column contains which value.

The command does not depend on the active cell. Whether you have selected A1 or a cell near the bottom of the sheet, Freeze Top Row targets row 1. If you already have a different freeze arrangement, remove it first if you want to start with a clean, top-row-only setup.

How Freeze Panes decides what stays visible

Freeze Panes uses the active cell as a boundary. Rows above the selected cell and columns to its left stay fixed; the cells below and to the right remain scrollable. That is why the general Freeze Panes command is different from the ready-made Freeze Top Row and Freeze First Column commands.

For instance, selecting cell B2 and choosing View > Freeze Panes > Freeze Panes keeps row 1 and column A visible. The active cell is below row 1 and to the right of column A, so both areas on those sides of the boundary are frozen. By contrast, choosing Freeze Top Row explicitly pins row 1 without relying on the selection.

This boundary rule is helpful when a worksheet has labels on both axes. In a wide schedule, you might want the employee names in column A to remain visible while moving horizontally, and the date headings in row 1 to remain visible while moving vertically. Selecting B2 before using Freeze Panes creates that combined view.

Freeze more than one row or combine rows and columns

Freeze Top Row is designed for row 1 only. To keep several heading rows visible, use the general Freeze Panes command and select the first cell below the rows you want pinned. For example, to freeze rows 1 and 2, select A3, then choose View > Freeze Panes > Freeze Panes. The selection is in column A, so no columns are frozen.

To freeze two heading rows and the first column, select B3 before choosing Freeze Panes. Excel fixes the rows above B3—rows 1 and 2—and the column to its left—column A. More generally, use these steps:

Decide how many top rows should remain visible.
Decide how many leftmost columns should remain visible.
Select the cell one row below and one column to the right of the area to freeze.
Choose View > Freeze Panes > Freeze Panes.

For example, if a report needs rows 1 through 3 and columns A and B fixed, select C4. The freeze boundary must be a continuous block from the top-left corner; Excel cannot freeze row 1 and row 3 while leaving row 2 scrollable, or pin separated columns while allowing the columns between them to move.

Excel on Mac and Excel for the web

The shortcut above is for Excel on Windows. On a Mac, use the View tab and choose Freeze Panes > Freeze Top Row; the Windows Alt-based KeyTips sequence is not the Mac equivalent. The Mac ribbon and menu arrangement may look different from Windows, but the freeze options use the same basic idea: Freeze Top Row pins row 1, while Freeze Panes uses the selected cell as its boundary.

Excel for the web also provides freeze controls on the View tab. Use the freeze menu there rather than assuming the Windows desktop keyboard sequence will work in a browser. Browser shortcuts and web-app KeyTips can vary with the browser, operating system, and current interface. If you cannot find the command, look under View for the freeze options.

Regardless of platform, check the visible result after applying a freeze. Scroll vertically to confirm the intended rows stay put, and scroll horizontally if you also froze columns. This simple check catches cases where the selection created a larger or smaller frozen area than intended.

Change or remove a freeze

Excel allows one freeze arrangement at a time for a worksheet view. To replace the current arrangement, first choose View > Freeze Panes > Unfreeze Panes. Then select the correct cell and apply the new freeze command. For example, if you froze rows 1 and 2 but later need only row 1, unfreeze first and choose Freeze Top Row.

If you no longer want any rows or columns pinned, choose View > Freeze Panes > Unfreeze Panes. This removes the visual freeze without deleting cells or changing their values. You can freeze the area again later, using a different boundary if necessary.

Nothing seems to happen: Scroll far enough to move the unfrozen area; a short sheet may not make the effect obvious.
The wrong rows or columns remain: Unfreeze, select the boundary cell again, and apply Freeze Panes.
The option is unavailable or behaves unexpectedly: Check whether the worksheet is being viewed in a mode or window arrangement that limits the command, and return to the normal worksheet view before trying again.

Freeze rows versus print titles

Freezing a row is a screen-view feature. It helps while navigating a worksheet, but it does not automatically repeat that row on printed pages or in a PDF. If the goal is to print a long list with its headings repeated at the top of every page, use Page Layout > Print Titles and set the row to repeat at the top—commonly row 1, shown as $1:$1 in the Rows to repeat at top field.

These settings solve different problems, and using one does not replace the other. You can freeze row 1 for on-screen work and separately set row 1 as a print title. Before printing, use Print Preview to confirm the repeated heading appears on each page; freezing a row alone is not evidence that it will print repeatedly.

Freeze Panes compared with Split

Split also divides a worksheet window into independently scrollable sections, but it is not the same as freezing. A split creates separate panes that can each be scrolled; freezing keeps selected top rows or left columns stationary while the rest of the sheet moves as a single scrolling area. For a simple persistent header, Freeze Top Row is usually the more direct choice.

Use a split when you specifically need to view or compare distant parts of the same worksheet at once. Use Freeze Panes when you want labels or identifying columns to stay in sight as you move through a large table. If a worksheet seems divided by movable bars rather than showing a stationary heading area, check whether Split is active and turn it off before configuring the freeze you need.

Frequently Asked Questions

What is the shortcut to freeze the top row in Excel?
In Excel for Microsoft 365 on Windows, press Alt, then W, F, and R, in sequence. This invokes View > Freeze Panes > Freeze Top Row. If the KeyTips differ in your Excel interface, use the ribbon command instead.

How do I freeze the first two rows?
Select cell A3, then choose View > Freeze Panes > Freeze Panes. The rows above the selection remain visible, so rows 1 and 2 are frozen. If you also want column A fixed, select B3 instead.

Can I freeze a row other than the top row?
You cannot use Freeze Top Row to pin an arbitrary row by itself. You can freeze a block of rows from the top down: select a cell directly below the last row to keep visible, then choose Freeze Panes. Rows above the boundary stay fixed.

Why does Freeze Top Row freeze row 1 instead of my selected row?
That is how the dedicated command is designed: it always targets the worksheet’s first row. To keep multiple top rows visible, select a cell below them and use the general Freeze Panes command. Excel does not freeze a middle row while allowing the rows above it to scroll independently.

Does freezing a row make it repeat when I print?
No. Freeze Panes affects the worksheet view on screen. To repeat a heading on printed pages, set it separately through Page Layout > Print Titles, then verify the result in Print Preview.

How do I unfreeze rows in Excel?
Choose View > Freeze Panes > Unfreeze Panes. You can then leave the sheet unfrozen or apply a different freeze arrangement. Unfreezing changes the view, not the worksheet’s cell contents.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.