How to go End of Huge Data Range?
 

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


--
crwiseman
------------------------------------------------------------------------
crwiseman's Profile: http://www.excelforum.com/member.php...o&userid=32758
View this thread: http://www.excelforum.com/showthread...hreadid=556996

How to go End of Huge Data Range?
 

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"crwiseman" wrote
in message ...

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


--
crwiseman
------------------------------------------------------------------------
crwiseman's Profile:
http://www.excelforum.com/member.php...o&userid=32758
View this thread: http://www.excelforum.com/showthread...hreadid=556996

How to go End of Huge Data Range?
 

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






"crwiseman" wrote:


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


--
crwiseman
------------------------------------------------------------------------
crwiseman's Profile: http://www.excelforum.com/member.php...o&userid=32758
View this thread: http://www.excelforum.com/showthread...hreadid=556996