How do I reverse the worksheet exactly the way it is?

B

bnuphar

Ok so I want to reverse the worksheet in the exact order that it's already
in. Meaning I want the bottom row to become the top row and then the 2nd to
bottom row to become the 2nd row from the top. The first row is in date form
but for some reason it won't sort like that, it gets all mixed up.
There are 9 rows labeled:

Date, Type, To/From, Name/Email, Status, Gross, Fee, Net Amount, Balance

April 30, 2006, Payment, From, Cust. John Smith, Completed, $460.00 USD,
-$13.64 USD, $446.36 USD, $1,197.24 USD

it keeps going all the way to April 1, 2006 as the last row.

So how do I just flip this so April 1, 2006 is at the top and April 30, 2006
is at the bottom? I hope this makes sense. :)
 
D

DBex

Easy. Highlight all of the information (incl the headings) and sort the Date
column in Ascending order (Data, Sort, Sort By [Date]).
 

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

How do I create reverse italic fonts? 7
How do I reverse the row order in Excel, not based on content? 2
How do I reverse tabs and worksheet from reading right to left? 1
How do I create a graph from a worksheet? 2
Q: how to create summary daily lists from another, and reverse 2
how do i flip a column round in excel? 5
How do I reduce number of Rows displayed in Excel worksheet? 1
Entering Data: is there a way to do this? 4

Top