How to Use Slicers in Excel
Excel 2010 makes it possible to insert slicers to quickly and easily filter pivot tables. However, using the report filter gives the exact same result.
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.