RibbonKeys Teams Download

Freeze panes shortcut in Excel for Mac

The freeze panes shortcut in Excel for Mac with RibbonKeys is Option, then W F F, the same sequence as Alt+W+F+F on Windows. W opens the View tab and F F is Freeze Panes.

The same button is renamed Unfreeze Panes while panes are frozen, and it keeps F F. Freeze Top Row is W F R. Freeze First Column is W F C.

Which freeze do you want?

Freezing keeps part of a sheet on the screen while the rest scrolls. Which of the three commands you need depends on what has to stay in sight.

The keys, one letter at a time

  1. Tap ⌥ by itself while Excel is in front. A letter appears over every tab.
  2. Type W. That is the View tab, and its controls get letters.
  3. Type F. That is Freeze Panes, in the Window group of the tab. It opens a dropdown, and each item of the dropdown gets a letter of its own.
  4. Type F again for Freeze Panes (or Unfreeze Panes), R for Freeze Top Row or C for Freeze First Column.

Windows keeps the three freezes in one dropdown, which is why F F, F R and F C share their first letter. Depending on the version of Excel for Mac, the three commands sit in that dropdown or on the tab as separate buttons. RibbonKeys has the same letters either way. If you type a wrong letter on the way, Esc steps back one level, so Esc after W F brings the View tab's letters back.

On Windows, and on a Mac without RibbonKeys

The Windows keys are the three above with Alt in place of Option: Alt+W+F+F, Alt+W+F+R and Alt+W+F+C. People who learned them there find that Excel for Mac does not answer them by itself.

Without RibbonKeys, Excel for Mac's own way is the mouse: the View tab, then Freeze Panes, or the Window menu in the menu bar. Excel for Mac has shortcuts with the Command key, but they differ from the Windows ones and reach only part of the ribbon. Since 2024 it also has KeyTips of its own, switched off by default in Excel's settings, under Accessibility; as Microsoft introduced them, some sequences differ from Windows. The page about Excel's KeyTips has the differences.

When W F F does nothing

What to press next

The commands next to Freeze Panes in the Window group are on the same tab, so one more tap of Option and W reaches them: ⌥ W S is Split, ⌥ W N is New Window and ⌥ W A is Arrange All. On the same tab, ⌥ W V G turns the gridlines on and off and ⌥ W Q opens Zoom. After freezing a header row, Alt HOI, which is ⌥ H O I, fits the columns to what they hold. The full list has every letter of the View tab.

Questions

How do I freeze the top row in Excel for Mac?

With RibbonKeys, tap Option and type W F R. W opens the View tab, F is Freeze Panes and R is Freeze Top Row, the same keys as Alt+W+F+R on Windows. It does not depend on the selected cell.

How do I freeze the first column and the top row together in Excel for Mac?

Select the cell just below and to the right of what must stay in view, for example B2 for row 1 and column A, then tap Option and type W F F. Everything above and to the left of the selected cell is frozen.

How do I unfreeze panes in Excel for Mac?

Tap Option and type W F F again. While panes are frozen the same button is called Unfreeze Panes, and it keeps the letters F F.

Download RibbonKeys

Free for 7 days, with no account and no card. After that €3.99 a month or €59.99 once, including VAT.
The same licence covers Word and PowerPoint.
Needs macOS 13 or later and Excel for Mac.

Windows Excel shortcuts on a Mac · Every shortcut · RibbonKeys