How to Sort Information in Excel 2007

1. Access a worksheet with data that can be sorted. Open Excel 2007 and either open an existing worksheet or add information into an empty worksheet. Data should be in a table, preferably with assigned column headers to make selecting the sorting criteria easier. Make sure that all of the data in a given column is of the same format so that it is sorted consistently.
2. Choose the data to be sorted. Left-click and drag to select the data. Ensure that both the data and the headers are included.
3. Open the sort dialog. Select 'Data' on the Excel 2007 ribbon, and then click on the 'Sort' icon.
4. Configure the sort options and apply the sort. If you have created column headers, make sure 'My data has headers' is selected. Select the column to sort by in the 'Sort by' drop-down list. Select how to sort the data by selecting from the drop down list, typically by the cell values. You can also sort by cell color, font color or cell icon. Select whether to sort in ascending or descending order by selecting from the 'Order' drop down list. To sort on more than one column, choose 'Add Level' and repeat these selections. To make the sort case sensitive or to sort from bottom to top instead of top to bottom, select 'Options' and choose accordingly. Click 'OK.'