How to go End of Huge Data Range?

[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

 

[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

 

[Guest]

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