Format Slicer
Hi Tutor,
I'm having fun with the course and the materials is very useful.
I got a question on the slicer format.
In the last video (This is how the report can be used in practice by high-level executives) of Intro to Excel. You showed a formatted slicer without the "(blank)" options for each slicer. How can I create a slicer without the (blank) option?
Many thanks.
1 answers ( 0 marked as helpful)
Hi Jacky,
You need to right click on the slicer to open 'slicer settings' . From there you can opt for 'hide items with no data'.
This should help.
Best,
Ned