Site icon ExcelNotes

How to Use Pivot Table Slicers

After adding slicers to your Pivot Table, here are the 4 common scenarios that how you use the slicer. For example, we have the Pivot Table with slicer as below (see how to insert a slicer).

Scenario 1: To display the data in ONE region, e.g., "North" region;

Scenario 2: To display multiple regions that are adjacent, e.g., "North and East" regions;

Scenario 3: To display multiple regions that are NOT adjacent, e.g., "North and West" region;

Scenario 4: To display all regions.

When the slicer is first created, all regions are selected by default, but if not all regions, you can always click the "Clear Button" to select all regions.

Exit mobile version