How to Insert Slicer in Excel?

Select a cell inside the table or PivotTable

Go to the Insert tab

Click Slicer

Check the fields you want to filter by

Click OK

Move and resize the slicer as needed

Use the slicer buttons to filter the data

Suggested for You

Trending Today