Search code examples
excelexcel-2013excel-2016slicers

Excel 2016 Slicer - select all except 1

I have a slicer that contains 340 filters. I would like to exclude 1 item. How can I do this without having to manually select the other 339?

I would like to be able to toggle between including all items ie switching the filter off completely and including all items except the item AB12345

Solution

  • Maybe I'm misunderstanding the question, but I think you can do what you want by using CTRL+click on the item you don't want to see.

    I deselected one item using CTRL+click