Data in A1:A100.

In cell B1 put 1, B2 put 2 and then fill down. Select A1:B100, sort
descending on Col B

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------

"salwitt" wrote in message
...
I have a column of cells filed with data. I know I can transpose the data
90
degrees, but is there a way to cut or copy the data in the cells and paste
it
so the values are in the opposite order, i.e. a 180 degree difference?
Thanks to anyone who can help.

I am using Excel 2003.