How To Use Slicers In Excel

Oct 27, 2020 • edited Oct 30, 2020

How To Use Slicers In Excel

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.

#Tutorial#How To#Data Analysis#Pivot Tables

How To Use Shortest Path Problem In Excel

How To Use Sort data in a range by Color In Excel