Excel® 2013 On Demand

Displaying Parts of a Table with AutoFilter

Working with a list that contains numerous records can be difficult—unless you can narrow your view of the list. For example, rather than looking through an entire inventory list, you might want to see records that come from one distributor. The AutoFilter feature creates a list of the items found in each field, which is useful in tables and PivotTables. You select the items that you want to display in the column field by using the column header list arrow and AutoFilter menu. The column headers in a table now remain visible in long lists for ease of use. In the AutoFilter menu, you can use the Search box to quickly find what you want in a long list. Then you can work with the filtered list.

Display ...