Excel Slicer: How to use Excel slicer to filter data

Excel Slicer: How to use Excel slicer to filter data

What Slicer in excel

Slicers are floating buttons in excel by which we can filter data in an excel table or pivot table. In addition to this slicer reflects the current filter state means what options are selected currently. We can move slicers anywhere in the sheet and even can change their size and color.

How to create Slicer

To create a slicer we need a pivot table or just an excel table. First, we need to go to the Insert tab in ribbon >> Filter section >> Slicer as shown in the below image.

Slicer 1
How to create Slicer

Click on Slicer a new pop up option will come which … Continue Reading