Filtering a List
To filter a list means to hide all the rows except those that meet specified criteria. Excel provides two filtering commands—AutoFilter, for simple criteria, and Advanced Filter, for more complex criteria. You also can use the Advanced Filter command to extract a subset of your list to another part of your workbook.
Using the AutoFilter Command
To use the AutoFilter command, first select any cell in your list. Then choose Data, Filter, AutoFilter. Excel displays drop-down arrows next to each of the column headings in your list. Clicking the arrow next to any heading reveals a list of the column's unique values, which you can use to specify filtering criteria.
Display arrows for selected columns
In the typical situation, you want to ...