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.
How to Insert Slicer in Excel: 3 Simple Methods
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.
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.
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.
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.
Pivot Table Slicer
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.
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.
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.
Read More: How to Format Slicer in Excel
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.
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. Subsequently, You can use slicers to filter data. 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.
Download Workbook
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 contact us in the comment section.
Related Articles
- How to Change Slicer Color in Excel
- How to Resize a Slicer in Excel
- Connect Slicer to Multiple Pivot Tables from Different Data Source
- How to Insert Slicer without Pivot Table in Excel
- [Fixed] Report Connections Slicer Not Showing All Pivot Tables
