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

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.
--
mtn_leisure

mtn_leisure Wrote:
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.
--
mtn_leisure

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

Paul


--
Paul Sheppard
------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=396529

Yeah, but if I select all cells how will I tell it which column to SORT by?
--
mtn_leisure


"Paul Sheppard" wrote:


mtn_leisure Wrote:
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.
--
mtn_leisure

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

Paul


--
Paul Sheppard
------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=396529

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


--
Paul Sheppard
------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=396529