Microsoft Office Tutorials and References
In Depth Information
Using Slicers to Filter a PivotTable
Using Slicers to Filter a PivotTable
Instead of using the AutoFilter menu each time you want to filter data in a PivotTable,
you can create a slicer button that enables you to quickly filter data in a PivotTable with
a single click. Each slicer is shown on the screen with button labels that indicate the data
being filtered. A slicer includes a header, filtering buttons, a Clear Filter button, a scroll
bar, and move and resize controls. You can have more than one slicer and move them
around on the worksheet. You can also format slicers with styles to match the look and
feel of your worksheet and easily reuse them in other PivotTables, PivotCharts, and On-
line Analytical Professing (OLAP) Cube functions. If you have multiple PivotTables, you
can share a slicer between them as needed. When you share a slicer, you create a con-
nection to another PivotTable, which is called a shared slicer. A slicer only used by one
PivotTable is called a local slicer.
Create, Format, and Delete a Slicer
Click any data field in the PivotTable for which you want to create a slicer.
Click the Analyze tab under PivotTable Tools.
Click the Insert Slicer button.
Select the check boxes with the PivotTable fields for which you want to create
a slicer.
Click OK .
A slicer appears for every checked field.
In each slicer, click the items you want to filter.
• To select more than one item, press and hold Ctrl, and then click the items.
To format a slicer, click the slicer you want to format, click the Options tab
under Slicer Tools, and then click a style in the Slicer Styles group.
Search JabSto ::

Custom Search