Select the complete range that should sort--all the columns that you need.

Then use data|sort.

I've always found it better to select my range than to let excel guess at what
should be sorted/filtered/graphed/pivottabled/etc.

famdamly wrote:

When I sort data in a column the relative data in the rows adjacent
remains in place. What can I do ?

--
famdamly
------------------------------------------------------------------------
famdamly's Profile: http://www.excelforum.com/member.php...o&userid=29382
View this thread: http://www.excelforum.com/showthread...hreadid=516706

--

Dave Peterson