Slicers

 

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