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

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

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


"DavidJ726" wrote:

> 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
>
>
>

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

"DavidJ726" <[email protected]> wrote in message
news:[email protected]...
> 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
>

Thanks guys,

Pauls answer was what I was looking for.


"DavidJ726" <[email protected]> wrote in message
news:[email protected]...
> 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
>

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

"DavidJ726" <[email protected]> wrote in message
news:[email protected]...
> Thanks guys,
>
> Pauls answer was what I was looking for.
>
>
> "DavidJ726" <[email protected]> wrote in message
> news:[email protected]...
>> 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
>>
>
>