Wednesday, December 26, 2012

How to Sort Information by Date in Excel 2003


1. Open Excel 2003 by double-clicking the icon. Click 'File,' then 'Open' and select the spreadsheet you want to work with.
2. Click on the top left cell of the data you want to sort. Hold down the mouse button, and drag the cursor to the bottom right box, highlighting all of the data.
3. Click the 'Data' button, then select 'Sort' from the drop-down menu that appears.
4. Click the small arrow by the 'Sort By,' and select the column that holds all of the dates. Choose 'Ascending' if you want older dates to appear first or 'Descending' if you want the newest dates to appear first. Click 'OK,' and Excel will sort the information provided by date.

Blogger news