Hi, I use pivot tables & slicers all the time, and I wonder if there's a way to set the slicer default to "hide items with no data" so I don't have to check the box every time I create a new slicer... I've searched online but did not find any answers...
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Set Slicer default "Hide Items with no data"
- Thread starter LCinVA
- Start date
Excel Facts
Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
Similar threads
- Question
- Replies
- 0
- Views
- 39
- Replies
- 4
- Views
- 294
- Replies
- 1
- Views
- 560
- Replies
- 1
- Views
- 234
