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.
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.
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.
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:
- Microsoft ExcelHow to Create Your First PivotTable in Microsoft ExcelAndrew Childress
- Microsoft ExcelHow to Use PivotTables to Analyze Your Excel DataAndrew Childress
- Microsoft ExcelHow To Make Use of 5 Advanced Excel Pivot Table TechniquesAndrew Childress
Also, find more great Excel tutorials on Envato Tuts+ to help you learn how to work with your spreadhsheets better.
Subscribe below and we’ll send you a weekly email summary of all new Business tutorials. Never miss out on learning about the next big thing.Update me weekly