![]() |
How do I reverse the worksheet exactly the way it is?
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. :) |
How do I reverse the worksheet exactly the way it is?
Easy. Highlight all of the information (incl the headings) and sort the Date
column in Ascending order (Data, Sort, Sort By [Date]). "bnuphar" wrote: 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. :) |
All times are GMT +1. The time now is 03:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com