Flipping a worksheets contents?

[niceguy]

So if I have a Worksheet with the Cloumn like this... A1, A2, A3, A4, A5
and I want to flip it to show in this order... A5, A4, A3, A2, A1
How would I do that? Thanks!

 

[Mike]

flip your monitor over.

 

[MartinW]

Hi Niceguy,

Select your data A1:A5
Go to Data>Sort
Click on Options Button
Check Sort left to right
Click OK
Check descending
Click OK

HTH
Martin

 

[niceguy]

That was the first thing I tried! But I had a hard time reading the screen,
so I thought there had to be a better way! =)

 

[Gord Dibben]

In a helper column

=INDEX($A$1:$A$5,5-(ROW(A1)-1))

Copy down


Gord Dibben MS Excel MVP