O'Reilly logo

Picture Yourself Learning Microsoft® Excel® 2010 by Laurie Ulrich Fuller, Deidre Hayes, Jeffery A. Riley

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

Creating an AutoFilter

THE EASIEST WAY TO FILTER your data is to use the AutoFilter feature in Excel. To create an AutoFilter, click anywhere in your worksheet table and choose Data > Sort & Filter > Filter. Excel recognizes that all of the adjacent cells are part of your table and applies a filter arrow to the top cell in each column, as seen in Figure 8-1.

Figure 8-1. The AutoFilter feature applies a filter arrow to each column in your worksheet’s table.

Caution

The AutoFilter feature does not work on protected worksheets. ...

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