Microsoft Excel: 5 Shortcuts You Should Know

» Articles » General Business Articles » Article

March 30, 2022
Author: Lorman Education

Microsoft Excel is a powerful tool, which sometimes mean it can be cumbersome to use. By mastering shortcuts, you can execute common tasks much more efficiently. Learn the top 5 shortcuts to increase productivity. 

1. Insert a new Worksheet

If your workbooks involve multiple sheets, it can pay to know how to quickly add new sheets. 

With a workbook open, press and hold the SHIFT key. Now tap F11 and release both. You should see a new worksheet at the bottom of the page.

You can repeat this action as many times as you need, adding dozens of sheets in a flash.

2. Enter SUM Functions

The SUM function is used to add up a set of data. To execute this, the data must be entered into consecutive rows in the same column of a worksheet.

Click on any empty row after the last row of data to make it active. Press down the ALT key and tap the equal sign (=) on your keyboard. Then, release the ALT key and you will be able to see the sum function in the selected row cell. Press the ENTER key to execute it and view the resultant sum in the selected cell.

3. Insert a Hyperlink

Hyperlinks are an important feature of many Excel reports. To add a hyperlink via a shortcut, you must first add your anchor text, or the text that will be displayed, in a cell of your workbook. 

Click on the cell containing your anchor text, hold down CTRL and tap 'K'. This will open up the 'Insert Hyperlink' dialog box. Enter the URL in the 'Address' text box and click OK.

You will notice that the text becomes blue and underlined, indicating that it holds a hyperlink.

4. Display Formulas

The ‘show formulas’ function changes the way the spreadsheet is displayed without changing the content. It shows all formulas used in the spreadsheet and will make it easy for you when looking for errors.

Press down your CTRL key and tap the grave accent (`), or the key above 'TAB,' to turn on ‘show formulas’.

5. Select Non-Adjacent Cells

Selecting multiple cells allows you to apply formatting or other options for large areas in your worksheet simultaneously. You likely use the drag select tool already to quickly highlight adjacent cells, but non-adjacent cells require additional clicks.

Click on the first cell, hold down CTRL, and click on all the other cells you want to select. Then release CTRL.

You will notice that all the cells you clicked on will be highlighted and ready for formatting.

In Conclusion

Excel shortcut keys can save you hours of manual work. For more time-saving tips and tricks, browse dozens of live and ondemand courses now.

The material appearing in this web site is for informational purposes only and is not legal advice. Transmission of this information is not intended to create, and receipt does not constitute, an attorney-client relationship. The information provided herein is intended only as general information which may or may not reflect the most current developments. Although these materials may be prepared by professionals, they should not be used as a substitute for professional services. If legal or other professional advice is required, the services of a professional should be sought.

The opinions or viewpoints expressed herein do not necessarily reflect those of Lorman Education Services. All materials and content were prepared by persons and/or entities other than Lorman Education Services, and said other persons and/or entities are solely responsible for their content.

Any links to other web sites are not intended to be referrals or endorsements of these sites. The links provided are maintained by the respective organizations, and they are solely responsible for the content of their own sites.