Microsoft Office Tutorials and References
In Depth Information
Clearing a Filter
NOTE: The term AutoFilter is really equivalent to the term filter , even though Excel switches
between the two.
And once you see how that works, you’ll
see that the other text filter options
(Equals..., Does Not Equal..., etc.) are easy to
figure out. Clicking any of these takes you
back to that same Custom AutoFilter dialog
where the appropriate option appears. In
fact, if you click the down arrow to the
right of the contains entry (shown previously
in Figure 7–17), you’ll see all the text filter
options, as shown in Figure 7–18.
Figure 7–18. No matter which text filter option you
choose, the drop-down menu can always take you to
NOTE: If you take a close look at Figure 7–18, you’ll notice the is greater than option, which
sounds like an odd choice to be offered when you’re filtering text. But here, “greater than” refers
to text in the field starting with letters in the alphabet coming after the text you’ve specified. For
example, if you enter the letter D under the is greater than option, the text filter will locate all
names starting with letters appearing after D in the alphabet, as well as names such as
Dreiser—because Dre . . . is more than, or greater than, just plain D.
But what’s probably going to serve you more productively than text filters are the
number filters . These let you filter all workers earning more than $30,000, or all
employees making more than the company salary average, for example.
The following steps show you how to apply a number filter.
Click in a field populated with
values such as salaries, and then
click the field drop-down arrow
(again, after you’ve clicked Clear
to return all the records to the
screen). You’ll see the options
shown in Figure 7–19.
Figure 7–19. Number filters