Excel Shortcuts for Mac: The Ones You'll Actually Use

The Excel shortcuts on Mac that matter most are a short list: jump, select, fill, sum, lock references and edit. Most are simply the Windows shortcut with ⌘ (Command) in place of Ctrl, but a few are different, and Mac laptops add a twist with the fn key. This guide covers the shortcuts you'll actually use every day, grouped by task, so you can learn them in order.

How Mac shortcuts differ from Windows#

Three rules explain most of the differences:

1. ⌘ usually replaces Ctrl. Copy is ⌘C, undo is ⌘Z, fill down is ⌘D.
2. A few shortcuts are completely different. AutoSum, toggling $ signs, editing a cell and inserting the time don't follow rule 1.
3. Mac laptops need fn for function keys. The top row controls brightness and volume, so F4 becomes fn+F4. Home and End become fn+Left Arrow and fn+Right Arrow.

Excel's menus and Microsoft's help pages show Mac keys as symbols, so it helps to know them:

If you use function keys a lot, you can make the top row act as F1 to F12 by default. Look for the function keys setting in the Keyboard section of System Settings. Then you press fn only for brightness and volume.

The guide to Excel on Mac vs Windows covers the wider differences between the two versions.

Shortcuts to move around a sheet#

Jumping is the biggest time-saver. Instead of scrolling through 2,000 rows, one keystroke takes you to the end.

⌘+Down Arrow stops at the last filled cell before a gap, so press it again to jump past an empty cell. In Excel for Windows the same shortcut is Ctrl+Arrow. On a Mac, Control+Arrow is often used by macOS to switch desktops, so stick with ⌘.

Shortcuts to select data#

Add Shift to any jump shortcut and Excel selects everything along the way.

To select a full table from its top-left cell, press ⌘+Shift+Down Arrow, then ⌘+Shift+Right Arrow. Watch out for Control+Space: macOS often uses it to switch the keyboard language, so click the column letter instead if it doesn't work. The guide to selecting ranges fast has more selection tricks.

Shortcuts to enter and fill data#

These shortcuts help you type and copy data quickly.

⌘D is the shortcut you'll use most. Select the cell with the formula and the empty cells below it, press ⌘D, and the formula is copied down with its references adjusted. To continue a pattern instead, such as months or numbered rows, use the fill handle or AutoFill. The guide to AutoFill series shows how.

Shortcuts for formulas#

A few formula shortcuts are different on a Mac, and they're worth learning on purpose.

AutoSum looks at the numbers above (or to the left of) the active cell and writes a SUM for them. Press ⌘+Shift+T in the cell below a column of costs and Excel suggests =SUM(B2:B6). Press Return to accept it.

⌘T only toggles $ signs while you're editing a formula. Click on a reference in the formula bar and press it repeatedly to cycle through $B$2, B$2, $B2 and B2.

Shortcuts for formatting and data#

These are mostly the same as Windows with ⌘ or Control:

To insert a full row, select it first with Shift+Space, then press Control+Shift+=.

Which Mac shortcuts to learn first#

Don't try to learn everything at once. Start with these six, which cover most daily work and are the ones interviewers tend to notice:

1. ⌘+Arrow to jump.
2. ⌘+Shift+Arrow to select.
3. ⌘D to fill down.
4. ⌘+Shift+T for AutoSum.
5. ⌘T to lock references.
6. Control+U to edit a cell.

Use them for a week and they become automatic. Then add the rest. The Excel keyboard shortcuts cheat sheet lists Windows and Mac keys side by side, and the shortcuts interviewers notice explains which ones matter in a live test.

Practise it#

Practise jump shortcuts in a live spreadsheet, then practise selection shortcuts and fill down and fill right. Each lesson shows the Mac keys on a Mac and checks every step instantly. A few Mac shortcuts, such as ⌘T and ⌘+Shift+T, open new tabs in a web browser, so the practice grid tells you what to press instead.