If you spend a chunk of your time each day on Microsoft Excel like we do, you probably know how much time you can save by utilizing some of the keyboard shortcuts within Excel. This is of course not an all-inclusive list, but the following are some shortcuts we have found to be the biggest time-savers.
The Basics
| Ctrl + O |
Open a workbook |
| Ctrl + S |
Save |
| Ctrl + W |
Close |
| Ctrl + C |
Copy |
| Ctrl + X |
Cut |
| Ctrl + V |
Paste |
| Ctrl + Z |
Undo |
Navigating and Data Manipulation
| Ctrl + Shift + L |
Filter |
| Ctrl + Shift + Arrow Key |
Extend selection to last cell in a dataset |
| Ctrl + A |
Select entire worksheet |
| Alt + I + R |
Insert row |
| Alt + I + C |
Insert column |
| Shift + Spacebar |
Select an entire row |
| Ctrl + Spacebar |
Select an entire column |
| Ctrl + Minus (-) |
If you have a row or column selected, it will delete the row or column. If you have cells selected, it will open the Delete dialogue box |
| Ctrl + 9 |
Hide selected rows |
| Ctrl + 0 |
Hide selected columns |
| Ctrl + Home |
Move to the beginning of a worksheet |
| Ctrl + Page Down/Page Up |
Move to the next/previous sheet in a workbook |
Formatting
| Ctrl + B |
Bold |
| Ctrl + I |
Italics |
| F2 |
Edit the selected cell |
| Ctrl + Shift + # |
Apply Date format |
| Ctrl + Shift + $ |
Apply Currency format |
| Ctrl + Shift + % |
Apply Percent format |
| Ctrl + K |
Insert Hyperlink |
| Alt + Enter |
When in a selected cell, creates a new line within the cell |
| Esc |
When in a selected cell, cancels any changes |
| F4 |
Repeat last command (such as formatting) |
You can view our previous Excel Tips & Tricks articles here:
Using the VLookup Function
Using PivotTables
