Microsoft® Excel® 2010 Inside Out

Filtering a List or Table

Filtering a list or table means hiding all the rows except those that meet specified criteria. Excel provides two filtering methods: Simple, which uses lists on the header row, and Advanced, which uses a separate criteria range. The Advanced method can filter in place or extract a subset to another part of the worksheet. You can use both methods with tables and also with standard lists—as long as the lists have header rows.

Using Filters

When you create a table, Excel adds filters to the header row automatically. To turn header row filters on or off, first select any cell in your table, and then click the Filter button in the Sort & Filter group on the Data tab. When you turn on the filter, Excel displays small arrows next ...