Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel consultant - Organising information in date order
|
|
|
The UK's most regular 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 consultant - Organising information in date order
Resolved · Low Priority · Version Standard
Reply Fri 10 Aug 2007, 11:39Delegate Krystle said...
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?
For upcoming training course dates see: Pricing & availability
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
|