How to Add Slicers to Pivot Tables in Excel in 60 Seconds

Slicers make it easy to change your views inside of a pivot table with a clickable menu. In this tutorial, learn how to quickly add slicers to pivot tables in Excel to better control your unique spreadsheet views.

How to Add Slicers to Excel Pivot Tables (Quickly)

Note: Watch this short tutorial screencast or follow these quick steps that compliment this video:

1. Add Your First Slicer to Your Excel Pivot Table

I'm working in a pivot table here and I'll add my first slicer. With the pivot table selected, find the Analyze tab and click on Insert Slicer. The menu that pops up will show each column of data in your spreadsheet.

how to add insert a slicer in excel — How to add a slicer in Excel. First select Insert Slicer.

2. Filter Your Data View Based on Your Selections

Let's check a box on a couple of fields to create slicers from them. I'll press OK now. Now you can see these boxes that we checked in these windows of their own. When I click on one of the options in these windows, it filters the data inside of my pivot table to my selection.

Use Pivot Table Slicers to filter your selection — Use Excel Pivot Table Slicers to filter your selection.

3. Stack Your Slicers to Narrow Your View Further

So if I click on only one client for example, the pivot table updates to match. I can further refine my selection in the other box by clicking on one of these options.

The slicers stack so each box that we choose narrows down the data further. I could also make multiple selections on my data by holding control on the keyboard and clicking on another option inside of a window.

Customize your Excel Pivot Table Slicer selections for more specific views of your data.

Finishing Up!

Notice that when we do this, it adds to the selection of the data inside of the pivot table. Pivot table slicers are the easiest way to slice and dice your data with just a few clicks.