Excel Slicer: How to use Excel slicer to filter data

Excel Slicer: How to use Excel slicer to filter data

What Slicer in excel

Slicers are floating buttons in excel by which we can filter data in an excel table or pivot table. In addition to this slicer reflects the current filter state means what options are selected currently. We can move slicers anywhere in the sheet and even can change their size and color.

How to create Slicer

To create a slicer we need a pivot table or just an excel table. First, we need to go to the Insert tab in ribbon >> Filter section >> Slicer as shown in the below image.

Slicer 1
How to create Slicer

Click on Slicer a new pop up option will come which will contain all column name of the table/pivot table. In this example have taken excel table to elaborate it.

Excel Slicer
Insert Slicer

Choose an option(column name) from the pop up. In this example Agent ID.A new pop up will open and it will have all unique value of this column.

Slicer 3
Slicer option

Now if we will select any option from this data will get filtered for this option only. I have selected Agent Harry in this option.

Slicer for data filter
Selecting Slicer option

There are other options available by which we can control slicer. Like changing color & style, size, alignment of slicer. There is one more option available which is Slicer setting. It can help in changing name of slicer, display of header and hide items with no data.


There are more option to explore that I will leave on you to explore. That’s all for now will talk in next post.


You can watch this video for better understanding on this.

2 thoughts on “Excel Slicer: How to use Excel slicer to filter data”

  1. Pingback: Excel Pivot Table: How to use it and its basic understanding - DataWitzz

  2. Pingback: Table in Excel: How to create excel table step by step by 2 methods - Learning, we made it Easy

Leave a Comment