Filtering Information in a Table

Sorting the information in a table organizes it in a logical manner, but you still have the entire table to deal with. To locate only the records containing (or not containing) specific information, filtering is more effective than sorting. For example, you could quickly create a filter to locate only customers who live in Seattle, only items that were purchased on January 13, or only orders that were not shipped by standard mail.

You can apply simple filters while viewing information in a table or form. To filter information by multiple criteria, you can apply additional filters to the results of the first one.

Get 2007 Microsoft® Office System Step by Step, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.