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!

There are a lot of hidden keyboard tricks to increase your efficiency in Excel. I am surprised myself with these hidden gems!

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.

See also  The Best Guide to Edit PowerPoint Videos and Clips

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.

See also  The Ultimate Guide to Rotate & Flip PowerPoint Images

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!

See also  How to Delete Blank Cells in Excel

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


Star 30 Days - Full Access Star

One Dollar Trial

$1 Trial for 30 days!

Access for $1

Cancel Anytime

One Dollar Trial
  • Get FULL ACCESS to all our Excel & Office courses, bonuses, and support for just USD $1 today! Enjoy 30 days of learning and expert help.
  • You can CANCEL ANYTIME — no strings attached! Even if it’s on day 29, you won’t be charged again.
  • You'll get to keep all our downloadable Excel E-Books, Workbooks, Templates, and Cheat Sheets - yours to enjoy FOREVER!
  • Practice Workbooks
  • Certificates of Completion
  • 5 Amazing Bonuses
Satisfaction Guaranteed
Accepted paymend methods
Secure checkout

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...