Hi
I have a slicer for a pivot table that I would like to include a 'select all' option, however, I don't see this as an option in the slicer configuration.
Does anyone know if there is a way to do this?
Paul
Hi
I have a slicer for a pivot table that I would like to include a 'select all' option, however, I don't see this as an option in the slicer configuration.
Does anyone know if there is a way to do this?
Paul
Hi Paul,
Slicer means "slice" not the entire bread
So if you want a "select all" option.. suggest you to have an extra column. for example.. if you have onion, chilly, carrot and you need to show all "vegetables" in one go... create an extra column in you data source by the name of "vegetable" and then you can use that in Slicer. Thanks.
Regards,
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
I am no doubt saying something blatantly obvious already but if you de-select everything in the Slicer it will show everything.
In other words clearing the filter on the slicer (top right) will select everything.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks