Selecting a large range of cells?

  • Thread starter Thread starter FISH
  • Start date Start date
F

FISH

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
 
Type the range in the namebox*, eg: A1:BB1000
then press ENTER
*the dropdown just to the left of the formula bar>>
Click to expand...

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