Is There a Freeze Panes Keyboard Shortcut on Mac?

Quick Answer: Excel — on Windows and Mac — has no built-in keyboard shortcut for Freeze Panes. You freeze rows/columns through View → Freeze Panes, either from the Ribbon or the menu bar. If you want a real keyboard shortcut for it, you have to assign one yourself via macOS keyboard shortcuts, or use a utility like Mac Excel Shortcuts app, which ships with Freeze Panes pre-mapped to a single keystroke. Mac Excel Shortcuts app ships Freeze Panes, and other keyboard-less commands like Remove Duplicates, pre-mapped to a single keystroke.

For the full walkthrough with every freeze option explained, see the complete Freeze Panes guide linked below. This page is the fast version.

The problem

You select a cell, reach for Ctrl+Alt+F or whatever muscle-memory shortcut you had on Windows (which, to be clear, also isn't a native Windows shortcut), and nothing happens. Freeze Panes is one of the few genuinely common Excel actions that has never had a default keyboard shortcut on any platform.

What the feature does

Freeze Panes locks specific rows and/or columns in place so they stay visible while you scroll through the rest of the sheet.

Method 1: Menu bar

  1. Click the cell just below and to the right of what you want frozen.

  2. Go to View in the menu bar.

  3. Choose Freeze Panes, then pick: Freeze Panes, Freeze Top Row, or Freeze First Column.

Method 2: Ribbon

Click the View tab, click Freeze Panes in the Window group, choose the same three options. Functionally identical to Method 1.

Method 3: Native keyboard shortcut

There isn't one. This is the whole reason this article exists. Microsoft has never assigned a default key combo to any of the three Freeze Panes options in Excel, on Windows or Mac.

Method 4: Assign your own macOS shortcut

  1. System Settings → Keyboard → Keyboard Shortcuts → App Shortcuts

  2. Click +, choose Microsoft Excel as the application.

  3. Type the exact menu text: Freeze Panes

  4. Assign a key combo, e.g. Cmd+Option+F (pick something not already in use).

This works, but it's brittle — the menu text has to match exactly, it only fires from the top-level toggle, and it won't sync across machines.

Method 5: The MacCove's Mac Excel Shortcuts app workflow

Mac Excel Shortcuts app ships Freeze Panes as a pre-built, pre-tested shortcut so you skip the System Settings fiddling entirely — select your cell, hit the key combo, done.

Choosing what to freeze

Microsoft's rule is that Freeze Panes freezes the rows above and the columns to the left of the selected cell. A few worked examples:

  • Freeze the top three rows: select cell A4 (or click the row 4 header), then choose View, Freeze Panes, Freeze Panes.

  • Freeze the header row and the first column: select cell B2, then choose Freeze Panes.

  • Freeze the first two columns: select the third column, then choose Freeze Panes.

If you only need the top row or the first column, the Freeze Top Row and Freeze First Column options skip the selection step.

How to unfreeze panes

Open View, Freeze Panes again. While panes are frozen, the first option changes to Unfreeze Panes. Choose it and the sheet scrolls normally again.

Freeze Panes vs Split

These are two different features. Freeze Panes locks rows and columns so they stay visible while you scroll. Split divides the window into separate panes of the same worksheet that you can scroll independently. If your sheet looks cut into four scrolling sections, you have split it rather than frozen it, and the Split button on the View tab turns it off.

The Windows Ribbon sequence

On Windows, the Ribbon sequence Alt, W, F, F reaches Freeze Panes: press the keys one after another, not together. It is a path through the Ribbon rather than a built-in single shortcut, and Excel for Mac has no Ribbon Access Keys of its own. The Mac Excel Shortcuts app runs that same sequence in Excel for Mac, which is why people moving from Windows often find it the fastest route. For the full walkthrough of every freeze option, see How to Freeze Rows and Columns in Excel on Mac.

Frozen rows and printing

Freezing only changes what you see on screen. To repeat a heading row on every printed page, use Print Titles on the Page Layout tab instead.

Common mistakes

  • Selecting the wrong cell before freezing — the freeze happens above/left of your selected cell.

  • Trying to freeze non-adjacent rows/columns — not supported.

  • Forgetting that Freeze Panes and Split View are different features.

FAQs

Is there really no shortcut on Windows either?

Correct — this one surprises people. It's menu-only by default on both platforms.

Can I freeze both a row and a column at once?

Yes — select the cell one row below and one column right of where you want the freeze, then use plain Freeze Panes.

How do I unfreeze panes?

Choose View, Freeze Panes, Unfreeze Panes.

Does freezing panes change how the sheet prints?

No. It only affects the screen. Use Print Titles on the Page Layout tab to repeat rows when printing.

What is the difference between freezing and splitting?

Freezing keeps rows and columns visible while you scroll. Splitting creates separate panes of the same sheet that scroll independently.

← Back to all articles

Mac Excel Shortcuts: Excel shortcuts not working on Mac? Alt E S V, Paste Values, the Windows way. Try it free for 7 days.