Flipping a worksheets contents?

N

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!
 
M

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
 
N

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! =)
 
G

Gord Dibben

In a helper column

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

Copy down


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Return Unique Entries Only 5
Show actual values added instead of cell references? (=A1+A4 showsas =10+2 in cell) 6
Combine text from multiple cells into one cell - =(A1&","&A2","&A3 5
Using two Vlookup in one Cell 1
Help in checking 5 cells for value and display the value in anothercell 3
Creating a formula relating to several cells 2
Adding rows based on no of rows specified from a given position 1
Addition errors with Decimal Places 5

Top