Excel Shortcuts: Windows vs Mac, and Why Cmd to Ctrl Is Not Enough
Excel is the app where Mac and Windows keyboard shortcuts diverge most. AutoSum, AutoFilter, selecting visible cells, absolute references — plus the keys that do something completely different on the other platform.
Excel breaks the rule
In most apps, moving between Mac and Windows is a substitution: Cmd becomes Ctrl, Opt becomes Alt. Excel is the exception. Some key combinations change entirely, and — worse — a few keys exist on both platforms while doing different things.
Here is what actually differs, in three groups. The keys come from Microsoft's official shortcut reference.
1. Different keys, same feature
| Action | Mac | Windows |
|---|---|---|
| AutoSum | Shift + Cmd + T | Alt + Equals |
| Insert the current time | Cmd + Semicolon | Ctrl + Shift + Semicolon |
| Cycle absolute / relative reference | Cmd + T or F4 | F4 |
| Strikethrough | Shift + Cmd + X | Ctrl + 5 |
| Hide rows | Cmd + Open paren | Ctrl + 9 |
| Hide columns | Cmd + Close paren | Ctrl + 0 |
| Select visible cells only | Shift + Cmd + Asterisk | Alt + Semicolon |
| Group cells | Cmd + Shift + K | Alt + Shift + Right |
| Ungroup cells | Cmd + Shift + J | Alt + Shift + Left |
| Add or remove filters | Cmd + Shift + F | Ctrl + Shift + L |
AutoSum shares nothing across platforms. On Mac it is Shift + Cmd + T; Alt + Equals does nothing there.
For the reference toggle, Mac users should learn Cmd + T. F4 also works, but macOS assigns the function row to system controls, so you need Fn — or you turn on "Use F1, F2, etc. keys as standard function keys" in System Settings.
Selecting visible cells only — what you need before copying filtered data — exists on both platforms. Only the keys differ.
Note that Ctrl + Shift + L also adds and removes filters on Mac; Cmd + Shift + F is the Mac-specific alias.
2. Same keys, different feature
This is the group that actually causes damage, because the wrong key still does something.
| Key | On Mac | On Windows |
|---|---|---|
| Ctrl + Shift + F | Add or remove filters | Format Cells (Font) |
| Shift + F3 | Show the formula builder | Insert Function dialog |
| Ctrl + Shift + Open brace | Select dependents | Select precedents |
The precedent / dependent pair lines up like this:
| Action | Mac | Windows |
|---|---|---|
| Select precedents (cells this formula refers to) | Ctrl + Shift + Open bracket | Ctrl + Shift + Open brace |
| Select dependents (formulas that refer to this cell) | Ctrl + Shift + Open brace | Ctrl + Shift + Close brace |
The Mac "dependents" key is the Windows "precedents" key. Anyone who traces formulas will hit this once.
3. Only on one platform
| Shortcut | Where | Action |
|---|---|---|
| Cmd + Shift + R | Mac | Open the sort dialog |
| Cmd + Equals | Mac | Recalculate every open workbook |
| Cmd + Shift + Open / Close paren | Mac | Unhide rows / columns |
| Ctrl + F3 | Windows | Name manager |
| Ctrl + T | Windows | Create a table (on Mac, Cmd + T — though inside a formula it cycles the reference type instead) |
Mac's Cmd + T is context-dependent: create a table when a range is selected, cycle the reference style while editing a formula.
What carries over
These need no translation. Several of them are commonly believed to be Mac-only or Windows-only — they are not.
| Action | Mac | Windows |
|---|---|---|
| Confirm the entry and move up | Shift + Return | Shift + Enter |
| Line break inside a cell | Opt + Return | Alt + Enter |
| Copy the formula from the cell above | Ctrl + Apostrophe | Ctrl + Apostrophe |
| Go to the last cell of the used range | Ctrl + End | Ctrl + End |
| Go to the start of the sheet (A1) | Ctrl + Home | Ctrl + Home |
| Run a macro | Opt + F8 | Alt + F8 |
| Open a dropdown list | Opt + Down | Alt + Down |
| Paste special | Ctrl + Opt + V | Ctrl + Alt + V |
| Recalculate every sheet | Ctrl + Opt + F9 | Ctrl + Alt + F9 |
| Insert cells / rows / columns | Ctrl + Shift + Equals | Ctrl + Shift + Plus |
| Insert today's date | Ctrl + Semicolon | Ctrl + Semicolon |
| Copy / paste | Cmd + C / V | Ctrl + C / V |
| Undo | Cmd + Z | Ctrl + Z |
| Save | Cmd + S | Ctrl + S |
| Find | Cmd + F | Ctrl + F |
| Replace | Cmd + Shift + H | Ctrl + H |
| Select to the edge of the data | Cmd + Shift + arrow | Ctrl + Shift + arrow |
| Next sheet | Ctrl + PageDown or Opt + Right | Ctrl + PageDown |
Opt on a Mac keyboard is the same physical key as Alt on a PC keyboard, so Opt + F8 and Alt + F8 are the same keystroke. The same goes for the line break inside a cell.
The last row has one extra option on Mac — Opt + Right — which is easier on a laptop without PageUp and PageDown keys.
If you use both
- Start with group 2. Pressing the wrong key is harmless when nothing happens; it is not harmless when it opens a dialog you did not want.
- Then the four you use daily from group 1: AutoSum, filters, visible cells, reference toggle.
- Do not try to remap them. Excel offers very little keyboard customization compared with an editor, so this is not a realistic fix.
Unlike most apps, Excel work is almost entirely keyboard-bound — the mouse version of selecting a data range or inserting a sum is genuinely slower. That is why these differences cost more here than anywhere else.