How To Add Slicer In Excel?

Select any cell in the table or PivotTable

Go to the Insert tab

Click Slicer

Choose the field or fields you want to use

Click OK

Use the slicer buttons to filter the data

To connect a slicer to multiple PivotTables, select the slicer

Go to the Slicer tab or Slicer Tools tab

Click Report Connections or PivotTable Connections

Select the PivotTables you want to connect

Click OK

Suggested for You

Trending Today