Reverse Data from bottom to top
 

I want to reverse the whole spreadsheet, e.g. data of July at the bottom (1st
July) has to go to the top and August data (31st August) should be at the
bottom, as against what is in my sheet

Select the data you want to sort and then go to the data menu. Select sort
and it will ask you by which column you would like to sort. Select the one
with the date and select ascending or descending. It should automatically
sort it for you correctly.

"Joman" wrote:

I want to reverse the whole spreadsheet, e.g. data of July at the bottom (1st
July) has to go to the top and August data (31st August) should be at the
bottom, as against what is in my sheet

Hi!

If you have a column of true Excel dates just select the data you want
inverted and sort on the date column ascending.

Biff

"Joman" wrote in message
...
I want to reverse the whole spreadsheet, e.g. data of July at the bottom
(1st
July) has to go to the top and August data (31st August) should be at the
bottom, as against what is in my sheet