Sorting lists
 

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

Sorting lists
 

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

Sorting lists
 

Ahhhh, that makes perfect sense. duh

Thanks Dave.


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