Master the Art of Double Clicking for Moving Faster in Your Spreadsheet.

Posted on February 26, 2008 
Filed Under Excel Tips & Tricks

New to the World of Office, XP and Vista Tips & Tricks?

  Here are a few posts the other readers recommend you check out.


I showed you yesterday a cool MS Excel Trick for Hiding and Unhiding a Row or Column and I thought that it would be cool to continue with another cool MS Excel Tip. Not many people use this Trick but there is a way for navigating really fast within your Excel spreadsheet.

 

Start Clicking and Stop scrolling with this Microsoft Excel Tip and Trick.

 

The numbers that I’m using are just random numbers. I made this example but this Excel Trick really comes in place if your spreadsheet is bigger than this.

 

Excel-tip-trick-pic1

 

 

 

If you want to go cell P1 you need to click on the right edge of cell A1.

 

Excel-tip-trick-pic2

 

 

 

If you want to go cell A24 you need to click on the bottom edge of cell A1.

 

Excel-tip-trick-pic3

 

 

 

If there are any blank cell the first cell before the empty cell will be selected.

 

Excel-tip-trick-pic4

 

 

 

If you hold the SHIFT key when you are double clicking the whole range before the empty cell will be selected.

 

Excel-tip-trick-pic5

 

 

I hope you all liked this Cool Excel Tip and Trick and I’ll talk to you all tomorrow. See you!!


Invite your friends to the World of Office.
Did you ever thought about publishing your own eBook or PDF report?
Invite your friends to the World of Office.
Grab the Easy PDF Toolkit, it was never this easy! If you invite your friends and we will receive at least 3 visitors then you will receive a free copy of this amazing kit and that is including all the cool bonuses. Invite your Friends here!


If you liked this article or you thought it was helpful then you would do us a real big favour by hitting one of the below icons. Thank you!! That’s really cool and we really appreciate your support.





Comments

Leave a Reply