Excel Shortcuts

Excel Shortcuts Cheat Sheet: Windows vs Mac

The general rule for converting Excel shortcuts between platforms is simple: swap Ctrl for Cmd. That rule gets you through most of Excel — but it breaks in specific, memorable ways, and those exceptions are exactly the shortcuts that trip people up when they switch computers. This page is about the exceptions, not another full copy of the shortcut list (you can find the complete side-by-side table on the full Excel shortcuts page).

The rule: Ctrl becomes Cmd

Copy, paste, undo, save, bold, italic — all of these follow the simple swap. If you already know the Windows shortcut, replace Ctrl with Cmd and you’re done.

ActionWindowsMac
CopyCtrl + CCmd + C
PasteCtrl + VCmd + V
UndoCtrl + ZCmd + Z
SaveCtrl + SCmd + S
BoldCtrl + BCmd + B

Exception 1: A few shortcuts keep Ctrl on Mac

Not everything swaps. A handful of Excel shortcuts use the same Ctrl key on both Windows and Mac — usually because they’re inherited from the operating system’s own text-editing conventions rather than from Excel itself.

ActionWindowsMac
FindCtrl + FCtrl + F
Open the Font tab of Format CellsCtrl + Shift + PCtrl + Shift + P
StrikethroughCtrl + 5Ctrl + 5
Select the entire columnCtrl + SpaceCtrl + Space
Expand or collapse the formula barCtrl + Shift + UCtrl + Shift + U
Enter the current dateCtrl + ;Ctrl + ;

Exception 2: Some Mac shortcuts use an entirely different key

These aren’t a simple Ctrl-to-Cmd swap — the actual letter or symbol changes too, usually to avoid colliding with a macOS system shortcut.

ActionWindowsMac
Apply or remove filterCtrl + Shift + LCmd + Shift + F
Apply the currency formatCtrl + Shift + $Ctrl + Shift + 4
Apply the percentage formatCtrl + Shift + %Ctrl + Shift + 5
Apply the date formatCtrl + Shift + #Ctrl + Shift + 3
Insert a blank row or columnCtrl + Shift + +Cmd + Shift + ;
Open Paste SpecialCtrl + Alt + VCmd + Alt + V

The number-format ones are the easiest to get wrong: on Windows you’re pressing the symbol ($, %, #), but on Mac you press the plain number key underneath it (4, 5, 3) — the symbol isn’t what Excel is actually looking for, it’s whatever’s on that physical key.

Everything at once

Want to practice both layouts side by side instead of memorizing exceptions? The trainer below shows Windows and Mac for every question, so you build the right one for whichever machine you’re on:

STARTSTOP
*Toggle input mode: ctrl + shift + alt + space
PRE
NEXT
Exclude this question from the list
Restore excluded questions
Get a URL for the current exclusions
https://command-lab.com
Copy
Guide mode
Repeat mode

*Recommended browser: Google Chrome

PUSH ENTER

For the full categorized reference, see the complete Excel keyboard shortcuts list.

💡 Excelのショートカットは、Command Labで実際に練習できます。
クイズ形式で操作しながらショートカットキーを体で覚えられる無料ツールです。

Excelショートカット練習をはじめる →

コメントを残す

メールアドレスが公開されることはありません。 が付いている欄は必須項目です

CAPTCHA