Excel Freeze Panes Shortcut: Windows Keys and Tips

In Excel for Microsoft 365 on Windows, press Alt, then W, F, and F to open Freeze Panes. The sequence freezes rows above and columns to the left of the selected cell; for example, select C5 first to keep rows 1–4 and columns A–B visible.

The Windows Freeze Panes Shortcut

Press the keys in sequence, rather than holding them all down together: press Alt to show ribbon KeyTips, then W for the View tab, F for the Freeze Panes menu, and F again to choose Freeze Panes. The shortcut works from a worksheet in the desktop Windows version of Excel. KeyTips can differ in localized versions of Office, so if a letter does not match your ribbon, use the visible KeyTips or choose the command with the mouse.

The last key is important: it chooses the general Freeze Panes command, whose effect depends on the active cell. Selecting a cell is therefore part of using the shortcut correctly. If you leave the active cell at A1, there are no rows above or columns to its left to freeze, so the result may not be what you intended.

For the built-in presets, the Windows sequences are:

Alt, W, F, R — Freeze Top Row.
Alt, W, F, C — Freeze First Column.
Alt, W, F, F — Freeze Panes, or Unfreeze Panes when panes are already frozen.

These are ribbon KeyTip sequences, not universal system shortcuts. They are useful because they do not require clicking through the ribbon, but the View menu remains a reliable alternative if the sequence is unfamiliar.

What Freeze Panes Does

Freeze Panes keeps specified rows or columns in view while you scroll through the rest of a worksheet. It is especially useful when a table is taller or wider than the screen. A frozen header row can keep field names visible as you review lower records; a frozen identifier column can keep names or product codes visible as you move across many date or measure columns.

The frozen area is determined by the active cell at the time you apply the command. Excel freezes the rows above it and the columns to its left. It does not freeze the active cell itself as a separate region. A thin line on the sheet marks the boundary between frozen and scrolling areas, though the line can be subtle depending on the display and worksheet formatting.

Freezing changes how the sheet is displayed; it does not protect cells from editing, lock a formula, or prevent rows from being changed. Use worksheet protection when you need to restrict editing. Freeze Panes is simply a viewing aid, and it affects the current worksheet rather than automatically setting the same view for every sheet in the workbook.

Choose the Cell Before Freezing

To freeze both rows and columns, click the cell immediately below the rows you want to keep visible and immediately to the right of the columns you want to keep visible. Then use Alt, W, F, F. For example, select C5 to freeze rows 1 through 4 and columns A and B. When you scroll down, the first four rows remain visible; when you scroll right, the first two columns remain visible.

For a more modest example, suppose row 1 contains column labels and column A contains employee names. Select B2 before applying Freeze Panes. Excel keeps row 1 and column A visible while the data area scrolls. If you select B1 instead, the command freezes no rows above the selection; it can still freeze column A. The position of the active cell—not the highlighted range’s size—is what matters.

A practical way to plan the selection is to ask two questions: which top rows must remain visible, and which left-hand columns must remain visible? If the answers are three rows and one column, select B4. This freezes rows 1–3 and column A. Excel cannot use this command to keep a bottom row visible or to freeze scattered, nonadjacent rows and columns; the frozen sections must be the contiguous area at the top and left of the sheet.

Freeze the Top Row or First Column

If you only need a common preset, you do not need to calculate a cell position. Choose View > Freeze Panes > Freeze Top Row to keep row 1 visible, or View > Freeze Panes > Freeze First Column to keep column A visible. On Windows, the corresponding KeyTip sequences are Alt, W, F, R and Alt, W, F, C.

These presets freeze only the first row or first column. They do not automatically freeze several header rows or several identifying columns. For example, to keep rows 1 and 2 visible along with column A, select B3 and choose Freeze Panes. The general command is the flexible choice whenever the area you want to retain is larger than one preset row or column.

One common misconception is that Freeze Top Row always means the first row of the visible portion of the worksheet. It means worksheet row 1. If your table starts at row 6, use a custom selection below the table’s header instead, and consider whether the rows above it should also remain visible.

Unfreeze or Change the Frozen Area

Excel allows one frozen-pane arrangement at a time on a worksheet. If the current boundary is in the wrong place, first remove it, then select the correct cell and apply Freeze Panes again. Use View > Freeze Panes > Unfreeze Panes, or use the Windows KeyTip sequence Alt, W, F, F when the menu offers Unfreeze Panes.

Unfreezing does not delete worksheet data, change the order of rows, or alter formulas. It only returns the sheet to ordinary scrolling. After unfreezing, check the active cell before setting a new boundary; choosing a cell in the wrong row or column is a frequent reason a second attempt appears to freeze the wrong area.

If you are unsure which arrangement is active, open the Freeze Panes menu on the View tab. The menu shows the available freeze choices and, when panes are frozen, provides Unfreeze Panes. Using the menu is also helpful when a saved workbook opens with a view set by someone else and you want to reset it before choosing your own boundary.

Excel for Mac and Excel for the Web

On Mac, the Windows Alt, W, F, F KeyTip sequence is not the standard equivalent. Use the Excel menu or ribbon: open View > Freeze Panes and choose the appropriate freeze, preset, or unfreeze command. Mac keyboard layouts and ribbon navigation differ from Windows, so do not assume that substituting the Mac Option or Command key will reproduce the Windows sequence.

In Excel for the web, use the View tab and its Freeze Panes options. Browser keyboard handling and the web interface can affect ribbon shortcuts, so the menu is the dependable route if a desktop KeyTip sequence does not respond. The basic behavior is the same: select the right cell for a custom arrangement, or choose a preset for the top row or first column.

If a workbook moves between desktop and web versions, look at the sheet itself to confirm the boundary is where you expect it. The names and placement of interface controls can vary across platforms and updates, while the underlying rule—rows above and columns left of the selected cell—makes it easier to recreate the view.

Common Problems and Useful Distinctions

The wrong rows or columns stay put: Unfreeze, select the cell just below and to the right of the intended frozen area, and apply Freeze Panes again.
The shortcut seems not to work: Enter the keys one at a time. Pressing them simultaneously is not the ribbon KeyTip method. If KeyTips do not match, use the View tab.
Only one row is frozen: Freeze Top Row is a preset for row 1. To retain multiple rows, use the general Freeze Panes command with a cell below them.
The worksheet is split into moving sections: Freeze Panes is different from Split. Splitting creates separate panes that can scroll independently; freezing keeps chosen top rows and left columns fixed as the remaining area scrolls.
Cells cannot be edited: Frozen panes do not cause that restriction. Check whether the worksheet is protected or whether another editing restriction applies.

Freeze Panes is also different from hiding rows or columns. Hidden content is not displayed until it is unhidden; frozen content remains visible while you navigate the rest of the sheet. Nor does freezing change what prints. If you need repeated headings on printed pages, use the page layout options for print titles rather than relying on the on-screen freeze boundary.

For long tables, freezing too many rows or columns can leave little room for the data that scrolls. Keep only the labels or identifiers needed to interpret the visible values. If the worksheet contains several title or note rows, consider whether all of them need to stay on screen, or whether a shorter header area would make navigation easier.

Frequently Asked Questions

What is the shortcut to freeze panes in Excel on Windows?
Press Alt, then W, F, and F in sequence. Select the cell first if you want a particular combination of rows and columns to remain visible.

How do I freeze the first two rows in Excel?
Select a cell in row 3, such as A3, then choose View > Freeze Panes > Freeze Panes. Excel freezes the rows above the selection. To freeze columns too, choose a cell that is also to the right of the columns you want to retain.

Can I freeze the top row and first column at the same time?
Yes. Select B2 and use Freeze Panes. That freezes row 1 and column A. For additional rows or columns, select a cell below and to the right of the full area you want to keep visible.

How do I remove Freeze Panes?
Choose View > Freeze Panes > Unfreeze Panes. On Windows, the ribbon KeyTip sequence is Alt, W, F, F when Unfreeze Panes is available in the menu.

Does Freeze Panes lock cells from editing?
No. It only keeps selected rows and columns visible during scrolling. To restrict changes to cells, use worksheet protection settings 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.