How to remove old redundant items from pivot table slicers in Microsoft Excel
Slicers are great for filtering pivot tables, but may get cluttered with redundant items that were deleted over time from the source data of the pivot table. A large number of old items in a slicer can be quite annoying to the user. So in this video you will see two methods, how to clean such messy slicers.
0:00 Introduction
0:39 Why slicer items turn redundant
1:57 Clean-up method 1 (using Slicer Settings)
2:39 Clean-up method 2 (using PivotTable Options)
For more content like this, please subscribe to my channel.
#MsExcel #ExcelTips #excel
Screenshots used with permission from Microsoft.