Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / April 2008

Tip: Looking for answers? Try searching our database.

Selecting a large range of cells?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
FISH - 10 Apr 2008 20:13 GMT
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.
Max - 10 Apr 2008 20:28 GMT
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.

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.