![]() Thank you for reading this article, we hope this was helpful. Here, we tried to show you 3 methods to insert a slicer in Excel. Read More: How to Insert Slicer without Pivot Table in Excel Here, we want to filter for the month of June.įinally, we can see the data for the month of June in the Table. ![]() Among this list, you can choose one of the months according to your needs. ![]() Here, we only want Month.Īfterward, we can see the Month list. You can select as many items from that window as you want. ➤ First, we will click on a cell in the Table > go to the Table Design tab > select the Insert Slicer option.Īfterward, an Insert Slicer window will appear. Step 2: Inserting Slicer by Using Table Design Tab ➤ After that, we will mark the My table has headers box > click OK. ➤ First, we will select the entire dataset > select the Insert tab > select Table. 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. Method-3: Using Table Design Tab to Insert Slicer in Excel Read More: How to Filter Excel Pivot Tables with Slicers! We want to use the slicer of the product Milk.įinally, we can see the data for the product Milk in the Pivot table. Here, you can choose any of the products to use the slicer. ➤ After that, we will select Product Name > click OK.Īfterwards, we will see the Product Name list. Here, we want to insert the slicer only for Product Name. You can choose one or more items from that window. ➤ First, we will click on a cell in the Pivot Table > go to the PivotTable Analyze tab > select the Insert Slicer option. Step 2: Inserting Slicer by Using PivotTable Analyze Tab ➤ Afterwards, in the PivotTable Fields, we will keep the Month and Product Name in the Rows area, and Sales in the Values area. ➤ Then, we will click on New Worksheet > click OK. 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.Īfter that, we will see a PivotTable from table or range window appear. Method-2: Using PivotTable Analyze Tab to Insert Slicer Read More: Excel Slicer for Multiple Pivot Tables (Connection and Usage) ➤ Here, we want to use the slicer of the product Butter, therefore, we will click on Butter.įinally, we can see the data for the product Butter in the Pivot Table. Now, from the Product Name list, we can choose any of the product names, and we will see the slicer of that product. ➤ Afterwards, we will select Add as Slicer option.Īfter that, we can see the list of the Product Name. Here, we want a slicer of Product Name, therefore, we right-click on the Product Name. ➤ First, we will right-click on any of the PivotTable Fields items to insert a slicer. Now, we will insert a slicer into the Pivot Table by using the PivotTable Fields list. Step 2: Inserting Slicer by Using PivotTable Fields List ➤ Then, in the PivotTable Fields, we will keep the Month and Product Name in the Rows area, and Sales in the Values area.įinally, we will see the Pivot Table with Row Labels and Sum of Sales columns. ➤ After that, we will click on New Worksheet > click OK. We will see a PivotTable from table or range window appear. ➤ First, we will select the entire dataset of the Product List table > go to the Insert tab > select PivotTabe > select From Table/Range. In this method, first of all, we will insert a Pivot Tablefrom the dataset of the Product List table, after that, we will insert a slicer to that Pivot Table by using the PivotTable Fields list. Method-1: Using PivotTable Fields List to Insert Slicer The following Product List table contains the Month, Product Name, and Sales columns.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |