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:
-
Press Ctrl + T.
-
Press Ctrl + l.
-
Select Home > Format as Table.
-
Select Insert > 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