Wednesday, December 14, 2011

How to Sort Data in Excel 2003


1. Open the Excel 2003 file that contains the information you need to sort.
2. Click and hold on the top left cell in the data that you want to sort. Drag the mouse to the bottom right cell and release the button. Your selected data will now be highlighted in a different color.
3. Click 'Data' on the right side of the toolbar on the top of the window. Choose 'Sort' from the drop-down menu to open the 'Sort' window.
4. Click the drop-down arrow next to 'Sort By' and select the column that you want to sort by. You can also choose to sort the data further by selecting additional columns in the 'Then By' fields. Next to each column selection, you can choose to select 'Ascending' or 'Descending' depending on how you want to sort the data. If your columns do not have a header row, select 'No header row' at the bottom of the window.
5. Click 'OK' to close the window, and Excel 2003 will sort your data.

Blogger news