Basic Excel Shortcuts
| Action | Shortcut Key |
| New Workbook | Ctrl + N |
| Open Workbook | Ctrl + O |
| Save Workbook | Ctrl + S |
| Print Workbook | Ctrl + P |
| Close Workbook | Ctrl + W |
| Undo | Ctrl + Z |
| Redo | Ctrl + Y |
| Cut | Ctrl + X |
| Copy | Ctrl + C |
| Paste | Ctrl + V |
| Paste Special | Ctrl + Alt + V |
| Select All Cells | Ctrl + A |
| Find | Ctrl + F |
| Replace | Ctrl + H |
| Go To (Cell Reference) | Ctrl + G or F5 |
Cell Navigation Shortcuts
| Action | Shortcut Key |
| Move to the beginning of the row | Home  |
| Move to the beginning of the sheet | Ctrl + Home |
| Move to the last cell of the data range | Ctrl + End |
| Move to the next worksheet | Ctrl + Page Down |
| Move to the previous worksheet | Ctrl + Page Up |
| Move one cell up | Arrow Up ↑ |
| Move one cell down | Arrow Down ↓ |
| Move one cell left | Arrow Left ← |
| Move one cell right | Arrow Right → |
Formatting Shortcuts
- Ctrl + B: Bold text
- Ctrl + I: Italicize text
- Ctrl + U: Underline text
- Ctrl + 1: Format cells dialog box
- Ctrl + Shift + L: Add or remove filter
- Alt + E, S, V: Paste special
- Ctrl + Shift + “$”: Format as currency
- Ctrl + Shift + “%”: Format as percentage
- Ctrl + Shift + “!”: Format as number
Formulas and Functions
- =: Start a formula
- Alt + =: AutoSum (sum of selected cells)
- Ctrl + Shift + Enter: Enter an array formula
Worksheet Shortcuts
- Ctrl + Page Up/Page Down: Switch between worksheets
- Shift + F11: Insert a new worksheet
Cell Editing
- Ctrl + D: Fill selected cells with the value from the cell above
- Ctrl + R: Fill selected cells with the value from the cell to the left
- F4: Repeat the last action
- Shift + F2: Add/edit a comment
Others
- Ctrl + K: Insert hyperlink
- Ctrl + T: Create a table