Easy / Quick way to select 2 columns, 100's of rows?

D

DavidJ726

What's the easist way to select all the data in two columns, with up to 1500
rows, without having to click, hold & drag? I guess I could record the
action as a macro that would cover the extreme range, but I'm looking for
something a little more defined.

Thanks,
David
 
R

Ron Coderre

Try this:

Select any cell in the range
[Ctrl]* ......That's Control + the asterisk over the 9 on the numeric
keypad

That will select the range the includes the selected cell.

To fine tune that range....
[Ctrl]. .....That's Control + Period

Each time you use that, the active cell moves to a different corner of the
selected range.

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP
 
P

Paul B

David, data in A & B select A1 & B1 then ctrl+shift+down arrow
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
P

Paul B

your welcome, thanks for the feedback
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
Top