Microsoft Excel Keyboard Shortcuts | Keyboard Shortcut Reference

Keyboard Shortcut Reference

Navigation

Action	Windows	Mac
Move to beginning of row	`Home`	`Fn + Left`
Move to cell A1	`Ctrl + Home`	`Ctrl + Fn + Left`
Move to last used cell	`Ctrl + End`	`Ctrl + Fn + Right`
Move one screen down	`Page Down`	`Fn + Down`
Move one screen up	`Page Up`	`Fn + Up`
Move to next sheet	`Ctrl + Page Down`	`Ctrl + Fn + Down`
Move to previous sheet	`Ctrl + Page Up`	`Ctrl + Fn + Up`
Go to specific cell	`Ctrl + G`	`Cmd + G`

Selection

Action	Windows	Mac
Select entire row	`Shift + Space`	`Shift + Space`
Select entire column	`Ctrl + Space`	`Ctrl + Space`
Select all cells	`Ctrl + A`	`Cmd + A`
Extend selection by one cell	`Shift + Arrow`	`Shift + Arrow`
Extend selection to last non-empty cell	`Ctrl + Shift + Arrow`	`Cmd + Shift + Arrow`
Select to beginning of row	`Shift + Home`	`Shift + Fn + Left`

Editing

Action	Windows	Mac
Edit active cell	`F2`	`F2`
Copy	`Ctrl + C`	`Cmd + C`
Cut	`Ctrl + X`	`Cmd + X`
Paste	`Ctrl + V`	`Cmd + V`
Paste special	`Ctrl + Alt + V`	`Cmd + Ctrl + V`
Undo	`Ctrl + Z`	`Cmd + Z`
Redo	`Ctrl + Y`	`Cmd + Y`
Find	`Ctrl + F`	`Cmd + F`
Find and replace	`Ctrl + H`	`Cmd + H`
Delete cell contents	`Delete`	`Delete`
Fill down	`Ctrl + D`	`Cmd + D`
Fill right	`Ctrl + R`	`Cmd + R`

Formatting

Action	Windows	Mac
Bold	`Ctrl + B`	`Cmd + B`
Italic	`Ctrl + I`	`Cmd + I`
Underline	`Ctrl + U`	`Cmd + U`
Format as currency	`Ctrl + Shift + 4`	`Ctrl + Shift + 4`
Format as percentage	`Ctrl + Shift + 5`	`Ctrl + Shift + 5`
Format as date	`Ctrl + Shift + 3`	`Ctrl + Shift + 3`
Format cells dialog	`Ctrl + 1`	`Cmd + 1`
Apply outline border	`Ctrl + Shift + &`	`Cmd + Option + 0`

Formulas

Action	Windows	Mac
Start formula	`=`	`=`
AutoSum	`Alt + =`	`Cmd + Shift + T`
Toggle formula view	Ctrl + `	Ctrl + `
Insert function	`Shift + F3`	`Shift + F3`
Enter array formula	`Ctrl + Shift + Enter`	`Cmd + Shift + Enter`
Calculate all worksheets	`F9`	`F9`

Workbook

Action	Windows	Mac
New workbook	`Ctrl + N`	`Cmd + N`
Open workbook	`Ctrl + O`	`Cmd + O`
Save	`Ctrl + S`	`Cmd + S`
Save as	`F12`	`Cmd + Shift + S`
Print	`Ctrl + P`	`Cmd + P`
Close workbook	`Ctrl + W`	`Cmd + W`
Insert new worksheet	`Shift + F11`	`Shift + F11`

Data

Action	Windows	Mac
Insert row	`Ctrl + Shift + +`	`Cmd + Shift + +`
Delete row	`Ctrl + -`	`Cmd + -`
Group rows/columns	`Alt + Shift + Right`	`Cmd + Shift + K`
Ungroup rows/columns	`Alt + Shift + Left`	`Cmd + Shift + J`
Create table	`Ctrl + T`	`Cmd + T`
Sort ascending	`Alt + A, S, A`	`Cmd + Shift + R`