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 ...

Get Microsoft® Office Excel 2003 Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.