Filter data in a PivotTable

Filter data in a PivotTable in slicers

You can insert one or more slicers for a quick and effective way to filter your data. Slicers have buttons you can click to filter the data, and they stay visible with your data, so you always know what fields are shown or hidden in the filtered PivotTable.

1. Select any cell within the PivotTable, then on the Pivot Table Analyze tab, choose Slicer button Insert Slicer.

Pivot Table Analyze

2. Choose the fields you want to create slicers for, and select OK.

Fields

3. Excel will place one slicer for each selection you made onto the worksheet, but it's up to you to arrange and size them however is best for you.

Slicer

4. Select the slicer buttons to choose the items you want to show in the PivotTable.

Slicer buttons

Filter data manually

1. To display AutoFilter, select the Filter drop-down arrow, which varies depending on the report layout.

Auto Filter

2. To filter by creating a conditional expression, select Label Filters, and then create a label filter.

Conditional Expression

3. To filter by values, select Values Filters and then create a values filter.

Value Filters

4. To filter by specific row labels (in Compact Layout) or column labels (in Outline or Tabular Layout), uncheck Select All, and then select the check boxes next to the items you want to show, then select OK.

Row Labels