How to reorder the column in excel?

[deadfish]

If I have a excel table like this:

A C O D D E
1 2 3 4 6 5

And I would like to sort the table like this (sort by first row):

A C D D E O
1 2 4 6 5 3

How to sort the column in this way? Or I have to "reverse" the table first? How?

Thanks!

 

[GlennUK]

Select the required range, do menu command Data/Sort, click the "Options ..." button, and choose "Sort Left To Right". Click OK, click OK.



Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.