📊 Excel Keyboard Shortcuts
Master Excel with these essential shortcuts for Windows and Mac
Navigation
| Action | Windows | Mac |
|---|---|---|
| Move to next cell | Tab |
Tab |
| Move to previous cell | Shift + Tab |
Shift + Tab |
| Move to beginning of row | Home |
Fn + Left Arrow |
| Move to cell A1 | Ctrl + Home |
Fn + Ctrl + Left Arrow |
| Move to last used cell | Ctrl + End |
Fn + Ctrl + Right Arrow |
| Go to specific cell | Ctrl + G |
Ctrl + G |
Selection
| Action | Windows | Mac |
|---|---|---|
| Select entire column | Ctrl + Space |
Ctrl + Space |
| Select entire row | Shift + Space |
Shift + Space |
| Select all cells | Ctrl + A |
Cmd + A |
| Extend selection by one cell | Shift + Arrow Key |
Shift + Arrow Key |
| Extend selection to last cell | Ctrl + Shift + End |
Cmd + Shift + End |
Formatting
| Action | Windows | Mac |
|---|---|---|
| Bold | Ctrl + B |
Cmd + B |
| Italic | Ctrl + I |
Cmd + I |
| Underline | Ctrl + U |
Cmd + U |
| Format cells dialog | Ctrl + 1 |
Cmd + 1 |
| Apply currency format | Ctrl + Shift + $ |
Ctrl + Shift + $ |
| Apply percentage format | Ctrl + Shift + % |
Ctrl + Shift + % |
Formulas & Functions
| Action | Windows | Mac |
|---|---|---|
| Start formula | = |
= |
| Insert SUM function | Alt + = |
Cmd + Shift + T |
| Show formulas | Ctrl + ` |
Ctrl + ` |
| Calculate all worksheets | F9 |
F9 |
| Toggle absolute/relative reference | F4 |
Cmd + T |
| Insert function | Shift + F3 |
Shift + F3 |
Data Manipulation
| Action | Windows | Mac |
|---|---|---|
| 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 |
| Replace | Ctrl + H |
Cmd + H |
Workbook & Worksheet
| Action | Windows | Mac |
|---|---|---|
| New workbook | Ctrl + N |
Cmd + N |
| Open workbook | Ctrl + O |
Cmd + O |
| Save workbook | Ctrl + S |
Cmd + S |
| Save as | F12 |
Cmd + Shift + S |
Ctrl + P |
Cmd + P |
|
| Insert new worksheet | Shift + F11 |
Shift + F11 |
| Switch to next worksheet | Ctrl + Page Down |
Fn + Ctrl + Down Arrow |