In Excel 2010 or later, you can 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.

Two-dimensional Pivot Table in Excel

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.

Insert a Slicer

3. Check Category and click OK.

Check Category

4. For example, Click Fruit to only show the fruit exported to each country.

Slicer Example

Note: notice how the report filter changed to Fruit. Hold down CTRL to include fruit and vegetables.

6/8 Completed! Learn much more about pivot tables >
Back to Top: Slicers   |   Go to Next Chapter: Tables