Office 2013 In Depth

Filtering Table Data

Although sorting helps you arrange the records in the table in a particular order, filtering enables you to view subsets of the table records based on specific criteria. One option for filtering the data in the table is to use the AutoFilter lists on each of the table field headings. AutoFilter enables you to quickly filter the table in place.

When you select the AutoFilter arrow for a particular field, the AutoFilter menu provides a list of all the entries for that particular field. By default, all the values are selected, meaning there is no filtering currently applied to the table based on that field. Figure 15.6 shows the AutoFilter list for a table field (a date field, which provides months of the year in the filter ...