However, instead of drop-down menus, they provide large friendly buttons that are always visible.
Let’s take a look.
Here we have a pivot table that shows sales by Product.
Slicers work the same way as Report Filters, but they are easier to use.
To show how slicers work, lets add a slicer for Region and try it out.
Then hit the Insert Slicer button and select a field from the field list.
Well check Region, and click OK.
Slicers provide buttons that work just like filters.
Click a button to show only that item in the pivot table.
Note that the pivot table immediately filters on that item and the Region drop-down displays the filter icon.
it’s possible for you to also use the Shift key to enable all items between two buttons.
Again, the Report Filter is updated to match the slicer.
Slicers are directly connected to fields in a pivot table.
To clear a filter set by a slicer, nudge the Cancel Filter icon in the upper right.
it’s possible for you to easily add more than one slicer to a pivot table.
Lets add Category as a row label above Product, then add another slicer for Category.
As before, use the Control key to enable multiple values.
Notice that the field filter parameters match the slicer.
There is no requirement that a slicer field be included in the pivot table.
We can remove both Category and Region from the pivot table, and the slicer continues to function normally.
To remove a slicer from your worksheet, just choose the slicer and delete.
