Keyboard Shortcuts in Excel for Mac

What this does

Excel for Mac uses the same shortcut system as Windows with three systematic differences. First, ⌘ (Command) replaces Ctrl for the everyday commands: ⌘C, ⌘V, ⌘Z, ⌘S, ⌘F. Second, a handful of shortcuts kept Ctrl — now written ⌃ — because ⌘ was already taken by macOS: ⌃Space selects the column, ⇧Space the row, and ⌃⇧= inserts cells. 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. The difference between a quick fix and a sheet you can trust is the extra minute you spend validating “keyboard shortcuts in excel for mac”. Start on a copy or a tiny sample, keep the affected cells visible, and compare the result with the tool above 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 becomes ⌘D. Editing the active cell: Windows F2 becomes fn+F2 (or a double-click). Toggling $ anchors inside a formula: Windows F4 becomes ⌘T on Mac, one of the few shortcuts with a genuinely different key rather than a modifier swap. Inserting the current date: Windows Ctrl+; becomes ⌘; — the semicolon stays. Most Excel material is written for Windows, so the useful thing is not another list of chords but the three rules that translate any Windows shortcut into its Mac form. 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. 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. If you take one thing from this page on “keyboard shortcuts in excel for mac”, make it the order of checks rather than the individual clicks: confirm what is selected, apply the step, and look at the result before moving on. That small routine is what keeps Excel work predictable when the same task comes back in a slightly different workbook.

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