Excel Freeze Panes Shortcut: Keys and How It Works

In Excel for Microsoft 365 on Windows, select the cell below and to the right of the rows and columns you want to keep visible, then press Alt, W, F, F in sequence. To freeze just the top row, use Alt, W, F, R; to freeze just the first column, use Alt, W, F, C.

Excel Freeze Panes Shortcut on Windows

These are ribbon KeyTip sequences, not keys to hold down simultaneously. Press and release each key in order. The sequence opens the View tab, opens the Freeze Panes menu, and chooses a command. On some keyboards or localized Excel installations, the displayed KeyTips can differ; if a letter does not work, press Alt and follow the letters shown on your ribbon.

The general command, Alt, W, F, F, applies Freeze Panes based on the currently selected cell. The other two sequences are convenient presets:

Alt, W, F, R freezes the top row, so it stays visible during vertical scrolling.
Alt, W, F, C freezes the first column, so it stays visible during horizontal scrolling.

In versions where a KeyTip differs, use the menu itself: choose View > Freeze Panes, then select Freeze Panes, Freeze Top Row, or Freeze First Column. Excel changes the available menu command when panes are already frozen, so use the ribbon labels as a reliable guide if you are unsure which state the sheet is in.

How Freeze Panes Works

Freeze Panes keeps selected rows at the top of the worksheet and selected columns at the left while you scroll through the rest of the sheet. It does not lock cells against editing, protect data, or change the worksheet’s layout for printing. It changes the on-screen scrolling view of that worksheet.

Excel divides the window at the selected cell. Rows above that cell remain visible, and columns to its left remain visible. The selected cell itself belongs to the scrollable area, not the frozen area. This is why selecting the first cell that should scroll is the useful way to think about the command.

For example, if row 1 contains headings and column A contains customer names, select cell B2 before applying Freeze Panes. Row 1 stays at the top and column A stays on the left. You can then scroll down to another customer or across to later data fields while retaining both labels. If you select B2 but choose Freeze Top Row instead, Excel freezes only row 1; it does not freeze column A.

Frozen areas are separated from scrollable areas by subtle boundary lines. They remain in place when you scroll within that worksheet, but they do not make the content permanently visible in every Excel window or in a printed copy. A worksheet can have frozen rows and columns at the same time, but the freeze boundary is set by one selected cell rather than by selecting separate areas.

How to Choose the Cell to Freeze

For a custom freeze, first count how many header rows and identifying columns should stay visible. Select the cell immediately below those rows and immediately to the right of those columns. Then apply the general Freeze Panes command. This selection rule works whether you need only rows, only columns, or both.

To keep rows 1 through 3 visible, select a cell in row 4, such as A4, if no columns need freezing.
To keep columns A and B visible, select a cell in column C, such as C1, if no rows need freezing.
To keep rows 1 through 3 and columns A and B visible, select C4.

Before freezing, check that the active cell is in the right place. If a block of cells is highlighted, Excel uses the active cell within that selection to determine the boundary. Clicking the intended cell directly is a simple way to avoid freezing the wrong number of rows or columns.

A common example is a long inventory list with two title rows, a column-heading row, and a product code in column A. If all three top rows and the product-code column should remain visible, select B4 and use Freeze Panes. The three rows above row 4 stay put, as does column A. If the product code is actually in columns A and B, select C4 instead.

Freeze the Top Row or First Column

The preset commands are useful when a sheet has a simple layout. Freeze Top Row preserves row 1 even if the current selection is elsewhere. Freeze First Column preserves column A. These presets are not the same as choosing a cell and using Freeze Panes: they are designed for one specific row or column, rather than for a custom boundary.

For instance, a sheet with field names in row 1 and many records below is a good fit for Freeze Top Row. A sheet with row labels in column A and many columns of monthly data may benefit from Freeze First Column. If the useful headings begin on row 3, however, Freeze Top Row will not preserve row 3 as the heading row. Use a custom selection such as A4 to freeze the first three rows instead.

To retain both a heading row and an identifying column, use the general Freeze Panes command after selecting the correct intersection cell. Do not apply the top-row preset and then expect the first-column preset to add another frozen region. Choose the desired combination with one cell selection, or unfreeze and set the boundary again.

How to Unfreeze Panes

To remove frozen rows or columns in Excel for Windows, choose View > Freeze Panes > Unfreeze Panes. You can also use the corresponding KeyTips by pressing Alt and following the letters displayed in your version. The custom Freeze Panes sequence is not a dependable toggle: when panes are frozen, the menu item changes to Unfreeze Panes, so check the command name rather than assuming the same sequence will reverse the action.

Unfreezing does not delete, move, or alter worksheet data. It simply returns the worksheet to ordinary scrolling. To create a different arrangement, unfreeze the current panes, select the new boundary cell, and apply Freeze Panes again. This is often quicker and clearer than trying to adjust an existing freeze boundary.

Freeze settings apply to the individual worksheet, not automatically to every sheet in the workbook. If a workbook has several tabs that need the same frozen header, set the view on each relevant sheet. The setting is part of the workbook view and will generally be there when the workbook is saved and reopened, but it does not make the same choice for other worksheets.

Common Problems and Misconceptions

The wrong rows are frozen: the selected cell was likely too far down or too far to the right. Unfreeze, select the cell at the intended boundary, and apply Freeze Panes again.
A heading is not staying visible: the command may have frozen row 1 when the actual heading is lower down. Use a custom selection below the full heading area instead of the top-row preset.
The shortcut seems not to work: press the KeyTip keys one at a time, not as a simultaneous combination. If your Excel language or ribbon layout uses different KeyTips, use the letters shown after pressing Alt.
The divider line is hard to see: look for the boundary between the fixed and scrolling parts of the worksheet, or check View > Freeze Panes to see whether the command now says Unfreeze Panes.
Only one area seems to move: that can be expected. Frozen columns scroll vertically with the worksheet, and frozen rows scroll horizontally; each stays fixed only along its own axis.

Freeze Panes is also easily confused with worksheet protection. Freezing is a viewing aid and does not stop another person from changing a cell. To restrict edits, use Excel’s protection features separately. It is also different from hiding rows or columns: frozen content remains visible, while hidden content is not displayed until unhidden.

Freeze Panes Compared with Other Options

Use Freeze Panes when labels need to stay visible as you move through a large worksheet. If you only need to inspect a second part of the sheet temporarily, View > Split can divide the window into independently scrollable sections. Split is a different viewing tool: it creates panes for navigating separate parts of the same worksheet, rather than designating a fixed heading area in the usual freeze-panes manner. Remove a split from the View tab when you no longer need it.

If the goal is to repeat headings on paper, freezing is not the right setting. Use Page Layout > Print Titles and specify rows to repeat at the top or columns to repeat at the left. Freeze Panes affects the on-screen view; Print Titles affects printed pages. A worksheet can use both settings when it needs persistent screen headings and repeated print headings.

Excel tables can make data easier to manage and may keep table column headings visible as you scroll within a table, depending on how the sheet is being viewed. That behavior is not a substitute for freezing several custom rows and columns across a worksheet. For a report with multi-row headings, labels outside the table, or a desired fixed first column, the explicit Freeze Panes boundary gives more control.

Excel for Mac and Excel for the Web

The Windows sequence using Alt KeyTips is not the Mac shortcut. In Excel for Mac, use View > Freeze Panes and choose the relevant command. The exact menu presentation can vary with the Excel for Mac release, but the same selection rule applies: for a custom freeze, select the cell below the rows and to the right of the columns that should remain visible. Use the Mac menu to unfreeze or change the setting.

Excel for the web also provides Freeze Panes from the View tab, but browser and operating-system shortcuts can interact with the browser itself, and Windows ribbon KeyTips may not behave exactly as they do in desktop Excel. If a key sequence is intercepted or unavailable, choose View > Freeze Panes in the web ribbon. The frozen boundary is still based on the active cell for the custom command.

Frequently Asked Questions

What is the shortcut to freeze panes in Excel?
In Excel for Microsoft 365 on Windows, select the intended boundary cell and press Alt, W, F, F in sequence. Follow the on-screen KeyTips if your ribbon uses different letters.

What is the shortcut to freeze the top row?
Use Alt, W, F, R on Windows. Alternatively, choose View > Freeze Panes > Freeze Top Row.

How do I freeze the first column and top row together?
Select cell B2, then apply Freeze Panes. The row above and the column to the left—row 1 and column A—will remain visible. For more than one row or column, select the corresponding intersection cell instead.

Can I freeze multiple rows and columns?
Yes. Select the cell immediately below the last row and immediately to the right of the last column to keep fixed, then apply the general Freeze Panes command. For example, C4 freezes rows 1 to 3 and columns A to B.

How do I remove Freeze Panes?
Choose View > Freeze Panes > Unfreeze Panes. This removes the fixed scrolling areas without changing the worksheet’s contents.

Does Freeze Panes affect printing?
No. It changes the worksheet’s on-screen scrolling view. For repeated headings on printed pages, set Print Titles from the Page Layout tab instead.

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.