Mac Excel Shortcuts

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. Before you run it on a workbook other people depend on, try it on a copy or a few rows first. Undo only reaches back through the current session, so a quick trial run is the cheapest way to see exactly what will change before the file is saved and shared. Treat “mac excel shortcuts” as a small repeatable workflow rather than a one-off click you hope to remember next time. Use a small test block before the live file, so any surprise in the affected cells shows up while it is still harmless. 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. That turns a workflow that saves repeating the same clicks every week into a method you can reuse, explain, and defend when the workbook leaves your screen.

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. When the result is not what you expected, undo straight away rather than repairing it by hand — undo restores the sheet exactly, while manual fixes tend to leave small inconsistencies behind that surface later.

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. The aim was to get you unstuck fast and leave you a little more capable than a copy-paste would. The answer is at the top and the detail above shows why it holds — so the next time a colleague asks, you can answer without reaching for search. Treat “mac excel shortcuts” as a routine rather than a one-off. Once you know which setting or command controls it, the same few steps handle every workbook where it comes up in Excel, and you can explain them to a colleague in a sentence.

Common mistakes

• Following a Windows tutorial verbatim and concluding a shortcut is missing when it is simply on ⌃ rather than ⌘.
• Pressing F2 or F4 without 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 ⌘F4 closes 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