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.
I wish the Sliders had the search box – that would be so handy!
Good idea. I’ll raise your suggestion to the Excel development team in Redmond next March at the annual MVP Summit.