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

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:

See also  Insert Grand Totals to a Pivot Table

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 itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

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

Bryan is a best-selling book author of the 101 Excel Series paperback books.

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!