Hello, everyone, I'm using Excel 2016.
Two questions about slicers, if I may, please.
Thank you! Jack Danniel
PS: For future use, which forum section is the best to put questions about slicers?
Two questions about slicers, if I may, please.
- Is there a keyboard shortcut or function that allows me to clear the filters of all my slicers? I currently have five slicers. I may add more. Do I have to record a macro to do this, or is there something already built into Excel that does this, regardless of how many slicers I have?
- Can I use conditional formatting with a slicer? To be specific, if a slicer contains five different buttons, can I use different conditional formatting for each of those buttons?
Thank you! Jack Danniel
PS: For future use, which forum section is the best to put questions about slicers?