Speed Up When Navigating and Highlighting in Excel

 In Uncategorized

Navigating Highlighting in Excel

Navigating Highlighting in Excel

Play Game Now
Navigating Highlighting in Excel

In our time of enormous speeds and a multitude of events, the time spent on solving the tasks is extremely important.
Even such simple actions like moving to the necessary cell or highlighting a row occupy an essential part of the work when added up.
According to statistics, time spent on performing elementary activities in Excel can reach 50% of the total time spent on solving a particular task. At the very inexperienced this share can exceed 90%.

In this article, we’ll talk how to increase the speed of work in Excel in a few (a few!) times. The secret is … In using Excel shortcuts and hot keys. These simple shortcuts will save you tons of time in Excel, starting from seconds and adding up to days!

1. Navigating in Excel with one click

“Ctrl + arrow” will bring you to the end of contiguous range, and “Ctrl + Home” will always bring you to the cell A1.

 

Excel shortcuts Ctrl + arrow, Ctrl + Home

 

“Go To” widow (“F5” hot key) will bring you to ANY cell you wish in the spreadsheet.

 

Excel shortcuts F5

2. Highlighting in Excel with one click

“Shift+ arrow” will highlight the cells for you, “Ctrl + Shift + Arrow” will highlight contiguous ranges.

 

Excel shortcuts Shift+ arrow

 

“Ctrl + A” will highlight the whole table / contiguous range.

 

Excel shortcuts Ctrl + A

 

And last, but not least, “Ctrl + Spacebar” will highlight the whole column and “Shift + Spacebar” will highlight the whole row.

 

Excel shortcuts Ctrl + Spacebar

 

These are easy and “mega hot keys” that allow you to save tons of time.

We strongly recommend that you practice all the hot keys described above. The main thing is to constantly practice until it comes to automation. Let’s save the most valuable resource – time.

Many more shortcuts and other Excel tips and tricks in our Game.

Play Game Now

Recent Posts

Leave a Comment

How can we
help you?
Contact Us

Please, leave a message and we'll get back to you asap

0

Try Free Version of the Game