Thursday, February 17, 2011

How to Sort by Date on Excel 2010


1. Open the Excel 2010 workbook to the worksheet that contains the data you want to sort.
2. Click the column letter (A, B, C, ...) that holds date values, to highlight that range of cells.
3. Select the 'Data' tab in the Ribbon at the top of Excel. Look for the Sort Filter group.
4. Click the 'AZ' icon to sort dates from earliest to latest (January, February, March). Otherwise, click the 'ZA' icon to sort dates from latest to earliest (March, February, January).

Blogger news