- Click anywhere in the PivotTable for which you want to create a slicer.
- On the Analyze tab, click Insert Slicer. In older versions of Excel, click the Options tab, and then click Insert Slicer.
- In the Insert Slicers dialog box, select the check box of the PivotTable fields for which you want to create a slicer.
- Click OK.A slicer is displayed for every field that you selected.
- In each slicer, click the items on which you want to filter.
Reference : https://support.office.com
x
0 Comments