Microsoft Office Tutorials and References
In Depth Information
Finding What You Want with Filters
Figure 7–11. Note the filter arrows .
NOTE: The filter drop-down buttons will not print, even if they are visible on the screen. If the
arrows obscure part of a field heading, you can widen that column.
3. Now let’s say we want to view only
those employees who work in Sales.
Just click the filter down arrow by
Department, as shown in Figure 7–12.
Figure 7–12. All the departments in the
company are listed.
4. Then click the Select All check box, which removes the check marks next
to all the department names. Then click the Sales check box and click
OK. You’ll see the results shown in Figure 7–13.