Microsoft Office Tutorials and References
In Depth Information
Tip If you have already applied a filter to the field for which you display a Slicer, the Slicer
reflects the filter’s result.
A Slicer displays the values within the PivotTable field you identified. Any value displayed in
color (or gray if you select a gray-and-white color scheme) appears within the PivotTable.
Values displayed in light gray or white do not appear in the PivotTable.
Clicking an item in a Slicer changes that item’s state—if a value is currently displayed in
a PivotTable, clicking it hides it. If it’s hidden, clicking its value in the Slicer displays it
in the PivotTable. As with other objects in an Excel 2010 workbook, you can use the Shift
and Ctrl keys to help define your selections. For example, suppose you create a Slicer for
the Month field while every month is displayed.