CALL US 301-663-403


Excel Tips & Tricks – Keyboard Shortcuts

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


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

home-icon-silhouette remove-button instagram twitter linkedin phone-call plus chevron-arrow-down right-arrow double-right-arrows-angles