To apply Slicer, first create a Pivot table in the form of a table which is available under the Insert menu option.

Then, the same Insert menu tab, select Slicer which is available under the Filters section.

In the slicer connection box, we will be able to see an Insert Slicer box with all the available data headers used in creating that Pivot Chart.

Now if we select any or multiple fields, we will be able to get a slicer box in the screen.

It will pop up a new window called Create Table with all the ranges we have selected to insert Table.

Click on Insert Slicer button under Tools section inside the Design tab.

Inside it, you can have all the columns present in the table and can use any of them as a slicer.

I will choose Country as a slicer option and see what happens.

It will apply a filter on the table for all the rows with India as a country.

You will find out an option called PivotTable under Tables section.

Now you can choose the columns which you wanted to see under pivot layout.

Click on Insert Slicer button present under the Filters section in Analyze tab to insert a slicer.

I would like to add the Customer column under slicers and hit the OK button.

Hold the CTRL button and click one by one the slicers which you want to slice data against.

Here we discuss How to Insert Slicer in Excel along with practical examples and downloadable excel template.

By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy.

How To Use Slicer In Excel For Mac