sorting question
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?:eek: -- petevang ------------------------------------------------------------------------ petevang's Profile: http://www.excelforum.com/member.php...o&userid=25034 View this thread: http://www.excelforum.com/showthread...hreadid=496207 |
sorting question
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 |
sorting question
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?:eek: -- petevang ------------------------------------------------------------------------ petevang's Profile: http://www.excelforum.com/member.php...o&userid=25034 View this thread: http://www.excelforum.com/showthread...hreadid=496207 |
sorting question
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?:eek: -- petevang ------------------------------------------------------------------------ petevang's Profile: http://www.excelforum.com/member.php...o&userid=25034 View this thread: http://www.excelforum.com/showthread...hreadid=496207 |
sorting question
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 |
All times are GMT +1. The time now is 10:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com