Use Slicers to Filter Data

Slicers provide buttons that you can click to filter table data ,or PivotTable data. In addition to quick filtering, slicers also indicate the current filtering state, which makes it easy to understand what exactly is shown in a filtered PivotTable.


You can use a slicer to filter data in a table with ease.


Note: In order to use a slicer, your data should be in a table.


Use a slicer to filter data

Click anywhere in the table.


Select Insert > Slicer.


Insert Slicer

In the Insert Slicers dialog box, select the check box of the PivotTable fields for which you want to create a slicer.


Select OK.


A slicer is displayed for every field that you selected.


Optionally you can adjust your slicer preferences in the Slicer tab (in newer versions of Excel) or the Design tab (Office 2016 and older versions) on the ribbon.


To clear a slicer’s filters, select Clear Filter  Delete in the slicer.


Note: To select more than one item, hold Ctrl, and then select the items that you want to show. Select and hold the corner of a slicer to adjust and resize it.