Displaying Parts of a List with AutoFilter

Working with a list that contains numerous records can be difficult ”unless you can narrow your view of the list when necessary. 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. You select the items that you want to display in the column (that is, the records that meet certain criteria). Then you can work with a limited number of records.

Display Specific Records Using AutoFilter

Click anywhere within the list range.

Click the Data menu, point to Filter, and then click AutoFilter.

Click the list arrow of the field for which you want to specify search criteria.

Select the item that records must match in order to be included in the list.

Repeat steps 3 and 4, as necessary, to filter out more records using additional fields.

Click the Data menu, point to Filter, and then click AutoFilter to turn off AutoFilter and redisplay all records in the list.

Did You Know?

You can speed up your work with the Top 10 list . AutoFilter offers a Top 10 command in the list of every field. Click this command to quickly create a filter for the top or bottom 10 items in a list.