Appendix 3
Excel Hot Keys
| Description | Description | ||
| File Operations | Shortcut Key | Cell Formatting | Shortcut Key |
| New file | Ctrl + N | Format cells | Ctrl + 1 |
| Open file | Ctrl + O | Format as currency | Ctrl + Shift + 4 |
| Save file | Ctrl + S | Format as date | Ctrl + Shift + 3 |
| Close file | Ctrl + F4 | Format as percentage | Ctrl + Shift + 5 |
| Save as | F12 | Format as number | Ctrl + Shift + 1 |
| Exit Excel | Alt + F4 | Bold | Ctrl + B |
| Ctrl + P | Italicize | Ctrl + I | |
| Cell Operations | Underline | Ctrl + U | |
| Edit active cell | F2 | Strikethrough | Ctrl + 5 |
| Cancel cell editing | Escape Key | Add cell borders | Ctrl + Shift + 7 |
| Cut | Ctrl + X | Remove all borders | Ctrl + Shift + - (minus) |
| Copy | Ctrl + C | ||
| Paste | Ctrl + V | ||
| Selecting Cells | |||
| Copy right | Ctrl + R | Select entire worksheet | Ctrl + A |
| Copy down | Ctrl + D | ||
| Create cell comment | Shift + F2 | Select group area | Ctrl + Shift + 8 |
| Select column | Ctrl + Space | ||
| Select row | Shift + Spacebar | ||
| Select manually | Hold Shift + Left, Right, Up, Down Arrow Key |
| Worksheet Navigation | Other Operations | ||
| Up one screen | Page Up | Find text | Ctrl + F |
| Down one screen | Page Down | Replace text | Ctrl + H |
| Move to next worksheet | Ctrl + Page Down | Undo last action | Ctrl + Z |
| Move to previous worksheet | Ctrl + Page Up | Redo last action | Ctrl + Y |
| Go to first cell in worksheet area | Ctrl + Home | Create a chart | F11 |
| Go to last cell in worksheet area | Ctrl + End | Spell check | F7 |
| Go to formula source | Ctrl + { | Show all formulas | Ctrl + ∼ |
| Go to a cell | F5 | Insert columns/rows | Ctrl + Shift ... |
Get Mergers, Acquisitions, Divestitures, and Other Restructurings, + Website now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
