1. Business
  2. Microsoft Excel

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

This post is part of a series called How to Use Excel - Quick Video Tutorials (in 60 Seconds).
How to Print With Gridlines in Excel in 60 Seconds
How to Freeze Panes and Rows 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
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.

More Excel Pivot Table Tutorials on Envato Tuts+

Jump into our Excel Pivot Tables Master Guide to learn more about working with this powerful spreadsheet tool, or go directly to one of these helpful tutorials: 

Also, find more great Excel tutorials on Envato Tuts+ to help you learn how to work with your spreadhsheets better. 

Looking for something to help kick start your next project?
Envato Market has a range of items for sale to help get you started.