In Excel: look each command up in Microsoft's Excel for Mac shortcut list instead of swapping Ctrl for ⌘ everywhere: many everyday commands use ⌘, but several keep ⌃ (Control) — ⌃; enters the date and ⌃` shows formulas — and function keys need fn unless you have turned on "Use F1, F2, etc. keys as standard function keys" in System Settings ▸ Keyboard.
On this page7
Look the command up in Microsoft's Excel for Mac shortcut list; do not assume ⌘ wherever a Windows guide says Ctrl.
When ⌘ does something else in macOS (⌘Space is Spotlight), Excel kept ⌃: ⌃Space selects the column, ⌃⇧= inserts cells.
Hold fn with F2, F4 and F9 unless you have set the function keys to behave as standard keys in System Settings ▸ Keyboard.
Use ⌘T (or F4) to switch a reference between A1, $A$1, A$1 and $A1.
For anything with no shortcut, add your own: System Settings ▸ Keyboard ▸ Keyboard Shortcuts ▸ App Shortcuts, using the exact menu-item wording.
What this does
Excel for Mac shares most commands with Windows, but the keys differ in three ways, and none of them is a rule you can apply blindly. First, ⌘ (Command) replaces Ctrl for many everyday commands: ⌘C, ⌘V, ⌘Z, ⌘S, ⌘F. Second, Microsoft's Mac list keeps Control — written ⌃ — for a number of others: ⌃; enters the date (⌘; enters the time), ⌃` shows formulas, ⌃Space selects the column, and ⌃⇧= inserts cells; ⇧Space selects the row. Third, the function keys are shared with macOS media controls, so F2 (edit cell) and F4 (toggle absolute references) usually need fn held down. Alt is ⌥ (Option), and the Alt-key ribbon sequences that Windows users rely on — Alt+H, H for fill colour — do not exist on Mac at all; the equivalent is the menu bar or a custom shortcut. The same idea underpins a lot of everyday Excel work, so the few minutes spent getting it right here pay back across every sheet you build afterwards. Treat it as a pattern, not a one-off, and it stops being something you look up and starts being something you reach for. The difference between a quick fix and a sheet you can trust is the extra minute you spend validating “macbook excel shortcuts”. Start on a copy or a tiny sample, keep the affected cells visible, and compare the result with the outcome you expected before you touch the real workbook. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. The point is a workflow that saves repeating the same clicks every week, but the practical win is that someone else can open the file and understand what happened without asking you.
A worked example
Filling a formula down a column: Windows Ctrl+D is ⌃D or ⌘D on Mac. Editing the active cell: Microsoft lists ⌃U on Mac. Toggling $ anchors inside a formula: ⌘T or F4. Inserting the current date: Windows Ctrl+; stays ⌃; on Mac — ⌘; enters the current time instead, so a blind Ctrl→⌘ swap inserts the wrong value. Most Excel material is written for Windows, and a mechanical Ctrl→⌘ swap is wrong often enough to insert the time instead of the date — so check the command in the Mac list rather than translating the modifier. If this is something you do often, add the command to the Quick Access Toolbar (right-click it on the ribbon and choose Add to Quick Access Toolbar) or learn its shortcut, so next time it is one click instead of a hunt through the menus.
In Google Sheets
This is a command rather than a formula, so there is no syntax to carry over. Google Sheets arranges its commands in menus across the top instead of a ribbon, names some of them differently and does not have every Excel command — look for the equivalent in the Sheets menus or its help before assuming the steps match. Keep this page bookmarked for the next time the same question comes up. Better still, repeat the steps once in your own workbook — doing it yourself is what turns a copied answer into something you remember. Here is the takeaway for “macbook excel shortcuts”: follow the steps at the top, check the result on the sheet itself, and keep undo in mind while you experiment. Done once deliberately, it becomes something you do from memory in Excel rather than something you search for again.
Common mistakes
- Following a Windows tutorial verbatim and concluding a shortcut is missing when it is simply on ⌃ rather than ⌘.
- Pressing
F2orF4without fn and triggering brightness or Mission Control instead. - Looking for Alt-key ribbon sequences (Alt+H+O+I) on Mac — those are Windows-only and have no Mac counterpart.
- Assuming ⌘
F4closes a workbook the way Ctrl+F4 does; on Mac ⌘W closes the window and ⌘Q quits Excel. - Overwriting a macOS system shortcut with a custom app shortcut and losing the system function without noticing.
Frequently asked questions
What is the Mac equivalent of Ctrl in Excel?
There is no single rule. Many commands use ⌘ (Command), but Microsoft's Mac list keeps Control (⌃) for others — ⌃; for the date, ⌃` for showing formulas, ⌃Space to select the column and ⌃⇧= to insert cells. Check the command, not just the modifier.
Why do the F keys not work in Excel for Mac?
macOS maps F1–F12 to brightness, volume and Mission Control by default. Hold fn, or turn on "Use F1, F2, etc. keys as standard function keys" in System Settings ▸ Keyboard.
What replaces F4 for absolute references on a Mac?
⌘T (Microsoft also lists F4) cycles a reference between A1, $A$1, A$1 and $A1 while you are editing the formula.
Can I add my own Excel shortcut on a Mac?
Yes — System Settings ▸ Keyboard ▸ Keyboard Shortcuts ▸ App Shortcuts, choose Microsoft Excel and type the menu-item name exactly as it appears in the menu.
Do Alt-key ribbon sequences work on a Mac?
No. The Alt+letter navigation of the Windows ribbon has no Mac equivalent; use the menu bar or a custom App Shortcut instead.