Microsoft Office Tutorials and References
In Depth Information
To use a Slicer to remove a filter, click the Clear Filter button in the upper-right corner of
the Slicer. If you want to resize a Slicer, you can do so by dragging the resize handle in the
lower-right corner of the Slicer. To hide the Slicer, right-click it and then click the menu
command that starts with the word “Remove.” For example, the Month field’s menu
command would be Remove Month.
Tip You can change a Slicer’s formatting by clicking the Slicer and then, on the Slicer Tools
Options contextual tab on the ribbon, clicking a style in the Slicer Styles gallery.
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 Report Filters area, by showing and
hiding levels of detail within the body of the PivotTable, by using the Search box, and by
SET UP You need the Focusing_start workbook located in your Chapter09 practice
file folder to complete this exercise. Open the Focusing_start workbook, and save it
as Focusing . Then follow the steps.
1. On the Sheet2 worksheet, click any cell in the PivotTable.
2. In the PivotTable Field List task pane’s Choose fields to add to report area,
click the Center field header, click the Center field filter arrow, and then clear the
(Select All) check box.