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

Originally Posted by 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.
--
mtn_leisure

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

Paul

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