Use slicers to filter data
Convert data into table
In order to use a slicer, you must convert your data into a table first.
-
There are four ways to convert data into a table:
Select OK.
Use a slicer to filter data
Select Insert > Slicer.
Select the fields you'd like to filter.
-
Select OK and adjust your slicer preferences, such as Columns, under Options.
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.
Select Clear Filter to clear the slicer filter.
Source: Microsoft