98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » excel consultant - Organising information in date order
excel consultant - Organising information in date order
Resolved · Low Priority · Version Standard
Krystle has attended:
Excel Advanced course
Word Advanced course
Organising information in date order
How do you select and organise information into ascending date order?
RE: Organising information in date order
Hi Krystle
Thank you for your question.
You would first need to ensure that:
1. All your dates were in one column
2. The column containing the dates had a heading at the top (e.g. Date) which has been bolded.
3. All dates are in the same format.
4. There are no blank rows within the list of dates.
Then you can select any of the cells that contain a date, then click the Sort Ascending button on the standard toolbar (button with A and Z on it).
Amanda
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Using basic functions without doing formulasWhen you highlight figures Autocalc tells you the total in the bottom right of the screen, but if you right click on the sum it will give you some basic functions. The functions are Min, Max, Average, Sum, Count, and Count Nums. |