How to Filter Pivot Tables with Slicers in Excel 2013 - dummies

How to Filter Pivot Tables with Slicers in Excel 2013

By Greg Harvey

Slicers in Excel 2013 make it a snap to filter the contents of your pivot table on more than one field. (They even allow you to connect with fields of other pivot tables that you’ve created in the workbook.)

To add slicers to your pivot table, you follow just two steps:

  1. Click one of the cells in your pivot table to select it and then click the Insert Slicer option on the Insert Slicer button located in the Sort & Filter group of the PivotTable Options contextual tab.

    Excel opens the Insert Slicers dialog box with a list of all the fields in the active pivot table.

  2. Select the check boxes for all the fields that you want to use in filtering the pivot table and for which you want slicers created and then click OK.

    Excel then adds slicers for each pivot table field you select.

After you create slicers for the pivot table, you can use them to filter its data simply by selecting the items you want displayed in each slicer. You select items in a slicer by clicking them just as you do cells in a worksheet — hold down Ctrl as you click nonconsecutive items and Shift to select a series of sequential items.

You can see the sample pivot table after using slicers created for the Gender, Dept, and Location fields to filter the data so that only salaries for the men in the Human Resources and Administration departments in the Boston, Chicago, and San Francisco offices display.


Because slicers are Excel graphic objects (albeit some pretty fancy ones), you can move, resize, and delete them just as you would any other Excel graphic. To remove a slicer from your pivot table, click it to select it and then press the Delete key.