Freeze Panes in Excel: Shortcut Key and How It Works

In Excel for Microsoft 365 on Windows, the Freeze Panes shortcut is Alt, W, F, F—press the keys one after another, not all at once. To freeze panes based on a particular row and column, select the cell just below and to the right of the area you want to keep visible, then use that sequence.

The Windows shortcut and its menu equivalents

The key sequence opens the View tab’s Freeze Panes command and applies it to the active worksheet. The letters act as ribbon KeyTips: tap Alt, then W, then F, then F. If you press a wrong key or the sequence does not work, press Esc and try again. The ribbon may look slightly different if it has been customized, but the menu route remains available.

Excel also has shortcuts for the two common one-step choices:

Alt, W, F, R applies Freeze Top Row.
Alt, W, F, C applies Freeze First Column.

These are sequential key presses, not a simultaneous keyboard chord. They are useful when you want a familiar heading or identifier to stay on screen while scrolling, but they do not replace the general Freeze Panes command when you need to lock both rows and columns or several rows.

What Freeze Panes actually keeps visible

Freeze Panes divides the worksheet view into scrollable and fixed areas. Rows above the selected cell stay visible when you scroll vertically; columns to its left stay visible when you scroll horizontally. The selected cell itself belongs to the scrollable area. For example, selecting B3 and freezing panes keeps rows 1 and 2, plus column A, visible. The rest of the worksheet can scroll independently of those headings.

This is a viewing aid, not a change to the data. It does not lock cells against editing, protect a worksheet, repeat headings on printed pages, or move rows and columns. Other people opening the workbook may see the saved view, but the freeze setting is not a security control. Use worksheet protection for editing restrictions and print settings for repeated page headings.

How to choose the right cell

Think of the cell you select as the top-left corner of the area that should scroll. Everything above it and everything to its left will remain fixed. This makes the position of the active cell important: choosing a cell in the wrong row or column can freeze more or less than intended.

Identify the rows that contain headings or other information you need to keep in view.
Identify any left-side columns that should stay visible, such as ID numbers or names.
Select the first cell below those rows and to the right of those columns.
Choose View > Freeze Panes > Freeze Panes, or use Alt, W, F, F.

For instance, if rows 1 and 2 contain a title and column headers, and column A contains employee IDs, select B3. If you want only the first row fixed, use Freeze Top Row rather than choosing a cell manually. If you need the first two rows and no fixed columns, select A3 before applying Freeze Panes.

Examples for common worksheet layouts

In a sales report, row 1 might contain headings such as Date, Region, Product, and Revenue. Freeze Top Row keeps those labels visible as you scroll through hundreds of transactions. It is usually the quickest choice when a table has one header row.

In a wide inventory sheet, column A might contain product codes and columns B onward might contain stock counts, suppliers, and dates. Freeze First Column keeps those codes visible as you move across the sheet. If row 1 also contains column headings, select B2 and use Freeze Panes to keep both the top row and the first column fixed.

For a report with two heading rows and two identifying columns, select C3. Excel then keeps rows 1 and 2 and columns A and B in place. This is useful when the first column contains a category and the second contains a subcategory, but it can consume a large part of a small screen. Freeze only the information readers need to identify the data they are currently viewing.

Using the ribbon on Windows, Mac, and the web

On Windows desktop Excel, the menu route is View > Freeze Panes. Open its dropdown to choose Freeze Panes, Freeze Top Row, or Freeze First Column. The keyboard sequence is a fast alternative when the workbook is active and you know which option you need.

On Excel for Mac, use View > Freeze Panes and choose the appropriate option. The Windows Alt KeyTip sequence is not the Mac equivalent; use the ribbon command because available keyboard navigation can depend on the Mac version and settings. In Excel for the web, use the View tab’s Freeze Panes menu. The web interface and browser can affect keyboard access, so the visible menu is the clearest route if the Windows sequence is unavailable.

Unfreezing panes and changing the layout

To remove a freeze, go to View > Freeze Panes > Unfreeze Panes. On Windows, the corresponding KeyTip sequence is Alt, W, F, F when panes are frozen; the dropdown’s command changes to Unfreeze Panes. Since the last key can depend on the currently displayed menu, check the KeyTips or use the menu if you are unsure.

To change which rows or columns stay fixed, unfreeze the current arrangement first, select the new boundary cell, and apply Freeze Panes again. Excel does not let you independently add several separate frozen regions in one worksheet. A single freeze arrangement can keep a contiguous set of top rows and left columns visible.

Common problems and how to fix them

The wrong rows or columns stay put: Unfreeze, select the cell at the intended boundary, and apply the command again. Remember that the rows above and columns to the left of the selection are what freeze.
Only one row or column is frozen: Freeze Top Row and Freeze First Column are preset commands. To freeze a custom combination, select the boundary cell and choose the general Freeze Panes option.
The shortcut seems to type letters or does nothing: Press the keys in sequence, starting with Alt, and make sure Excel has focus. If the ribbon is customized or KeyTips differ, use View > Freeze Panes instead.
You cannot see a clear boundary: Look for a thin line separating the fixed area from the scrolling area. Scroll the sheet to confirm what remains in place; the line can be subtle against some worksheet themes.
The screen is too crowded: Unfreeze and choose fewer rows or columns. Frozen areas take up screen space, especially on a laptop or when Excel is zoomed in.

Also check whether you are in a view that makes the worksheet difficult to navigate. Freeze Panes is a worksheet-view feature, and it is separate from splitting the window, hiding rows, or changing zoom. If the sheet is protected or shared in a way that limits changes, permissions or workbook settings may affect your ability to change the view.

Freeze Panes versus Split

Freeze Panes and Split both divide what you see on screen, but they solve different problems. Freeze Panes keeps selected top rows and left columns stationary while the remaining area scrolls. Split creates separate panes that can be scrolled independently, which can help compare distant parts of one worksheet. For example, a split may let you view an upper summary and lower detail at the same time; it does not simply make the top headings stay fixed in the same way.

For an ordinary table where you want column headings to remain visible, use Freeze Panes. Choose View > Split when you specifically need independently scrolling sections. If the screen has unexpected divider lines or behaves as though it has multiple scrolling areas, check whether Split is active and turn it off before setting up frozen headings.

Practical tips for readable frozen layouts

Keep the frozen area narrow. Freeze identifying fields and headings, not every column that might occasionally be useful.
Use a meaningful header row and consistent labels so readers can interpret the data while scrolling.
Test both vertical and horizontal scrolling after freezing; a layout that works in one direction may still hide useful context in the other.
Consider the screen size of the people who will use the workbook. Several frozen rows can leave little room for the data on a compact display.
Use Freeze Panes for on-screen navigation and configure print titles separately if headings must repeat on printed pages.

Frequently Asked Questions

What is the shortcut key for Freeze Panes in Excel?
In Excel for Microsoft 365 on Windows, press Alt, W, F, F in sequence. It applies Freeze Panes according to the active cell, so select the correct boundary cell first.

How do I freeze the top two rows in Excel?
Select cell A3, then choose View > Freeze Panes > Freeze Panes. The rows above the selected cell—rows 1 and 2—stay visible while you scroll.

Can I freeze the top row and first column at the same time?
Yes. Select B2 and apply Freeze Panes. The row above and the column to the left stay fixed. If a different freeze setup is already active, unfreeze it before creating this layout.

How do I unfreeze panes in Excel?
Choose View > Freeze Panes > Unfreeze Panes. This removes the current frozen arrangement without changing the worksheet’s cell contents.

Does Freeze Panes work on Excel for Mac?
Yes. Use View > Freeze Panes and select the option you need. The Windows Alt-based sequence is not the Mac equivalent, so the ribbon menu is the reliable way to find the command.

Why does Excel freeze the wrong row or column?
Excel freezes all rows above and columns to the left of the active cell. Unfreeze the current view, select the cell immediately below and to the right of the intended fixed area, and apply Freeze Panes again.

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.