Excel keyboard shortcuts for Windows and Mac

The shortcuts that save the most time in everyday spreadsheet work. Most have a drill: open it and do the task on a live sheet until the shortcut takes one key press.

Moving around

What it does	Windows	Mac	Practice
Jump to the edge of the data	`Ctrl+Arrow`	`Cmd+Arrow`	Practice
Go to cell A1	`Ctrl+Home`	`Fn+Cmd+Left arrow`	Practice
Go to the last used cell	`Ctrl+End`	`Fn+Cmd+Right arrow`	Practice
Go to the start of the row	`Home`	`Fn+Left arrow`	Practice
Move one screen down or up	`Page Down / Page Up`	`Fn+Down / Fn+Up arrow`
Next or previous worksheet	`Ctrl+Page Down / Ctrl+Page Up`	`Option+Right / Option+Left arrow`
Go to a cell or named range	`Ctrl+G or F5`	`Ctrl+G`

Selecting

What it does	Windows	Mac	Practice
Extend the selection to the edge of the data	`Ctrl+Shift+Arrow`	`Cmd+Shift+Arrow`	Practice
Select the whole row	`Shift+Space`	`Shift+Space`	Practice
Select the whole column	`Ctrl+Space`	`Control+Space`	Practice
Select the current table (twice: the whole sheet)	`Ctrl+A`	`Cmd+A`	Practice
Select to the last used cell	`Ctrl+Shift+End`	`Fn+Cmd+Shift+Right arrow`	Practice
Select back to A1	`Ctrl+Shift+Home`	`Fn+Cmd+Shift+Left arrow`	Practice
Select to the start of the row	`Shift+Home`	`Fn+Shift+Left arrow`	Practice

Formatting

What it does	Windows	Mac	Practice
Bold, italic, underline	`Ctrl+B / Ctrl+I / Ctrl+U`	`Cmd+B / Cmd+I / Cmd+U`	Practice
Currency format	`Ctrl+Shift+4`	`Control+Shift+4`	Practice
Percent format	`Ctrl+Shift+5`	`Control+Shift+5`	Practice
Number format with thousands separator	`Ctrl+Shift+1`	`Control+Shift+1`	Practice
Date format	`Ctrl+Shift+3`	`Control+Shift+3`	Practice
General format (clear the number format)	Ctrl+Shift+`	`Control+Shift+~`	Practice
Open Format Cells	`Ctrl+1`	`Cmd+1`

Editing

What it does	Windows	Mac	Practice
AutoSum	`Alt+=`	`Cmd+Shift+T`	Practice
Fill down / fill right	`Ctrl+D / Ctrl+R`	`Cmd+D / Cmd+R`	Practice
Insert today's date	`Ctrl+;`	`Control+;`	Practice
Undo / redo	`Ctrl+Z / Ctrl+Y`	`Cmd+Z / Cmd+Y`	Practice
Copy, cut, paste	`Ctrl+C / Ctrl+X / Ctrl+V`	`Cmd+C / Cmd+X / Cmd+V`	Practice
Clear the selected cells	`Delete`	`Fn+Delete`	Practice
Delete the selected rows	`Ctrl+-`	`Control+-`	Practice
Insert rows	`Ctrl+Shift+=`	`Control+Shift+=`	Practice
Turn filters on or off	`Ctrl+Shift+L`	`Cmd+Shift+F`	Practice
Edit the active cell	`F2`	`Control+U`
Switch between relative and absolute references	`F4`	`Cmd+T`
New line inside a cell	`Alt+Enter`	`Option+Return`
Fill the selection with what you typed	`Ctrl+Enter`	`Control+Return`
Paste Special	`Ctrl+Alt+V`	`Control+Cmd+V`

Workbook

What it does	Windows	Mac
Save	`Ctrl+S`	`Cmd+S`
Save as	`F12`	`Cmd+Shift+S`
Find / replace	`Ctrl+F / Ctrl+H`	`Cmd+F / Control+H`
Create a table	`Ctrl+T`	`Cmd+T`
Hide rows / hide columns	`Ctrl+9 / Ctrl+0`	`Control+9 / Control+0`

Mac shortcuts are for Excel for Mac with a standard keyboard. On a laptop without Home and End keys, Fn with the arrows does the same job.

Start the drills