Microsoft Office Tutorials and References
In Depth Information
Clearing a Filter
Figure 7–15. The number of records you’ve filtered is tallied in the lower-left corner of the screen.
Moreover, you can filter multiple departments simultaneously. If you wanted to filter both
Sales and HR staff, you could check the boxes in Sales and HR (again, after deselecting
Select All in order to tell Excel you don’t want to see all the staff), and click OK. You’ll then
see both Sales and HR people listed on the screen, but no other staff.
Clearing a Filter
Now it’s time for an obvious question: if the filter works by hiding rows that don’t meet
the current filter criterion, how do you get those hidden rows back on the screen? That’s
easy, too: just click the Clear button to the right of the Filter button in the Sort & Filter
group, and all the database records will reappear. And in order to do this, you don’t
even have to click in the database first. The Clear command works no matter where
you’ve clicked in the worksheet. (And don’t be fooled by the word Clear here; it doesn’t
mean erase or delete —it refers to clearing the filter.)
NOTE: To turn the filter off completely, just click the Filter button a second time.
Text and Number Filters: Filters Within the Filter
Sometimes you need to filter a database on the basis of a part of a field. Consider this
example: you want to filter all the HR staff, but each employee has a department code
that looks something like this:
Search JabSto ::

Custom Search