How to Use Windows Excel Shortcuts on a Mac

💡
Quick Answer

Most Ctrl shortcuts work on a Mac if you press Cmd instead: Cmd+C, Cmd+Z, Cmd+Arrow. Alt ribbon shortcuts do not, because Excel for Mac has no Alt mode turned on. To use them, install Accelerator Keys and press Option instead of Alt (two-minute setup), run Windows Excel in a virtual machine, or relearn Excel for Mac’s own shortcuts.

Try Accelerator Keys Free for 14 Days

Your three options, ranked

You have three ways to use Windows Excel shortcuts on a Mac. Here they are, best first for the common case: you moved to a Mac and want your muscle memory back.

Option One-line verdict Cost
1. Accelerator Keys Best if the shortcuts are what you miss. Native Excel for Mac, Option acts as Alt, two-minute setup. Does not add Windows-only Excel features. $39.99/yr (Excel) or $59.99/yr (Excel + PowerPoint), 14-day free trial
2. Windows in a VM (Parallels, VMware Fusion, UTM) Best if you also need Power Pivot, the full Power Query editor or Windows-only add-ins. Heavier, costlier, drains battery. Parallels from about $99/yr plus a Windows license
3. Relearn Excel for Mac’s shortcuts Free, and fine if you will never use a PC again. Much of the ribbon has no Mac shortcut, so some tasks go back to the mouse. $0

The rest of this page walks through option 1, then covers the Ctrl-to-Cmd shortcuts that work with no software at all.

Step by step: Windows Alt shortcuts on a Mac with Accelerator Keys

  1. Download Accelerator Keys from acceleratorkeys.com/download. It is a native macOS menu bar app of about 20 MB. It runs on Apple Silicon and Intel and starts a 14-day free trial with no card.
  2. Open the app from your Applications folder and enter your email to activate the trial.
  3. Grant Accessibility permission. Click Grant Access in the setup window. macOS opens System Settings > Privacy & Security > Accessibility. Turn on AcceleratorKeys, then click Quit & Re-Open in the app. This permission lets the app see the Option key and press ribbon buttons for you.
  4. Open Excel (it must be in English) and make the window wide enough that the ribbon buttons are visible.
  5. Press Option, release it, then type the sequence. KeyTip badges appear on the ribbon, just like Alt on Windows. Option, H, O, I autofits the column. Option, E, S, V pastes values. Option, W, F, F freezes panes.

That is the whole setup. From here on your Windows habits work unchanged. If something does not work, the setup guide and troubleshooting page covers permission resets and antivirus conflicts.

Ctrl shortcuts: press Cmd instead

You do not need any software for the Ctrl half of Windows Excel. Excel for Mac maps most of it to Cmd, and Microsoft’s own shortcut list notes that many also work with the Mac Control key — but not all, so Cmd is the safe habit.

Windows Excel for Mac
Ctrl+C / Ctrl+V / Ctrl+X Cmd+C / Cmd+V / Cmd+X
Ctrl+Z / Ctrl+Y Cmd+Z / Cmd+Y
Ctrl+Arrow (jump to edge of data) Cmd+Arrow
Ctrl+Shift+Arrow (select to edge) Cmd+Shift+Arrow
Ctrl+Alt+V (Paste Special dialog) Cmd+Ctrl+V
Ctrl+D / Ctrl+R (fill down / right) Cmd+D / Cmd+R
Alt+= (AutoSum) Cmd+Shift+T

Function keys. F2 edits a cell and F4 toggles absolute references on a Mac too, but a Mac keyboard’s top row controls brightness and volume unless you hold Fn. Turn on “Use F1, F2, etc. keys as standard function keys” in System Settings > Keyboard and they behave like a PC.

Once Accelerator Keys is running, these are the sequences most switchers reach for on day one. Each link is a short guide.

The full list is on the shortcuts page. The complete Alt key on Mac guide explains the whole system.

When a Windows VM is the better answer

Ask yourself what you miss. If it is only the shortcuts, Accelerator Keys is the smaller, cheaper fix. If your work depends on Power Pivot, the full Power Query editor, or a Windows-only VBA or COM add-in, Accelerator Keys cannot give you those. Excel for Mac does not have them, and no shortcut tool changes that. Run Windows in Parallels or another VM, or use a company PC. See Accelerator Keys vs Parallels Desktop for a full cost and setup comparison.

The short version

Press Cmd where Windows uses Ctrl, and you already have half of Windows Excel on your Mac. For the Alt half, install Accelerator Keys, grant it Accessibility permission, and press Option instead of Alt. Setup takes about two minutes. Reach for a Windows VM only if you also need Windows-only Excel features.

Frequently asked questions

What is the Alt key on a Mac keyboard?

The Option key (⌥). It sits in the same place as Alt on a Windows keyboard and many Mac keyboards print “alt” on it. On its own it does not activate the Excel ribbon; macOS uses it to type accented characters. Accelerator Keys makes Option act like Alt whenever Excel or PowerPoint is the front app.

Do I need Windows to use Windows Excel shortcuts on a Mac?

No. Accelerator Keys drives the ribbon in native Excel for Mac, so no Windows license, no virtual machine and no reboot are needed. You only need Windows if you also need Windows-only Excel features such as Power Pivot, the full Power Query editor or certain VBA and COM add-ins.

Do the same letter sequences work on Mac as on Windows?

Yes. Accelerator Keys uses the Windows KeyTip letters, so Option, H, O, I autofits a column and Option, A, S, S opens Sort, exactly as Alt does on a PC. It also supports the legacy Excel 2003 sequences like Alt+E+S+V that Microsoft’s built-in Mac KeyTips leave out.

Why does Accelerator Keys need Accessibility permission?

It has to see when you press Option and then click the ribbon buttons for you. macOS gates both actions behind Accessibility permission in System Settings > Privacy & Security > Accessibility. The app works offline and does not read your workbook data; the permission is only for keystrokes and the ribbon.

How much does Accelerator Keys cost?

Essential is $39.99/year for Excel on one Mac. Pro is $59.99/year for Excel and PowerPoint on two Macs. Both start with a 14-day free trial with no card and carry a 14-day money-back guarantee. It is macOS only and Word support is not yet shipped.

Doesn't Excel for Mac have its own KeyTips setting?

It has a limited KeyTips option, off by default, and it does not do the job. Many commands have no letter at all — AutoFit Column Width (Alt+H+O+I) is one — the legacy Excel 2003 Alt+E, Alt+I, Alt+O and Alt+D sequences are missing, pressing Option and a letter together does nothing, and Esc throws away the whole sequence instead of stepping back. It covers only a fraction of the 900+ Windows shortcuts. Accelerator Keys gives you the full set, with KeyTip badges on the ribbon, and keystrokes register as fast as native Excel for Windows.

Sources


Related