Excel keyboard shortcuts for Mac

Excel arrived on the Mac carrying a shortcut set designed around a keyboard that had a Control key and no Command key. Rather than break decades of muscle memory, Microsoft kept most of those Control chords and layered the Mac-native Command equivalents on top. The result is that many commands genuinely have two bindings, and a few important ones only have the Control form.

This is where mis-transcribed lists go wrong. A page that takes Microsoft's Windows column and swaps Ctrl for Command will tell you that ⌘⇧$ applies the currency format. It does not — the currency format is ⌃⇧$, with Control, on a Mac. The number-format group is almost entirely Control-based for exactly this reason.

The other Mac-specific wrinkle is the function keys. Excel uses F2 through F12 heavily, and on a Mac whose top row is set to control brightness and volume you have to hold Fn to reach them, or change the setting in System Settings under Keyboard.

⌘ with an arrow key is the one to learn first: it jumps to the edge of the current data region, which is how you get to the bottom of a fifty-thousand-row column without scrolling.

⌥Return is the one people hunt for most often: it starts a new line inside a cell instead of committing the entry and dropping down a row.

⌘T appears twice in Microsoft's Mac list and that is not a transcription error: inside a formula it toggles the reference style between absolute and relative, and on a range it creates a table. Excel picks by context.

This is the group that gets mis-transcribed most often. The number formats are Control chords on a Mac, not Command chords, and each one is Control plus Shift plus a symbol you can read off a US keyboard: dollar for currency, percent for percentage, hash for the date.

Excel leans on the function keys harder than almost any other Mac application. If pressing F2 changes your screen brightness instead, hold Fn as well, or switch the top row to standard function keys in System Settings under Keyboard.

Spreadsheet training has a particular failure mode. The instructor selects a range, presses something, and a column of numbers turns into currency. Everyone watching sees the outcome; nobody sees ⌃⇧$. Half the room writes down the wrong thing and the other half asks afterwards.

Show KeyPress is a paid menu bar app from the Mac App Store, for macOS 14 or later, that draws each key you press as a keycap on top of everything else. It has no connection to Excel — no add-in, no ribbon button, no macro. It simply draws an always-on-top window, which is why a screen recorder or a whole-screen share picks it up without any setup.