Excel has a large number of keyboard shortcuts that can save you time and reduce the number of mouse clicks required to perform common tasks.
Windows key
Mac, command key =
or Command
For shortcuts with + symbol, press all keys together.
For shortcuts with → symbol, press and release all keys in order.
Data Editing
Action | Windows | Mac |
Copy | Ctrl + C | Command + C |
Cut | Ctrl + X | Command + X |
| Paste | Ctrl + V | Command + V |
| Undo | Ctrl + Z | Command + Z |
| Redo | Ctrl + Y | Command + Y |
| Find | Ctrl + F | Control + F |
| Replace | Ctrl + H | Control + H |
Formatting
Action | Windows | Mac |
| Open Format Cell Dialog | Ctrl + 1 | Command + 1 |
| Bold | Ctrl + B | Command + B |
| Italic | Ctrl + I | Command + I |
| Underline | Ctrl + U | Command + U |
| Strikethrough | Ctrl + 5 | Command + Shift + X |
| Number Format | Ctrl + Shift + ! | Control + Shift + ! |
| Percent Format | Ctrl + Shift + % | Control + Shift + % |
| Date Format | Ctrl + Shift + # | Control + Shift + # |
| Increase Decimal | Alt → H → 0 | |
| Decrease Decimal | Alt → H → 9 |
Borders
Action | Windows | Mac |
| Outline Border | Ctrl + Shift + & | Control + Shift + & |
| Remove Border | Ctrl + Shift + - | Control + Shift + - |
| Top Border | Alt + H → B → T | Command + Option + ↑ |
| Bottom Border | Alt + H → B → O | Command + Option + ↓ |
| Left Border | Alt + H → B → L | Command + Option + ← |
| Right Border | Alt + H → B → R | Command + Option + → |
Navigating across/around worksheet
Action | Windows | Mac |
| Move to End of Contiguous Range | Ctrl + Arrows (←→↑↓) | Command + Arrows (←→↑↓) |
| Move One Screen Up | Page Up | Fn + ↑ |
| More One Screen Down | Page Down | Fn + ↓ |
| Move One Screen Left | Alt + Page Up | Fn + Option + ↑ |
| Move One Screen Right | Alt + Page Down | Fn + Option + ↓ |
| Go to Beginning of Row | Home | Fn + ← |
| Go to Cell A1 | Ctrl + Home | Fn + Ctrl + ← |
| Jump to Next Worksheet | Ctrl + Page Down | |
| Jump to Previous Work Sheet | Ctrl + Page Up | |
| Freeze pane (Row and Column) | Alt + W → F → F |
Selecting Cells
Action | Windows | Mac |
| Select Cell Range | Shift + Arrows (←→↑↓) | Shift + Arrows (←→↑↓) |
| Select Contiguous Cell Range | Ctrl + Shift + Arrows (←→↑↓) | Command + Shift + Arrows (←→↑↓) |
| Select All | Ctrl + A | Command + A |
| Select Column | Ctrl + Spacebar | Fn + Ctrl + Spacebar |
| Select Row | Shift +Spacebar | Fn + Shift +Spacebar |
| Delete Row/Column | Ctrl + - | Control + - |
| Insert Row/Column | Ctrl + Shift + + | Control + Shift + + |