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

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.
TTFE0022

Share Button
Posted in Tom's Tutorials for Excel
Tags:
2 comments on “Tom’s Tutorials For Excel: Introduced in Version 2016, the Multi-Select Icon for Pivot Table Slicers
  1. Victoria says:

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

Leave a Reply

Your email address will not be published. Required fields are marked *

*