UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Jumping to the end points on a Worksheet    
 
   
JEdgar
post Oct 27 2003, 07:15 PM
Post #1

UtterAccess Veteran
Posts: 358
From: Australia



By holding down the Control key on your keyboard and hitting the arrow keys you can jump to the extreme points of each worksheet.

For example hold down Ctrl and the down arrow will take you (in a blank Excel 2002 worksheet) to A:65536
While still holding down the Ctrl key and hitting the right arrow you will be taken to cell IV:65536
Ctrl up arrow will then take you to cell IV:1
And Ctrl left arrow will take you back to cell A:1

So there you go you have just done a quick trip around the four corners of your worksheet! YAY

Jon
Go to the top of the page
 
+
TonyZaradich
post Nov 13 2003, 09:28 AM
Post #2

UtterAccess Addict
Posts: 129



Here are another one in the same context:

To go to the end of a column or row: Press 'End' key followed by the direction you want to go on the sheet and you'll go to the end of a continuous column or row with info (it goes to the first blank cell it finds)

If you trap the above during the recording of a macro, it works great in a number of different applications.
Go to the top of the page
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Go to Top  ·  Lo-Fi Version Time is now: 24th May 2013 - 01:16 PM