How to Insert a Slicer in a Pivot Table in Microsoft Excel
Slicers make it really easy to filter data in a pivot table. Adding a Slicer is similar to adding a second Page field (Report Filter) but is even easier to use. To add a Slicer to a pivot table, follow these four steps.
This feature works the same in all modern versions of Microsoft Excel: 2010, 2013, and 2016.
- Select any cell in the pivot table.
- On the PivotTable Tools Analyze tab (PivotTable Tools Options tab in Excel 2007/2010), in the Filter group (Sort & Filter group in Excel 2007/2010), click the Insert Slicer command (and then select Insert Slicer in Excel 2007/2010).
- In the Insert Slicers dialog box, check the field or fields (Yes, you can create multiple slicers at once!) to use to "slice" your data, then click OK.
- To use the Slicer, simply select one of the fields in the Slicer to filter your data by that field.