How to go End of Huge Data Range?

C

crwiseman

This may seem basic, but I have never figured this out. How do you
select to the end of a huge data range without holding the mouse
left-click forever? There must be a way using Control or ? to
automatically extend selection to the end. Thanks
 
B

Bernard Liengme

With cursor in top left corner of dataset use SHIFT+END+DOWN+RIGHT
If you have XL 2003: with cursor anywhere within dataset use CTR+A
best wishes
 
C

CLR

When dealing with large databases I usually FREEZE the top few lines to give
me a working area that is always on the screen no matter where I scroll the
database to. In that area, I usually install UP and DOWN buttons that will
take the cursor immediately to the Top or Bottom of the database by running
an associated macro.......they are a LOT of help.

hth
Vaya con Dios,
Chuck, CABGx3
 
Top