Pinterest Pixel

Top 3 Excel Keyboard Tips

Bryan
There are a lot of hidden keyboard tricks to increase your efficiency in Excel.
I am surprised myself with these hidden gems!
Top 3 Excel Keyboard Tips | MyExcelOnline Top 3 Excel Keyboard Tips | MyExcelOnline

Here are Top 3 Excel Keyboard Tips for Excel Power Users like you!

You will have a fun time increasing your productivity with these tricks!

 

Top 3 Excel Keyboard Tips | MyExcelOnline

download excel workbook Keyboard-Tips.xlsx

 

Display Formulas With a Single Keypress

[CTRL + `]

 

I used to have workbooks full of formulas and the only way for me to check each formula was by clicking on each cell, one cell at a time…pfff!

Thankfully, here’s a quick tip that will speed up this process by using a keyboard shortcut to display all of the formulas!

Let us use an existing workbook with formula results to demonstrate this.  Our workbook has a column that uses the Replace formula.

Now, what if we want to check the correctness of each formula?

display-formulas-00

If we click on a cell, then we can see the Replace formula and its arguments.  This is the slow way…

display-formulas-01

 

STEP 1: To display all of the formulas, press on your keyboard:

CTRL + `

The grave accent key ` is usually located on the top left of the keyboard beside the number 1 key.

display-formulas-02

You are now able to view all of the formulas, with just a single keypress!

 

STEP 2: To display the results of the formulas instead, press on your keyboard CTRL + ` again:

display-formulas-03

 

 

POWER TRICK #2:

Changing Enter Key Behavior in Excel

[ENTER]

 

Data Entry in Excel is a tedious process if Excel does not play its part. The great thing with Excel is it is very customizable. One of the common scenarios is when I want Excel to move in a different direction when I press the ENTER key.

The normal behavior for the ENTER key is to move downwards.

However in our scenario, I’m trying to list down the exam scores for each student, so it would make sense every time I press the ENTER key, we would move from left to right:

changing-enter-key-behaviour-01

 

STEP 1: Go to File.

changing-enter-key-behaviour-02

 

STEP 2: Go to Options.

changing-enter-key-behaviour-03

 

STEP 3: Go to Advanced > After pressing Enter, move selection > Direction: Right.

This will change our ENTER direction from Up to Down, into Left to Right.

changing-enter-key-behaviour-04

 

STEP 4: Try it out! Enter a couple of scores and press ENTER. It will now move to the right, now data entry just got a lot more fun!

changing-enter-key-behaviour-05

 

 

POWER TRICK #3:

Move Over Multiple Worksheets Using Shortcut Keys

[CTRL + PAGE UP / PAGE DOWN]

 

There are a lot of times when I had workbooks with a lot of worksheets inside. Whenever I had to check each sheet one by one, it was a tedious process as I had no choice but to click the sheets one by one!

Thankfully, here’s a quick tip that will speed up by using a keyboard shortcut to move over multiple worksheets!

Let us use an existing workbook with multiple worksheets to demonstrate this.

Our workbook has multiple sheets inside:

move-over-multiple-worksheets-01

The steps are very straightforward, which are outlined below:

 

STEP 1: To move to the right, press on your keyboard CTRL + PAGE DOWN:

move-over-multiple-worksheets-02

 

STEP 2: To move to the left, press on your keyboard CTRL + PAGE UP:

move-over-multiple-worksheets-03

 

If you like this Excel tip, please share it
Top 3 Excel Keyboard Tips | MyExcelOnline
Bryan

Bryan Hong is an IT Software Developer for more than 10 years and has the following certifications: Microsoft Certified Professional Developer (MCPD): Web Developer, Microsoft Certified Technology Specialist (MCTS): Windows Applications, Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Systems Administrator (MCSA).

He is also an Amazon #1 bestselling author of 4 Microsoft Excel books and a teacher of Microsoft Excel & Office at the MyExecelOnline Academy Online Course.

See also  $ Dollar Sign in Excel: Absolute, Relative, and Mixed Cell References

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...