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?
Fri 10 Aug 2007, 12:22Trainer Amanda said...
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
