Pinterest Pixel

Multi-Select Slicer Items In Microsoft Excel Pivot Tables

We love using slicers, it just adds a level of interactivity in our reports. Did you know you... read more

Download Excel Workbook
Bryan
Posted on

Overview

Multi-Select Slicer Items In Microsoft Excel Pivot Tables | MyExcelOnline Multi-Select Slicer Items In Microsoft Excel Pivot Tables | MyExcelOnline

We love using slicers, it just adds a level of interactivity in our reports. Did you know you can now multi-select slicer items as well?

With just a click on your slicer, you can now enable this!

This is our data that we will use for the Slicer.

Multi-Select Slicer Items In Microsoft Excel Pivot Tables

Multi-Select Slicer Items In Microsoft Excel Pivot Tables | MyExcelOnline

Download excel workbookMulti-Select-Slicer-items.xlsx

 

STEP 1: Insert a new Pivot table by clicking on your data and going to Insert > Pivot Table > New Worksheet or Existing Worksheet

Multi-Select Slicer Items In Microsoft Excel Pivot Tables

 

STEP 2: In the ROWS section put in the Products field.  In the VALUES section put in the Sales field.

Multi-Select Slicer Items In Microsoft Excel Pivot Tables

 

STEP 3: Let us now add our slicer! Go to PivotTable Tools> Analyze > Filter > Insert Slicer

Multi-Select Slicer Items In Microsoft Excel Pivot Tables

STEP 4: Make sure SALES REGION is ticked. Click OK.

Multi-Select Slicer Items In Microsoft Excel Pivot Tables

 

And now you have your Slicer! We just need to tick the Multi-Select button to enable this:

Multi-Select Slicer Items In Microsoft Excel Pivot Tables

And just that, you can now multi-select slicer items! See here we have now selected Americas and Asia:

Multi-Select Slicer Items In Microsoft Excel Pivot Tables

How to Multi-Select Slicer Items in Excel Pivot Tables

 

Helpful Resource:

Multiselect Slicer Items

 

 

If you like this Excel tip, please share it
Multi-Select Slicer Items In Microsoft Excel Pivot Tables | MyExcelOnline Multi-Select Slicer Items In Microsoft Excel Pivot Tables | MyExcelOnline
Multi-Select Slicer Items In Microsoft Excel Pivot Tables | MyExcelOnline
Bryan

Bryan Hong is an IT Software Developer for more than 10 years and has the following certifications: Microsoft Certified Professional Developer (MCPD): Web Developer, Microsoft Certified Technology Specialist (MCTS): Windows Applications, Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Systems Administrator (MCSA).

He is also an Amazon #1 bestselling author of 4 Microsoft Excel books and a teacher of Microsoft Excel & Office at the MyExecelOnline Academy Online Course.

See also  Group by Text fields in Excel Pivot Tables

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...