Reversing the order in an Excel column 1

[Trackfiend]

I am trying to reverse the order of a data set in a column (1,2,3,4...) to (4,3,2,1..), without having to copy and paste each one individually. Is there anyway that I can highlight the entire data set and reverse the order with a command in Excel?

 

[melone]

Sort -> Descending

 

[Trackfiend]

Thanks, I just figured it out.

 

[melone]

Well.... How did you do it?

 

[Trackfiend]

I did just what you said. For some reason, the first time I tried the command, it only reversed one column at a time. But after reading your post and highlighting all the columns needed for reversing, it worked. Thanks for the help.