Microsoft Office Tutorials and References
In Depth Information
The AutoFilter: Picking and Choosing Your Data
Keeping all that in mind, click the down arrow alongside Student. You’ll see (Figure 6–17):
Figure 6–18. The filter drop-down menu
Among other things, you’re presented with a list of all the student names, listed uniquely , that is,
once each. Even if the same student name should appear in the field many times, the AutoFilter
dropdown list will record it once. Note all the names are selected, and we want to see Dorothy’s alone, so:
Click the Select All button. The check marks disappear from all the names.
Click Dorothy.
Click OK. You should see (Figure 6–18):
Figure 6–19. There’s Dorothy, again—now that we know how it’s done
There she is. Had her name appeared multiple times in the Student field, each “Dorothy” row would
appear in your filtered result. (You could also type Dorothy in the Search field appearing right above the
list of student names, and then click OK. (You can also use wild cards here, too—meaning if I type Dor*
in the Search field, the records of all student names beginning with Dor will be filtered, including Doris,
Now at some point you’ll naturally want to restore all the other rows to the screen. To do this, just
click the Clear button in the Sort & Filter group, and you’re back where you started. You can now apply
the filter to any other name, or names—meaning you can click on several names in the drop-down list
above. If you need to see the grades for both Dorothy and George at the same time, just click those two
names (Figure 6–19):.
Search JabSto ::

Custom Search