Despite being around for over three decades, Microsoft Excel remains a powerful tool, especially when collating and analyzing information. Throughout the years, the application has been updated to newer versions, each coming with more functionalities and shortcuts.

Today there are several (300+) shortcuts that users can apply when working with the application. You can check out a comprehensive list of these excel shortcuts and tips. We know 300+ is an awful lot of them. Don’t worry, though – you only need to master about ten or so that will suffice. Below we’ve compiled a list of the most frequent and important shortcuts that will make your work on Excel easier.

Basic must-know Excel shortcuts

Let’s start with the most basic excel shortcuts for beginners learning about Excel. Note that the ‘+’ sign means pressing the keys simultaneously.

Ctrl + O Open a workbook
W Close a workbook
S Save your workbook
C Copy contents of a specific cell(s)
Z Undo the latest action performed
X Cut the contents of a specific cell(s)
P Bring up the print menu
V Paste the copied content into a specific cell(s)

Advanced Excel shortcuts

There are different advanced shortcuts as grouped below:

Shortcuts for formatting data

Ctrl + 1 Bring up the ‘format cells’ option
Shift + Colon Fill in the current time in a cell
Colon Insert the current date
Space Select an entire column

Viewing/navigating through data

Home Return to the first cell
Tab Move to the next cell
Ctrl +

 

F1 Hide/show the ribbon
Tab Move to the next open workbook
PgDn Move to the next worksheet
PgUp Return to the previous sheet
G Bring up the ‘Go to (& Reference)’ option
F Bring up the ‘Find (& Replace)’ option

Other shortcuts

Additional shortcuts when working with Excel include:

Ctrl + * Highlight an active range in the cell with the entire data area between the blank columns and rows
F2 Edit the working cell and set the insertion point at the end of the cell content
Ctrl + Y Redo an undo command
F6 Include the split panes as you switch between different areas in a split worksheet. Also, allows you to move between the worksheet, Zoom controls, ribbon , and task pane
F12 Quickly and directly bring up the ‘save as’ menu
Ctrl + Enter Insert the contents of the current entry into  the specific cell range
Ctrl + Alt + V Bring up the ‘Paste Special dialog’ menu
Shift + Spacebar Select an entire row for a function

The shortcuts above will help you work smart when using Excel. However, do not be in a hurry to apply all of them at once. Take some time to master them before using them where relevant.  You will not only save time but also have a smooth experience using the application. Keep in mind that some may not work with your Excel if you’re using an outdated version.

 

LEAVE A REPLY

Please enter your comment!
Please enter your name here