I have 10 columns of data that I would like to sort together. Currently
when I sort excel only sorts the column I have selected, and the data
doesn't line up. Can you help me?


--
petevang
------------------------------------------------------------------------
petevang's Profile: http://www.excelforum.com/member.php...o&userid=25034
View this thread: http://www.excelforum.com/showthread...hreadid=496207

First....Select all of your data

THEN....DataSort..

That way all of the other columns' data will move with the sort
column.


Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=496207

Can you select all 10 columns before you sort or are they not
contiguous? Sorting demands a single range so if they are not together you
can select each column using ctrl and mouse, then copy and paste somewhere
else, then sort


--
Regards,

Peo Sjoblom

(No private emails please)


"petevang" wrote in
message ...

I have 10 columns of data that I would like to sort together. Currently
when I sort excel only sorts the column I have selected, and the data
doesn't line up. Can you help me?


--
petevang
------------------------------------------------------------------------
petevang's Profile:
http://www.excelforum.com/member.php...o&userid=25034
View this thread: http://www.excelforum.com/showthread...hreadid=496207

Hi,

Select all the 10 columns -- "Data" -- "Sort" -- for "Sort by" in the
pop-up window, select the column by which you want to sort -- "OK"

Regards,
B. R. Ramachandran

"petevang" wrote:


I have 10 columns of data that I would like to sort together. Currently
when I sort excel only sorts the column I have selected, and the data
doesn't line up. Can you help me?


--
petevang
------------------------------------------------------------------------
petevang's Profile: http://www.excelforum.com/member.php...o&userid=25034
View this thread: http://www.excelforum.com/showthread...hreadid=496207

Thanks for all of your help. It worked.


--
petevang
------------------------------------------------------------------------
petevang's Profile: http://www.excelforum.com/member.php...o&userid=25034
View this thread: http://www.excelforum.com/showthread...hreadid=496207