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?

First....Select all of your data

THEN....Data>Sort..

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


Does that help?

Regards,
Ron

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" <petevang.20plny_1135704601.5567@excelforum-nospam.com> wrote in
message news:petevang.20plny_1135704601.5567@excelforum-nospam.com...
>
> 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.