Ten Minute Guide to Excel 97

Narrowing Your List with AutoFilter

AutoFilter allows you to easily display only a select group of records in your database. For example, you can display the records for only those people who live in Boston. Here's how you use AutoFilter:

1. Click a cell in the database.

2. Open the Datamenu, select Filter, and select AutoFilter. Excel displays drop-down list arrow buttons inside each of the heading cells.

3. Click the drop-down arrow for the field you want to use to filter the list. For example, if you want to display records for those people living in Boston, click the City cell's drop-down arrow. A drop-down list appears, as shown in Figure 26.3. This list shows all the entries in the column.

4. Select the entry you want to use to narrow your list. You can ...