
The filtering arrow changes to this icon to indicate that a filter is applied.

In the list of row or column labels, uncheck the (Select All) box at the top of the list, and then check the boxes of the items you want to show in your PivotTable. In the PivotTable, click the arrow on Row Labels or Column Labels. Turn filtering options on or off Filter data manually

Use any of the following filtering features instead of or in addition to using slicers to show the exact data you want to analyze.įilter by selection to display or hide selected items only

You can apply a slicer style or change settings using the various tab options. Tip: To change how the slicer looks, click the slicer to show the Slicer tab on the ribbon.
