I'm not too strong with Excel so this might be an easy question.
I have a large workbook with about 50K rows and about 100 columns. I need to
sort this large range of data by different columns from time to time. I know
how to sort it by just holding down the left mouse button and dragging the
highlighted area to include the range. Then I go to "data" / "Sort". This
just takes way too long to do each time for a range this size.
I hope there is a better way to include this large range without having to
"grab" it all manually.
Is there?
THANKS.
Type the range in the namebox*, eg: A1:BB1000
then press ENTER
*the dropdown just to the left of the formula bar

Signature
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
> I'm not too strong with Excel so this might be an easy question.
>
[quoted text clipped - 11 lines]
>
> THANKS.
FISH - 10 Apr 2008 20:42 GMT
Great, that helps a lot. THANKS.
> Type the range in the namebox*, eg: A1:BB1000
> then press ENTER
[quoted text clipped - 14 lines]
>>
>> THANKS.
Max - 10 Apr 2008 21:08 GMT
Welcome

Signature
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
> Great, that helps a lot. THANKS.
Chris J Dixon - 11 Apr 2008 07:39 GMT
>> I have a large workbook with about 50K rows and about 100 columns. I need
>> to sort this large range of data by different columns from time to time. I
[quoted text clipped - 5 lines]
>> I hope there is a better way to include this large range without having to
>> "grab" it all manually.
>Type the range in the namebox*, eg: A1:BB1000
>then press ENTER
>*the dropdown just to the left of the formula bar>>
Even simpler - select any cell in the range, and use Data/ Sort.
It applies to the whole range, so long as there are no completely
blank rows.
Chris

Signature
Chris J Dixon Nottingham UK
chris@cdixon.me.uk
Have dancing shoes, will ceilidh.