Wednesday, August 15, 2012

How to Sort in Excel 2003


1. Open Excel 2003 and select a workbook containing data that needs to be sorted. Click 'File' on the menu bar and select 'Open.' Browse your computer for the workbook. Click the workbook and select 'Open.' The workbook opens.
2. Highlight the range of data that needs to be sorted. Click the first cell in the range you want to sort by. Click the 'Ascending' button on the Standard toolbar. The data is sorted in ascending order by the values in the column.
3. Highlight the range of data you want to sort. Click 'Data' on the menu bar. Select 'Sort.' The 'Sort' dialog box opens. Select a column header in the 'Sort By' field to sort your data by. Select another field in the 'Then By' field to perform a secondary sort. Click 'OK.' Your data is now sorted by multiple criteria.

Blogger news