Shortcuts

Excel keyboard shortcuts for Windows, Mac and Google Sheets

You don’t need hundreds of shortcuts. These are the ones analysts use every hour, for Windows, Mac and Google Sheets.

Navigate

Action	Excel (Windows)	Excel (Mac)	Google Sheets
Jump to the edge of the data	`Ctrl + Arrow`	`Cmd + Arrow`	`Ctrl/Cmd + Arrow`
Select to the edge of the data	`Ctrl + Shift + Arrow`	`Cmd + Shift + Arrow`	`Ctrl/Cmd + Shift + Arrow`
Select the whole column	`Ctrl + Space`	`Ctrl + Space`	`Ctrl + Space`
Select the whole row	`Shift + Space`	`Shift + Space`	`Shift + Space`
Select all	`Ctrl + A`	`Cmd + A`	`Ctrl/Cmd + A`
Find	`Ctrl + F`	`Cmd + F`	`Ctrl/Cmd + F`

Action	Excel (Windows)	Excel (Mac)	Google Sheets
Copy / paste	`Ctrl + C / Ctrl + V`	`Cmd + C / Cmd + V`	`Ctrl/Cmd + C / V`
Undo / redo	`Ctrl + Z / Ctrl + Y`	`Cmd + Z / Cmd + Y`	`Ctrl/Cmd + Z / Y`
Fill down	`Ctrl + D`	`Cmd + D`	`Ctrl/Cmd + D`
Fill right	`Ctrl + R`	`Cmd + R`	`Ctrl/Cmd + R`
Edit the active cell	`F2`	`Ctrl + U`	`F2 or Enter`
Insert today’s date	`Ctrl + ;`	`Ctrl + ;`	`Ctrl/Cmd + ;`

Action	Excel (Windows)	Excel (Mac)	Google Sheets
Toggle absolute references ($)	`F4`	`Cmd + T`	`F4`
AutoSum	`Alt + =`	`Cmd + Shift + T`	—

Action	Excel (Windows)	Excel (Mac)	Google Sheets
Bold / italic	`Ctrl + B / Ctrl + I`	`Cmd + B / Cmd + I`	`Ctrl/Cmd + B / I`
Format cells dialog	`Ctrl + 1`	`Cmd + 1`	—

Tip: on a Mac, some function-key shortcuts need the Fn key, and macOS may grab Ctrl + Space for switching input languages.