Grouping or joining rows

P

pilgrim

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
 
D

Dave F

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
 
M

Mike

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

pilgrim

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

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
 
Top