![Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.](https://cxcs.microsoft.net/static/public/surface-and-devices/neutral/4873755a-8b1e-497e-bc54-101d1e75d3e7/d07c07fd6aabfe12ed716e87301dc3a1a3a7b5b0.png)
Try it!
Convert data into a table
-
There are four ways to convert data into a table:
Note: In order to use a slicer, you must convert your data into a table first.
-
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.