Function Keys in Excel for Mac: The Fn Setting and the F-Key Shortcuts That Matter
Quick answer: On a MacBook, the top-row keys control brightness and volume by default, so Excel only sees F1 to F12 if you hold Fn. To make them standard function keys, tick Use F1, F2, etc. keys as standard function keys in System Settings ▸ Keyboard. After that, the printed features need Fn instead.
How we checked: the function-key meanings below come from Microsoft's Excel keyboard shortcut list, opened on November 3, 2026. We did not hands-test each key on a real Mac for this update.
Why do function keys need Fn on a Mac?
On a MacBook the top row controls brightness, volume and media first, so Excel only receives F1 to F12 when you hold Fn or switch the system setting.
Microsoft says that if a function key does not work as you expect, you should press Fn in addition to the function key. That explains most reports of F-key shortcuts not working.
How do you make F1 to F12 standard function keys?
Open System Settings, Keyboard, Keyboard Shortcuts, choose Function Keys and turn on Use F1, F2, etc. keys as standard function keys. The setting then applies to every app on the Mac.
Open System Settings ▸ Keyboard ▸ Keyboard Shortcuts.
Choose Function Keys.
Turn on Use F1, F2, etc. keys as standard function keys.
With this on, F2 edits a cell in Excel. With it off, you press Fn+F2.
Which function-key shortcuts does Microsoft document for Excel for Mac?
Microsoft's Excel list gives Mac meanings for F1, F2, F4 to F9, F11, F12, Shift and Option variants, and Command variants, which the table below sets beside the Windows meaning.
| Key | Windows (Microsoft list) | Mac (Microsoft list) |
|---|---|---|
| F1 | Opens the Help task pane | Opens the Help window |
| F2 | Edits the active cell | Edits the selected cell |
| Shift+F2 | Adds or edits a cell note | Inserts a note, or opens and edits one |
| F3 | Opens the Paste Name dialog (only if names are defined) | Not listed |
| Shift+F3 | Opens the Insert Function dialog | Opens the Formula Builder |
| F4 | Repeats the last action; cycles reference types in formulas | Toggles reference style (listed as Cmd+T or F4) |
| F5 | Opens the Go To dialog | Opens the Go To dialog |
| Shift+F5 | Not listed | Opens the Find dialog |
| F6 | Moves focus between worksheet, ribbon, task pane and Zoom controls | Moves focus between worksheet, ribbon, task pane and status bar |
| F7 | Opens the Spelling dialog | Checks spelling |
| F8 / Shift+F8 | Extend mode / add a non-adjacent range | Extend-selection mode / add another range |
| F9 / Shift+F9 | Calculates all open workbooks / the active worksheet | Calculates all open workbooks / the active sheet |
| F10 | Turns Key Tips on or off | Not listed (Shift+F10 opens the context menu) |
| F11 / Shift+F11 | Chart on a new chart sheet / inserts a worksheet | Inserts a new chart sheet / inserts a new sheet |
| F12 | Opens the Save As dialog | Opens the Save As dialog |
| Option+F8 | Alt+F8 opens the Macro dialog | Opens the Macro dialog |
| Option+F11 | Alt+F11 opens the VBA editor | Opens Visual Basic |
| Option+F12 | Alt+F12 opens the Power Query Editor | Opens the Power Query Editor |
| Cmd+F3 | Not listed | Opens the Define Name dialog |
| Cmd+F12 | Not listed (Ctrl+O opens a workbook) | Opens the Open dialog |
| Shift+F14 | Scroll Lock is a key | Toggles Scroll Lock |
Which function keys behave differently from Windows?
Five differences stand out: F3 and F10 have no Mac listing, Shift+F3 opens the Formula Builder, Shift+F5 opens Find, and F4 is documented only as the reference toggle.
Does F4 repeat the last action on a Mac?
Microsoft's list says F4 toggles reference style on Mac and does not list Repeat Last Action there; it lists Cmd+Y and Ctrl+Y as Redo. Treat F4 as a repeat key only after testing it.
On Windows, F4 does two jobs: it repeats the last action and cycles reference types in a formula. On Mac, Microsoft documents only the second. For that job see F4 in Excel for Mac: Absolute References (Cmd+T) and Why Doesn't F4 Work in Excel on Mac?.
Should you use the system setting or the Fn key?
Turn on standard function keys if you live in Excel and use Fn for brightness or volume. Leave the default if you mostly use the printed features, and add Fn for Excel shortcuts.
Even with the default setting you can still use the printed features by pressing Fn, so the choice comes down to what you press more often. If you switch between a laptop and an external keyboard, check the behaviour on each.
What if a function key still does the wrong thing?
Some function keys are claimed by macOS. Microsoft says some default macOS shortcuts conflict, with Show Desktop on F11 as its example, so look under System Settings, Keyboard, Keyboard Shortcuts and clear the clash.
See Why Excel Keyboard Shortcuts Don't Work on Mac for the full diagnostic list, including a table of macOS collisions.
How do Home, End and Page Up work with Fn?
On a MacBook, Microsoft lists Fn with the arrow keys: Fn-Left for Home, Fn-Up and Fn-Down for Page Up and Page Down, and Control-Fn-Right for the last cell.
The other keys Windows users miss are covered in Windows Keyboard on Mac: Where Every Key Went.
FAQs
Do I need to press Fn for F2 in Excel on Mac?
Only if standard function keys are turned off. With the setting on, F2 edits the selected cell directly; with it off, press Fn+F2. The choice applies to the whole Mac.
Why does F4 not toggle references on my Mac?
F4 needs Fn unless standard function keys are on, and it only cycles references while you edit a formula. Microsoft also lists Cmd+T for the same toggle, which avoids the Fn issue.
Does F4 repeat the last action on Mac?
Microsoft's Mac list documents F4 only as the reference toggle and lists Cmd+Y as Redo, so repeat-last-action is not documented. Check the Edit menu to see whether Repeat is offered.
Is there a Scroll Lock key on a Mac?
No dedicated key. Microsoft lists Shift+F14 to toggle Scroll Lock in Excel for Mac and notes you may need a USB keyboard to reach F14 on a MacBook.
Does the function key setting only affect Excel?
No. Microsoft notes that changing the system function-key preference changes how function keys work for your whole Mac, not just Excel for Mac, so check other apps after switching the setting.
How do I open the Macro dialog or Visual Basic?
Press Option+F8 for the Macro dialog and Option+F11 to open Visual Basic, per Microsoft's Mac list. Add Fn if your function keys are not set as standard.
Which key calculates the whole workbook?
F9 calculates all open workbooks and Shift+F9 calculates only the active sheet, per Microsoft's Mac list. Add Fn if your function keys are not standard.
Related guides
Why Excel Keyboard Shortcuts Don't Work on Mac (and How to Fix Them)
Mac Excel Keyboard Shortcuts: 30 Essential Shortcuts With Windows Equivalents
F2 in Excel for Mac: How to Edit a Cell (and Fix the Fn Key)
Absolute Reference Shortcut in Excel for Mac: The $ Key (⌘T and F4)