M365 Excel - Use Slicers to Filter Data – Union County IT

Slicers provide buttons that you can click to filter tables, or PivotTables. In addition to quick filtering, slicers also indicate the current filtering state, which makes it easy to understand what exactly is currently displayed.

Create a Slicer to Filter data in a table or PivotTable

Click anywhere in the table or PivotTable.
On the Insert tab, select Slicer.
In the Insert Slicers dialog box, select the check boxes for the fields you want to display, then select OK.

A slicer will be created for every field that you selected. Clicking any of the slicer buttons will automatically apply that filter to the linked table or PivotTable.

Notes:

To select more than one item, hold Ctrl, and then select the items that you want to show.
To clear a slicer's filters, select Clear Filter in the slicer.

Format a Slicer

You can adjust your slicer preferences in the Slicer tab (in newer versions of Excel), or the Design tab (Excel 2016 and older versions) on the ribbon.
On the Slicer or Design tab, select a color style that you want.

Make a Slicer available in another PivotTable

If you have a slicer on a PivotTable already, you can use that same slicer to filter another PivotTable.

Note: Slicers can only be connected to PivotTables that share the same data source.

First create a PivotTable that is based on the same data source as the PivotTable that already has the slicer want to reuse.
Select the slicer that you want to share in another PivotTable. This displays the Slicer tab.
On the Slicer tab, select Report Connections.
In the dialog box, select the check box of the PivotTable in which you want the slicer to be available.

Disconnect a Slicer

Click anywhere in the PivotTable to which slicer you want to disconnect. This displays the PivotTable Analyze tab.
Select the PivotTable Analyze tab, and then select Filter Connections.
In the dialog box, clear the check box of any PivotTable fields for which slicer you want to disconnect.

Delete a Slicer

Do one of the following:

Select the slicer, and then press Delete.
Right-click the slicer, and then select Remove <Name of Slicer>.

Related to