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!

 

DOWNLOAD EXCEL WORKBOOK

 

POWER TRICK #1:

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

display-formulas

 

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

changing-enter-key-behaviour

 

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

move-over-multiple-worksheets

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Top 10 Excel Double Click Mouse Tricks There are a lot of times when the mouse beats the keyboard in terms of efficiency in Excel. Here are Top 10 Excel Double Click Mouse Tricks for Excel Power Users like you! You will have a fun time increasing your productivity with these tricks! DOWNLOAD EXCEL WORKBOOK ...