Reverse Data from bottom to top

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 

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

Excel Excel spreadsheets opening at top instead of bottom. 4
Reverse Pivot-type Data (that's not a pivot table) 2
Sort pivot table field (droplist) by month or original data 1
Generic Worksheet Names 2
Determining a Date 1
week entry 1
How can I calculate current school year from DOB ongoing? 14
Pivot Table - Quarterly report 1

Back
Top