You can insert slicers in Excel 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.

2. On the Analyze tab, in the Filter group, click Insert 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 in Excel

Note: the report filter (cell B1) changes 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