Use Sorting and Filtering in MS Excel
New options for sorting and filtering make Microsoft Office Excel 2007 the ideal tool for working with large amounts of complex data. The sorting and filtering menu is sensitive to the type of data you’re working with. To sort and filter:
1. To enable filter and sort options, do one of the following:
a. Format your data range as a table.
b. Select the headings of the columns that you want to sort or filter.
c. On the Ribbon, on the Home tab, in the Editing group, click Sort and Filter.
2. To sort, click the AutoFilter arrow in the column heading, and then select the filter mode (in Office Excel 2007, you can also filter by cell color).
3. To filter, click the AutoFilter arrow in the column heading.
a. Select individual values, and then select the filter mode.
b. Select Number Filters, Text Filters, or Date Filters for more advanced filter options.