|Filtering is a quick and easy way to find and work with data in an Excel list. A filtered list displays only the rows in a column that meet the criteria you specify. Filtering can temporarily hide the rows you do not want displayed. When Excel filters rows, you can edit, format, chart, and print your list without rearranging or moving it.
1. Open an Excel document. Click in any cell that contains data.
2. From the menu bar, click Data -- Filter -- AutoFilter.
Choosing Advanced Filter will allow you to select data by using more complex criteria.
3. AutoFilter arrows will appear to the right of the column labels. Click the arrows to see the dropdown menu of available options.
4. Click Sort Ascending or Sort Descending in the dropdown menu to sort the data in the column.
5. The bottom of the dropdown menu lists all of the unique, visible items in the column. Clicking on one of those items will instantly hide all rows that don't contain that selected value. Click Show All in the dropdown menu to return the rows that were hidden.
6. Click Custom AutoFilter in the dropdown menu for more selection criteria options.
7. To turn off AutoFilter, from the menu bar click Data -- Filter -- AutoFilter.
**for additional information about filtering, search for auto filtering in Excel Help (located in the menu bar).