≡ Menu

How to use Keyboard Shortcuts in Microsoft Excel to increase productivity

Using keyboard shortcuts can allow you to save a lot of time when working with repetitive tasks. Using keyboard shortcuts in Microsoft Excel helps you increase your efficiency and productivity to use Microsoft Excel like a Power User.

In this Excel Tip and Trick we take a look at how we can use Excel Shortcuts to accomplish some of the key functionality of Excel without using a mouse.

We will learn how to use keyboard shortcuts to accomplish the copying of data, formatting of Cells, deleting, applying formula and auto filters as well to create a chart from the filtered information.

Watch the quick video tutorial below as our Certified Professional Trainer, Les Allen, teaches you how all this is done.

Excel Shortcut Cheatsheet Download

Documented below is a quick reference of all the tasks and associated keyboard shortcuts used in this Excel tip and trick:

- Copy entire sheet

- Ctrl + ‘A’

 - Create new sheet

- Shift F11

 - Paste all values

- Ctrl + ‘V’

 - Paste special … column widths

- Alt key on keyboard

- Press ‘S’ for Paste Special

- Press ‘W’ for Column Widths

 - Delete the Date column (D:D)

- Navigate to cell in D

- Ctrl + ‘Space Bar’

- Ctrl + ‘-’

 - Change the Product Sales column to not show decimal points

- Navigate to column B

- Ctrl + 1

- Tab to Number

- Tab to 0

- Enter for ‘Ok’

 - Select all blank cells in column G

- Navigate to G1

- Ctrl + ‘Space Bar’

- Press ‘Ctrl + G’

- Press Tab twice to go to ‘Special…’ button, press Enter

- Press ‘K’ for blanks

- Ctrl + ’1′

 - Fill each cell with the following formula

- =sum(Hx/Gx)

- Ctrl + Enter to fill all cells with the formula

 - Delete Product Name column

- Navigate to column B

- Ctrl + ‘Space Bar’

- Ctrl + ‘-’

 - Apply Auto Filter

- Alt + ‘A’ + ‘T’

 - Filter Category Name On Beverages

- Navigate to B2

- right click button

- Press ‘E’ for Filter…

- Press ‘V’ for Filter on Cell Value

 - Filter Branch on West Coast

- Navigate to cell C2

- Navigate to B2

- right clickbutton

- Press ‘E’ for Filter…

- Press ‘V’ for Filter on Cell Value

 - Create a bar chart

- Press F11

You can get a handy reference guide of all these shortcuts and more by downloading our Free Excel Shortcut Cheat Sheet.

Leave a Reply