software

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: www.excelforum.com/member.php...oamp;userid=25034
View this thread: www.excelforum.com/showthread...hreadid=496207
First....Select all of your data

THEN....Datagt;Sort..

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: www.excelforum.com/member.php...oamp;userid=21419
View this thread: www.excelforum.com/showthread...hreadid=496207Can 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)quot;petevangquot; gt; wrote in
message news
gt;
gt; I have 10 columns of data that I would like to sort together. Currently
gt; when I sort excel only sorts the column I have selected, and the data
gt; doesn't line up. Can you help me?
gt;
gt;
gt; --
gt; petevang
gt; ------------------------------------------------------------------------
gt; petevang's Profile:
gt; www.excelforum.com/member.php...oamp;userid=25034
gt; View this thread: www.excelforum.com/showthread...hreadid=496207
gt;Hi,

Select all the 10 columns --gt; quot;Dataquot; --gt; quot;Sortquot; --gt; for quot;Sort byquot; in the
pop-up window, select the column by which you want to sort --gt; quot;OKquot;

Regards,
B. R. Ramachandran

quot;petevangquot; wrote:

gt;
gt; I have 10 columns of data that I would like to sort together. Currently
gt; when I sort excel only sorts the column I have selected, and the data
gt; doesn't line up. Can you help me?
gt;
gt;
gt; --
gt; petevang
gt; ------------------------------------------------------------------------
gt; petevang's Profile: www.excelforum.com/member.php...oamp;userid=25034
gt; View this thread: www.excelforum.com/showthread...hreadid=496207
gt;
gt;


Thanks for all of your help. It worked.--
petevang
------------------------------------------------------------------------
petevang's Profile: www.excelforum.com/member.php...oamp;userid=25034
View this thread: www.excelforum.com/showthread...hreadid=496207