Filter data in a PivotTable

Applies to: Excel for Office 365, Excel for Office 365 for Mac, Excel for the web, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac.

Filter your data to hone in on a smaller segment of your PivotTable data for granular analysis. Initially, add one or multiple slicers for a fast and productive way to filter your data. Slicers contain responsive buttons you can press to filter the data, and keep present alongside your data, ensuring you’re constantly aware what fields are visible or hidden in the filtered PivotTable.

Tip: Now in Excel 2016, you can multi-select slicers by pressing the button on the label as shown above.

Slicer choices with the multi-select button highlighted


Filter data in a PivotTable

  1. Choose a cell in the PivotTable. Pick Analyse > Insert Slicer Slicer .
  1. Pick your suited fields to form slicers for. Then press OK.
  1. Choose your preferred items to display in the PivotTable.

Filter data manually

  1. Choose the column header arrow  Filter drop-down arrow  for the specific column you seek to filter.
  1. Uncheck (Select All) and choose the boxes you want to present. Then click OK.

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

See Also

Video: Filter data in a PivotTable

Create a PivotTable to analyse worksheet data

Create a PivotTable to analyse external data

Create a PivotTable to analyse data in multiple tables

Sort data in a PivotTable

Group or ungroup data in a PivotTable

Leave a Reply

%d bloggers like this: