![Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.](https://support.content.office.net/en-us/media/4873755a-8b1e-497e-bc54-101d1e75d3e7.png)
Try it!
Filter the data to focus on a smaller portion of your PivotTable for an in-depth analysis.
Filter data in a PivotTable
-
Select a cell in the PivotTable.
-
Select Analyze > Insert Slicer
. -
Select the fields you want to create slicers for.
-
Select OK.
-
Select the items you want to show in the PivotTable.
Filter data manually
-
Select the column header arrow
for the column you want to filter. -
Uncheck (Select All) and select the boxes you want to show.
-
Select OK.