Tom’s Tutorials For Excel: Introduced in Version 2016, the Multi-Select Icon for Pivot Table Slicers

by Tom Urtis 2 Comments ↓

Introduced in Excel 2016 is the Multi-Select icon for pivot table slicers, a welcome convenience to the heretofore requirement of pressing the Ctrl key to select multiple labels.
In the picture for example, I clicked the Multi-Select icon, then clicked to deselect the states of Arizona, Iowa, and Michigan from appearing in the pivot table’s Sum of Sales.

‹ Tom’s Tutorials For Excel: Summing a Range of Separate Pairs of Delimited Numbers

Tom’s Tutorials For Excel: Introduced in Version 2016, the “Tell me what you want to do” Field ›

Posted in Tom's Tutorials for Excel
Tags: Pivot Tables / Pivot Charts

2 comments on “Tom’s Tutorials For Excel: Introduced in Version 2016, the Multi-Select Icon for Pivot Table Slicers”

1. Victoria says:

   December 22, 2019 at 4:00 pm

   I wish the Sliders had the search box – that would be so handy!

   Reply
   • Tom Urtis says:

     December 22, 2019 at 4:39 pm

     Good idea. I’ll raise your suggestion to the Excel development team in Redmond next March at the annual MVP Summit.

     Reply