Practice free

Excel shortcuts cheat sheet

Windows. Every shortcut tested in desktop Excel. formulafluent.com/shortcuts/

Mac. Keys from Microsoft's list, not yet tested on a Mac by us. formulafluent.com/shortcuts/

Copy, paste and undo

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

Move around

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

Select

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

Formulas

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

Format

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

Rows and columns

Ctrl+Shift+= Ctrl+Shift+=
Insert rows or columns (select whole rows or columns first)
Ctrl+- Cmd+-
Delete rows or columns
Ctrl+9 / Ctrl+0 Ctrl+9 / Ctrl+0
Hide rows or columns
Alt, H, O, I No shortcut
Fit column width to the contents

Files

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