Excel on Mac vs Windows: Shortcuts and Differences

Excel Mac vs Windows shortcuts follow one main rule: where Windows uses Ctrl, the Mac usually uses ⌘ (Command). But a handful of important shortcuts don't follow the rule, including AutoSum, locking a reference with $ and editing a cell, and those are exactly the ones that slow people down in a test. Formulas and functions are the same on both. This guide is for anyone who learned Excel on one platform and has to use the other, or whose job test might run on a Mac.

Excel Mac vs Windows at a glance#

The spreadsheet is the same. The keyboard and a few advanced tools are not.

Excel Mac vs Windows shortcuts, side by side#

These are the shortcuts that come up in practice and in tests. "Same as Windows with ⌘" means you swap Ctrl for ⌘.

Three patterns cover most of the table:

1. Moving, selecting, copying and filling: swap Ctrl for ⌘. These are the shortcuts you use most.
2. Number formats and the date shortcut: keep Control. Pressing ⌘⇧$ does not apply currency.
3. A few are simply different: AutoSum (⌘⇧T), toggling $ (⌘T), editing a cell (Control+U) and the current time (⌘;). Learn these four on purpose.

If the symbols are new to you: ⌘ is Command, ⌥ is Option (the Mac's Alt key), ⌃ is Control and ⇧ is Shift.

Function keys on a Mac#

On most Mac laptops, the top row of keys controls brightness, volume and media by default. To send F2 or F4 to Excel, hold fn while you press it. If you use function keys a lot, your Mac's keyboard settings have an option to make the top row act as standard F1, F2 and so on keys, so you only hold fn for brightness and volume. Many Windows laptops have the same issue with a key labelled Fn.

The same task, done on both#

Say you have prices in B2:B5 and an exchange rate in E1. You want a converted price in C2:C5. Here is the same workflow with each keyboard:

The formula =B2*$E$1 is identical on both platforms. With a rate of 0.9, the laptop's 899 becomes 809.10. Only the keys you press to get there change. If the reference part is new to you, our guide to relative and absolute references explains the $ signs.

When the Windows layout matters#

Practise with Windows shortcuts when:

• The job or test uses Windows PCs, which is common in many offices.
• You use the ribbon from the keyboard. Pressing Alt shows letters over every ribbon command (Alt, H, B for borders, for example). Mac Excel has no Alt key tips.
• The role uses Power Pivot or Windows-only add-ins, as some finance and reporting roles do.

When the Mac layout matters#

Practise with Mac shortcuts when:

• You'll take the test on your own Mac, such as a take-home task or a test in Excel for Mac.
• The company gives staff Macs. Your speed depends on the keys you'll actually press.
• You're used to Windows and need to retrain the four shortcuts that are different, not just swap Ctrl for ⌘.

In ExcelReady, lessons show the right keys for your computer: ⌘ on a Mac and Ctrl on Windows. A few Mac shortcuts, such as ⌘T and ⌘⇧T, open browser tabs, so the practice grid tells you what to do instead.

Common mistakes when switching platforms#

These cost the most time:

1. Pressing Control+arrow on a Mac. macOS uses Control with the arrow keys to switch desktops. Use ⌘arrow to jump through data.
2. Pressing ⌘ for number formats. Currency and percent use Control+Shift, even on a Mac.
3. Pressing F4 on a Mac laptop without fn. The top row may change the brightness or volume instead. Hold fn, or use ⌘T.
4. Looking for F2 to edit. Use Control+U, fn+F2, or double-click the cell.
5. Expecting Alt+= for AutoSum on a Mac. It's ⌘⇧T.
6. Using Control+Space to select a column on a Mac. It often switches the keyboard language. Click the column letter instead.

Which shortcuts do interviewers notice?#

Interviewers watching you work notice speed through data more than anything: jumping with Ctrl+arrow (⌘arrow), selecting with Ctrl+Shift+arrow (⌘⇧arrow), filling with Ctrl+D (⌘D) and locking references with F4 (⌘T). These are the same ideas on both platforms. See the Excel shortcuts interviewers notice and our guide to selecting ranges fast in Excel for more.

Formulas don't change between Mac and Windows, so lookup skills carry over completely. If you're preparing for lookup questions, read VLOOKUP vs XLOOKUP and VLOOKUP vs INDEX MATCH. Shortcuts are physical skills, which is also why we argue for hands-on practice over video courses: you only get fast by pressing the keys.

Our recommendation#

Learn the shortcuts for the computer you will be tested on. If you don't know, learn the Windows ones and the Mac rule of thumb:

• Swap Ctrl for ⌘ for moving, selecting, copying and filling.
• Keep Control for the number formats and today's date.
• Learn four Mac exceptions by heart: ⌘⇧T (AutoSum), ⌘T (toggle $), Control+U (edit a cell) and ⌘; (current time).

Your formulas will work the same everywhere.

Practise it#

Lock the exchange rate in the exercise on this page with F4, ⌘T or fn+F4. Then build muscle memory with the jump to the edge of your data lesson, and the select ranges with Shift lesson. Both show the keys for your platform.