Covers navigation, formatting, formulas, and selection. Handy for office workers, analysts, or students who want to speed up daily spreadsheet tasks.
Covers navigation, formatting, formulas, and selection. Handy for office workers, analysts, or students who want to speed up daily spreadsheet tasks.
| 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 |