lock rows on sort

[Kenneth C. Benson]

I'm working on a large table (about 2000 rows, 50 columns). I frequently
have to sort the entire table based on one column, and I keep forgetting
and sort just the column, disassociating the rest of the data from that
column.

Is there a way to lock rows so that I can't make this mistake, so that
whenever I sort a column it sorts the whole table based on that column?

Ken Benson

 

[Bob I]

Use Access instead?

 

[RagDyer]

Assign a short name to the entire datalist, like say "lst",
and then just click on that name in the name box before you start any sort.

 

[TedMi]

To ensure that the name remains valid as the list grows, read up on how to
organize the list - look up "list" in Excel's Help index.
-TedMi

 

[Shane Devenshire]

Hi,

Maybe the easiest solution is not to select the column but to select a
single cell in the column you want to sort on. This works if
1. you have no data touching the data range that you don't want to sort
2. there are no completely blank rows within the data
3. there are no completely blank columns within the data.

The general rule is either select all the data or just a single cell,
anything else is bad news.

If this helps, please click the Yes button

Cheers,
Shane Devenshire

 

[Kenneth C. Benson]

If this helps, please click the Yes button

I'm here through NNTP, so no buttons, but, Yes, this helps.

Thanks,
Ken

 

[Kenneth C. Benson]

Thanks, the list idea is very helpful as well.

Ken

 

[SmartbizAustralia]

If the header rows are on the first, then always select the columns
then let the sort let you choose the column.

Otherwise, record the sorting as a macro....making sure you always
include all the rows...e.g. the last rows in case you add more..

Regards,
Tom Bizannes
Excel Development
Sydney,Australia
http://www.macroview.com.au

 

[Gord]

The pictures will sort with the appropriate rows if.....IF.......they
lie entirely within the confines or the cell boundaries.


Gord Dibben Microsoft Excel MVP