Excel 2016 Hot Keys
Efficiency, efficiency, efficiency – that is the name of the game in business. Microsoft Excel is a fantastic tool for business for a variety of reasons. Here are some of the most popular Hot Keys to help you be more efficient in your us of Excel.
Please note:
- Hot Keys separated by + need to held-down together – Example – First Hot Key Listed – Hold Ctrl down first then hit W
- Hot Keys separated by , do not need to be held down, only hit in the correct order – Example – Delete Column – Hold Down Alt then press H, A, and C in that order
| To do this | Press |
| Close a spreadsheet | Ctrl + W |
| Open a spreadsheet | Ctrl + O |
| Go to the Home tab | Alt + H |
| Save a spreadsheet | Ctrl + S |
| Copy | Ctrl + C |
| Cut | Ctrl + X |
| Paste | Ctrl + V |
| Paste using the Paste Special dialog box. | Ctrl + Alt + V |
| Undo | Ctrl + Z |
| Redo or Repeat the last command | Ctrl + Y |
| Italicize or Remove Italics | Ctrl + I or Ctrl + 3 |
| Bold or Remove Bold | Ctrl + B or Ctrl + 2 |
| Underline or Remove Underlining | Ctrl + U or Ctrl + 4 |
| Remove cell contents | Delete key |
| Delete Column | Alt + H, D, then C |
| Apply General Number Formatting | Ctrl + Shift + ~ |
| Apply Currency Formatting | Ctrl + Shift + $ |
| Apply Percentage Formatting | Ctrl + Shift + % |
| Apply Scientific Number Formatting | Ctrl + Shift + ^ |
| Apply Date Formatting | Ctrl + Shift + # |
| Apply Time Formatting | Ctrl + Shift + @ |
| Enter Current Time | Ctrl + Shift + : |
| Enter Current Date | Ctrl + ; |
| Center Align Cell Contents | Alt + H, A, then C |
| Add Borders | Alt + H, B |
| Move to the lowest used cell (lowest used row of the rightmost used column) | Ctrl + End |
| Extend the selection of cells to the last used cell | Ctrl + Shift + End |
| Hide Selected Rows | Ctrl + 9 |
| Hide Selected Columns | Ctrl + 0 |
| Create/Edit a Hyperlink | Ctrl + K |
| Check Spelling | F7 |
| Start a new line within selected cell | Alt + Enter |
| Go to Formula Tab | Alt + M |
| Expand/Collapse the Formula Bar | Ctrl + Shift + U |
| Insert a Function | Shift + F3 |
| Create, run, edit, or delete a macro | Alt + F8 |