Advanced Pivot Table Tasks

Creating a Slicer

Now in Excel 2016, you can multi-select slicers by clicking the button on the label as shown above. 

1. Click anywhere in the PivotTable to show the PivotTable Tools on the ribbon.
   
2. Click Analyze > Insert Slicer. 
   
3. In the Insert Slicers dialog box, check the boxes of the fields you want to create slicers for.
4. Click OK. A slicer appears for each field you checked in the Insert Slicers dialog box. 
5. In each slicer, click the items you want to show in the PivotTable.

To choose more than one item, hold down Ctrl, and then pick the items you want to show.


Tip: To change how the slicer looks, click the slicer to show the Slicer Tools on the ribbon, and then apply a slicer style or change settings on the Options tab. 

Using the Slicer Tools Tab

To modify a slicer, click on the slicer and you will see the Slicer Tools ribbon containing Options tab.