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