O'Reilly logo

Microsoft® Excel® 2010 Inside Out by Mark Dodge and 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 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 ...

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