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

Welcome to UtterAccess! Please ( Login   or   Register )

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



Posts: 358
Joined: 23-September 02
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



Posts: 129
Joined: 12-September 00



Here are another one in the same context:
o 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
 


Custom Search
RSSSearch   Top   Lo-Fi    11th December 2017 - 05:48 PM