Microsoft Office Tutorials and References
In Depth Information
Filtering, showing, and hiding PivotTable data
For example, if the PivotTable’s Center field contains the values Atlantic, Central, Midwest,
Mountain West, North Central, Northeast, Northwest, Southeast, and Southwest, entering
the character string No limits the values to North Central , Northeast , and Northwest .
TIP Search filters look for the character string you specify anywhere within a field’s value,
not just at the start of the value. In the previous example, the search filter string cen would
return both Central and North Central .
In this exercise, you’ll focus the data displayed in a PivotTable by creating a filter, by filtering
a PivotTable based on the contents of a field in the Filters area, by showing and hiding
levels of detail within the body of the PivotTable, and by using the Search box.
SET UP You need the Focusing workbook located in the Chapter10 practice file folder
to complete this exercise. Open the workbook, and then follow the steps.
On the Sheet2 worksheet, click any cell in the PivotTable.
In the Choose fields to add to report area of the PivotTable Fields pane, click the
Center field header, click the Center field filter arrow, and then clear the (Select All)
check box. Excel clears all the check boxes in the filter menu.