Excel Shortcuts
Common Excel keyboard shortcuts for Windows and Mac.
Whether you are building spreadsheets daily or only open Excel once in a while, keyboard shortcuts dramatically cut the time spent on repetitive tasks. This cheatsheet is designed for office workers, analysts, and students who want to navigate, format, and calculate faster on both Windows and Mac.
| Action | Windows | Mac |
|---|---|---|
| Create New Workbook | Ctrl + N | ⌘ + N |
| Open Workbook | Ctrl + O | ⌘ + O |
| Save Workbook | Ctrl + S | ⌘ + S |
| Close Workbook | Ctrl + W | ⌘ + W |
| Undo | Ctrl + Z | ⌘ + Z |
| Redo | Ctrl + Y | ⌘ + Y |
| Copy | Ctrl + C | ⌘ + C |
| Cut | Ctrl + X | ⌘ + X |
| Paste | Ctrl + V | ⌘ + V |
| Find | Ctrl + F | ⌘ + F |
| Replace | Ctrl + H | ⌃ + H |
| Ctrl + P | ⌘ + P | |
| Select All | Ctrl + A | ⌘ + A |
| Select Entire Column | Ctrl + Space | ⌃ + Space |
| Select Entire Row | Shift + Space | Shift + Space |
| Move to Edge of Data Region | Ctrl + Arrow Key | ⌘ + Arrow Key |
| Move One Screen Down | Page Down | Fn + Down |
| Move One Screen Up | Page Up | Fn + Up |
| Bold | Ctrl + B | ⌘ + B |
| Italic | Ctrl + I | ⌘ + I |
| Underline | Ctrl + U | ⌘ + U |
| Format Cells Dialog | Ctrl + 1 | ⌘ + 1 |
| Add Border | Alt + H, B | ⌘ + Option + Border |
| Apply Currency Format | Ctrl + Shift + $ | ⌃ + Shift + $ |
| Apply Percentage Format | Ctrl + Shift + % | ⌃ + Shift + % |
| Apply Date Format | Ctrl + Shift + # | ⌃ + Shift + # |
| AutoSum | Alt + = | ⌘ + Shift + T |
| Toggle Formulas | Ctrl + ` | ⌃ + ` |
| Insert Function | Shift + F3 | Shift + F3 |