• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Lesson 26. Finding and Sorting Data in a... > Narrowing Your List with AutoFilter

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 use the arrow keys to scroll through the list, or you can type the first character in the entry's name to quickly move to it. Press Enteror click the entry. Excel filters the list so that only the records for people living in Boston appear.

    Figure 26.3. AutoFilter lets you narrow your list.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint