Practice free

Excel keyboard shortcuts

Excel has hundreds of shortcuts, but most people lean on the same thirty or so every day. This page lists only those, grouped by task with the ones you’ll use most at the top. Type in the box to find one fast, switch between Windows and Mac keys, or print the list as a one-page cheat sheet.

Every Windows shortcut here was tested in desktop Excel. The Mac keys come from Microsoft’s own list and haven’t been pressed on a Mac by us yet, so they’re marked until we have.

Two habits make most of these easier. Hold Shift with any move shortcut to select as you go: Ctrl+Down jumps to the bottom of the data, and Ctrl+Shift+Down selects everything on the way. And to insert or delete whole rows, select the rows first with Shift+Space, then press Ctrl+Shift+= or Ctrl+-.

Copy, paste and undo

What it doesWindowsMac
Copy Ctrl+C Cmd+C
Cut Ctrl+X Cmd+X
Paste Ctrl+V Cmd+V
Paste Special (values, formats and more) Ctrl+Alt+V Cmd+Ctrl+V
Undo Ctrl+Z Cmd+Z
Redo Ctrl+Y Cmd+Y

Move around

What it doesWindowsMac
Jump to the last filled cell in a direction Ctrl+Arrow Cmd+Arrow
Go to cell A1 Ctrl+Home Ctrl+Home
Next or previous sheet Ctrl+PageDown / Ctrl+PageUp Option+Right / Option+Left
Find Ctrl+F Ctrl+F

Select

What it doesWindowsMac
Select to the end of the data Ctrl+Shift+Arrow Cmd+Shift+Arrow
Select the data around the cell, press again for the whole sheet Ctrl+A Cmd+A
Select the whole column Ctrl+Space Ctrl+Space
Select the whole row Shift+Space Shift+Space

Formulas

What it doesWindowsMac
Edit the active cell F2 F2
Lock a reference ($A$1) while editing F4 Cmd+T
AutoSum Alt+= Cmd+Shift+T
Enter the same formula in every selected cell Ctrl+Enter Cmd+Return
Show formulas instead of results Ctrl+` Ctrl+`

Format

What it doesWindowsMac
Bold Ctrl+B Cmd+B
Strikethrough Ctrl+5 Cmd+Shift+X
Open Format Cells Ctrl+1 Cmd+1
Currency format Ctrl+Shift+$ Ctrl+Shift+$
Percent format Ctrl+Shift+% Ctrl+Shift+%

Rows and columns

What it doesWindowsMac
Insert rows or columns (select whole rows or columns first) Ctrl+Shift+= Ctrl+Shift+=
Delete rows or columns Ctrl+- Cmd+-
Hide rows or columns Ctrl+9 / Ctrl+0 Ctrl+9 / Ctrl+0
Fit column width to the contents Alt, H, O, I No shortcutMac Excel has no ribbon key tips. Double-click the column's right border instead.

Files

What it doesWindowsMac
Save Ctrl+S Cmd+S
Open Ctrl+O Cmd+O
New workbook Ctrl+N Cmd+N
Print Ctrl+P Cmd+P

Cmd A dashed key means we took it from Microsoft's list and haven't pressed it on a Mac yet. On many Mac keyboards the F keys need Fn held down.

Practice it for real

Short drills in an Excel-style grid, checked the moment you press Enter.

Practice free