Multiple Selections in Slicers for Excel PivotTables

Office for Mere Mortals
Your beginners guide to the secrets of Microsoft Office
Invalid email address
Tips and help for Word, Excel, PowerPoint and Outlook from Microsoft Office experts.  Give it a try. You can unsubscribe at any time.  Office for Mere Mortals has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy

Rarely do you choose a single Slicer button.  More likely you’ll want to select multiple filters or buttons, here’s the various ways to do that.

You can press the filter icon next to Beverages and then select multiple items if you want to see both.

multiple selections in slicers for excel pivottables 15782 - Multiple Selections in Slicers for Excel PivotTables

Just like other parts of Windows, hold down the Ctrl key if you want to select multiple items in your slicer. See the screenshot below: I have selected both the categories and two dates. You can select as you want your data to appear on the spreadsheet.

multiple selections in slicers for excel pivottables 15783 - Multiple Selections in Slicers for Excel PivotTables

Multi-Select

Another way to select many filters is the Multi-select button on top right of the slicer.  Click that button on (or Alt + S ) then just click on slicer items to select/deselect them.

multiple selections in slicers for excel pivottables 15784 - Multiple Selections in Slicers for Excel PivotTables

Clear Slicer Filter

To remove all filters and show all data, click the Clear Filter button at top right or Alt + C.

multiple selections in slicers for excel pivottables 15785 - Multiple Selections in Slicers for Excel PivotTables

subs profile e1563205311409 - Multiple Selections in Slicers for Excel PivotTables
Latest news & secrets of Microsoft Office

Microsoft Office experts give you tips and help for Word, Excel, PowerPoint and Outlook.

Give it a try. You can unsubscribe at any time.  Office Watch has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy
Invalid email address