My Assistant
![]() ![]() |
|
|
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 |
|
|
|
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 Top · Lo-Fi Version | Time is now: 24th May 2013 - 01:16 PM |