How to Use Slicers in Excel
Below you can find a two-dimensional pivot table. Go back to Pivot Tables to learn how to create this pivot table.
To insert a slicer, execute the following steps.
1. Click any cell inside the pivot table. The PivotTable Tools contextual tab activates.
2. On the Options tab, insert a slicer.
3. Check Category and click OK.
4. For example, Click Fruit to only show the fruit exported to each country.
Note: notice how the report filter changed to Fruit. Hold down CTRL to include fruit and vegetables.