Microsoft Office Tutorials and References
In Depth Information
Clearing a Filter
and so on. The kind of filter we’ve worked with so far won’t corral all these HR members,
because each staffer is uniquely identified; they’re no longer just HR, but rather HR-274,
and so on, and our method won’t pull all the staffers out in one shot. But Excel’s text
filter will let you filter all staff who have HR somewhere in their ID, even of those IDs
aren’t exactly the same.
Start by clicking the filter drop-down arrow and then clicking Text Filters.
You’ll see the options shown in Figure 7–16. Clicking any of these
options will take you to what’s called the Custom AutoFilter dialog box, as
you’re about to see.
Figure 7–16. Text filters: Giving you more filtering options
In view of the preceding example,
let’s say that you’re interested in
filtering all the department records
that contain the letters HR—no
matter what other text appears in
each record. In that case, select
Contains… in the Text Filters
dropdown menu, and you’ll see what’s
shown in Figure 7–17.
Figure 7–17. This one’s pretty easy too. Just enter the
text the filter needs to look for.
Type HR in the field to the right of the field with the word contains , and
click OK. Doing so will filter all the records containing the HR letter
sequence, even if it appears with other letters (e.g., HR-403).