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.
- A header row over a long table. ⌥ W F R freezes row 1 and nothing else. The selected cell does not matter.
- A column of names or numbers beside a wide table. ⌥ W F C freezes column A on its own, in the same way.
- A header row and the first columns together. Select the cell just below and to the right of what must stay put, for example B2 to keep row 1 and column A, or C3 to keep two rows and two columns. Then ⌥ W F F. Everything above and to the left of the selected cell is frozen.
- Getting rid of a freeze. Run ⌥ W F F again. While panes are frozen, that button is called Unfreeze Panes, and it has the same letters.
The keys, one letter at a time
- Tap ⌥ by itself while Excel is in front. A letter appears over every tab.
- Type W. That is the View tab, and its controls get letters.
- 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.
- 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
- The letters do not appear. Check that Excel is the app in front, and that the menu-bar icon of RibbonKeys has no warning sign. Install and troubleshooting goes through the permission and the Option key.
- The window is narrow. A narrow Excel window folds a group of controls into one button. That button has the letters Windows gives the group, and the controls inside it keep the usual ones. Controls that the window has scrolled out of the ribbon get no letter, so widen the window if W F F finds nothing.
- The freeze lands in the wrong place. W F F freezes at the selected cell. If the line sits too high or too far left, run W F F to remove it, select the cell below and to the right of what you want to keep, and run it again.
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.
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