How to Insert Slicer in Excel (3 Simple Methods)

If you want to insert a slicer in Excel, this article will be helpful for you. Here, we will demonstrate to you 3 easy and simple methods that will help you to do the task effortlessly.

Download Workbook

3 Methods to Insert Slicer in Excel

The following Product List table contains the Month, Product Name, and Sales columns. Here, we want to insert a slicer. Here, we used Excel 365. You can use any available Excel version.

How to Insert Slicer in Excel


Method-1: Using PivotTable Fields List to Insert Slicer

In this method, first of all,  we will insert a Pivot Table from the dataset of the Product List table, after that, we will insert a slicer to that Pivot Table by using the PivotTable Fields list.

Step 1: Inserting a Pivot Table

➤ First, we will select the entire dataset of the Product List table > go to the Insert tab > select PivotTabe > select From Table/Range.

How to Insert Slicer in Excel

We will see a PivotTable from table or range window appear.

➤ After that, we will click on New Worksheet > click OK.

➤ Then, in the PivotTable Fields, we will keep the Month and Product Name in the Rows area, and Sales in the Values area.

Finally, we will see the Pivot Table with Row Labels and Sum of Sales columns.

How to Insert Slicer in Excel

Step 2: Inserting Slicer by Using PivotTable Fields List

Now, we will insert a slicer into the Pivot Table by using the PivotTable Fields list.

➤ First, we will right-click on any of the PivotTable Fields items to insert a slicer. Here, we want a slicer of Product Name, therefore, we right-click on the Product Name.

➤ Afterwards, we will select Add as Slicer option.

After that, we can see the list of the Product Name.

Now, from the Product Name list, we can choose any of the product names, and we will see the slicer of that product.

➤ Here, we want to use the slicer of the product Butter, therefore, we will click on Butter.

Finally, we can see the data for the product Butter in the Pivot Table.

How to Insert Slicer in Excel

Read More: Excel Slicer for Multiple Pivot Tables (Connection and Usage)


Method-2: Using PivotTable Analyze Tab to Insert Slicer

Here, at first, we will insert a Pivot Table from the dataset of the Product List table, after that, we will insert a slicer to that Pivot Table using the PivotTable Analyze tab.

Step 1: Inserting a Pivot Table

➤ First, we will select the entire dataset of the Product List table > go to the Insert tab > select PivotTabe > select From Table/Range.

How to Insert Slicer in Excel

After that, we will see a PivotTable from table or range window appear.

➤ Then, we will click on New Worksheet > click OK.

➤ Afterwards, in the PivotTable Fields, we will keep the Month and Product Name in the Rows area, and Sales in the Values area.

Finally, we will see the Pivot Table with Row Labels and Sum of Sales columns.

Step 2: Inserting Slicer by Using PivotTable Analyze Tab

➤ First, we will click on a cell in the Pivot Table > go to the PivotTable Analyze tab > select the Insert Slicer option.

An Insert Slicer window will appear.

You can choose one or more items from that window. Here, we want to insert the slicer only for Product Name.

➤ After that, we will select Product Name > click OK.

Afterwards, we will see the Product Name list. Here, you can choose any of the products to use the slicer. We want to use the slicer of the product Milk.

➤ Then, we will click on Milk.

Finally, we can see the data for the product Milk in the Pivot table.

How to Insert Slicer in Excel

Read More: How to Filter Excel Pivot Tables with Slicers!


Method-3: Using Table Design Tab to Insert Slicer in Excel

In this method, we will first insert a Table from the dataset of the Product List table, after that, we will insert a slicer to that Table by using the Table Design tab.

Step 1: Inserting a Table

➤ First, we will select the entire dataset > select the Insert tab > select Table.

How to Insert Slicer in Excel

A Create Table window will appear.

➤ After that, we will mark the My table has headers box > click OK.

Finally, we can see the Table.

Step 2: Inserting Slicer by Using Table Design Tab

➤ First, we will click on a cell in the Table > go to the Table Design tab > select the Insert Slicer option.

Afterward, an Insert Slicer window will appear.

You can select as many items from that window as you want. Here, we only want Month.

➤ Then, we will select Month > click OK.

Afterward, we can see the Month list. Among this list, you can choose one of the months according to your needs. Here, we want to filter for the month of June.

➤ Then, we will click on June.

Finally, we can see the data for the month of June in the Table.

How to Insert Slicer in Excel

Read More: How to Insert Slicer without Pivot Table in Excel


Conclusion

Here, we tried to show you 3 methods to insert a slicer in Excel. Thank you for reading this article, we hope this was helpful. If you have any queries or suggestions, feel free to know us in the comment section.


Related Articles

Tags:

Afia
We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo