how to re-arrange the dates in a assending order

  • Thread starter Thread starter Pius
  • Start date Start date
Ascending order means the oldest date is first, the most recent last.
Click any cell in the date field, click the Sort Ascending butto
or
Data menu, Sort, Select the field to sort by, click OK.
 
Highlight the dates, together with any other columns of data that you
want to keep on the same row as the date, then click on Data | Sort -
you will be presented with a variety of options, including sort order
for up to three key fields. Ensure that you check the appropriate
Header Row or No Header, then click OK.

Hope this helps.

Pete
 

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

assending order? 1
How to I place a range of cells in assending order? 1
How do you sort 2 date fields in assending order (query or report) 1
sorting by date on a formatted date field 3
Sorting Dates 1
How to make a Let statement in Excel? 2
How do I get a worksheet reference to increment when copied 9
Desperate for help on assending/decending macros 3

Back
Top