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

Lesson 29. 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 any cell in the database.

  2. Open the Data menu, select Filter, and then 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 29.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 Enter or click the entry. For example, if you choose Boston, Excel filters the list so that only the records for people living in Boston appear.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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