Grouping or joining rows

[Guest]

Hi All, I have a worksheet that has several columns, one with dates.
I would like to sort the rows by that date column. When I click the column
and sort it sorts only that column. I would like all rows to stay associated
with there original rows (more like a database would) Any help please.
Thanks, ED

 

[Guest]

Before you sort, select the entire table. Then try the sort again. Note
that Excel has problems sort non-contiguous columns (i.e., columns that are
not directly next to each other.)

Dave

 

[Guest]

select all the columns and then sort on the date column and the association
will be retained

 

[Guest]

Is there a way to lock the columns together so someone else does not missort
the worksheet?

 

[Pete_UK]

Probably easier to remove the sort icons from the toolbar - that way
the user will have to use Data | Sort where there is a bit more
intelligence programmed in.

Hope this helps.

Pete