Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
41
Views
Topic starter
There are options showing in my slicer that (1) don't make any sense and (2) are empty. How can I exclude them from the available selections:
QUARTERS:
Qtr1
<1/1/2018
>3/2/2024
Qtr 2
Qtr 3
Qtr 4
Posted : 10/04/2024 6:47 pm
That's by design, but you can hide the slicer buttons if there is no data for them.
Select the slicer, then on the Slicer ribbon press Slicer Settings and enable 'Hide items with no data'
Posted : 11/04/2024 12:30 am