sorting question

P

petevang

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

Ron Coderre

First....Select all of your data

THEN....Data>Sort..

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


Does that help?

Regards,
Ro
 
P

Peo Sjoblom

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)
 
B

B. R.Ramachandran

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
 
Top