locking data/cells so re-sorting a column doesn't re-position my d

M

mtn_leisure

I need to re-sort a column, but I want all the row's data associated with
that row to stay with the SORT results.
 
P

Paul Sheppard

mtn_leisure said:
I need to re-sort a column, but I want all the row's data associated
with
that row to stay with the SORT results.
Click to expand...

Try selecting the data in the other columns aswell and then sort the
data should then stay together

Paul
 
P

Paul Sheppard

Once you've selected all the data, click Data > Sort and then sort by
whichever column, checking the box as required or not for a header row

Paul
 
Top