O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required