O'Reilly logo

Office 2013 In Depth by Joe Habraken

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required