Just Want Windows Shortcut Keys to Work on Mac in Excel?
Just Want Windows Shortcut Keys to Work on Mac in Excel?
No interest in learning the Mac way, no interest in the theory — you just want the keys you've always pressed to do what they've always done. Here's the shortest route, ranked by how close it gets you to "identical to Windows."
Quick answer: Fastest path — press ⌘ where you pressed Ctrl (the equivalents already work), turn on standard function keys in System Settings, and install MacCove's Mac Excel Shortcuts app so your Windows Alt Ribbon sequences work too (no setup). That covers nearly everything. Only if pressing ⌘ bothers you, add Karabiner-Elements (free) to remap the physical Ctrl key. For a 100%, bit-for-bit match, run real Windows Excel in Parallels Desktop — heavier and needs licenses.
Figure: Windows keyboard keys glowing on a MacBook running Excel
The 10-minute setup that fixes most of it
Press ⌘ where you used Ctrl: ⌘C/V/X/Z/Y/S/F/H/B/I/U/A/P/1 all already have a working equivalent in Excel for Mac.
System Settings → Keyboard → Keyboard Shortcuts → Function Keys → turn on Use F1, F2, etc. keys as standard function keys. Now F2 / F4 / F12 behave like Windows.
Install Mac Excel Shortcuts app — no configuration — so Alt → H → V → V and your other Ribbon sequences work again.
Restart Excel.
Optional step 5: if you can't get used to pressing ⌘, add a Karabiner rule so the physical Ctrl key sends ⌘ in Excel.
Which route fits you
You use Excel casually: the first route alone is enough. Press ⌘ where you pressed Ctrl and fix the function keys.
You live in Excel all day and use Alt sequences: add the app for the Ribbon sequences, since that is the gap nothing else closes without setup.
You use a Windows keyboard on your Mac: also read the external keyboard guide, so Alt and the Windows key sit where you expect.
Your hands refuse to press ⌘: add a Karabiner rule that sends the physical Ctrl key as ⌘ in Excel only. The remap guide has a working configuration.
You rely on Windows-only add-ins or VBA libraries: run Windows Excel in a virtual machine. See Mac Excel Shortcuts vs Parallels vs Boot Camp.
Five-minute test to check it worked
Open a workbook and try each of these. If all five behave, your setup is complete:
⌘C and ⌘V copy and paste a cell.
F2 edits the active cell, with no fn key needed.
F4 toggles absolute references inside a formula.
⌘S saves, and F12 opens Save As.
A familiar Alt sequence, such as Alt, H, V, V, triggers its action.
What's still not Windows after that
Alt → H → V → V and other Ribbon sequences — Excel for Mac has no Ribbon Access Keys; fix with Mac Excel Shortcuts app (no setup)
A few navigation keys (column select, fill down) — Mac keeps these on Ctrl by design; learn ~5 keys
The physical Ctrl key still isn't ⌘ — you're pressing ⌘ by habit; optional: add a Karabiner rule
Windows-only add-ins / VBA quirks — different app build; use Parallels
How close each option gets you
Press ⌘ + function keys setting — ~70% match, one habit shift; minutes; free
+ Mac Excel Shortcuts app (Ribbon sequences) — ~95% match; +2 min, no config; $49 once / $4.99 mo
+ Karabiner (physical Ctrl key remap) — ~98% match, hands unchanged; +15 min config; free
Parallels (real Windows Excel) — 100% match; 30–60 min + licenses; Parallels + Windows license
Problems after setup
F-keys still change the volume. The setting did not apply. Reopen System Settings > Keyboard > Keyboard Shortcuts > Function Keys and check the toggle, then restart Excel.
A sequence does nothing. Check that the app has the permissions macOS asks for, as described in the permissions guide.
Keys act strangely after a remap. Quit other remapping tools, since two tools can fight over the same key. See Karabiner and Alt sequence keys.
Shortcuts stopped after a macOS update. Work through what to check after a macOS update.
FAQs
What's the absolute fastest way to get Windows Excel shortcuts on Mac?
Press ⌘ instead of Ctrl (nothing to install), flip the standard-function-keys setting, and install Mac Excel Shortcuts app for the Ribbon sequences. Ten minutes, one small paid app, no configuration.
Can I get an exact match to Windows Excel?
Only by running real Windows Excel in a VM like Parallels. Native Mac Excel plus Mac Excel Shortcuts app gets you very close but keeps a handful of Mac-specific keys.
Do I need to pay for anything?
Only Mac Excel Shortcuts app, for the Ribbon sequences that have no free or native equivalent. The chord shortcuts and function keys cost nothing. Karabiner (physical Ctrl remap) is free but optional.
Will this slow down my Mac?
Mac Excel Shortcuts app and Karabiner are both lightweight background utilities with negligible impact. Parallels is the heavy option because it runs a second operating system.