How to Use Slicers to Filter Data in Excel (2 Easy Methods)

Method 1 – Use Slicers to Filter Data from Worksheet

Steps:

  • Select the whole dataset and choose the “Table” option from the “Insert” feature.

Use Slicers to Filter Data from Worksheet

  • Your dataset will be converted to a table.

If you want you can change the background color.

  • Select all the cells and changed the background color. We have selected “White”.

  • Select any cell from the table, go to the “Insert” option and press “Slicer”.

Use Slicers to Filter Data from Worksheet

  • From the new window, choose your filtering header and press OK.

  • You will get all the slicers inside the worksheet.

Use Slicers to Filter Data from Worksheet

  • To filter the data using the slicers, single click your desired “Year”, “Product Category”, and “Products” from the slicers and the dataset will visualize data according to it.

Use Slicers to Filter Data from Worksheet

  • You can also choose multiple filtering options from the slicers by clicking the “Multiple Selection” option at the top of any slicers.

  • Click the “Multiple Selection” feature and choose various selections as shown in the image below.

Use Slicers to Filter Data from Worksheet

Read More: How to Make Excel Slicer with Search Box


Method 2 – Apply Slicers to Filter Data in Pivot Table

Steps:

  • Select the whole data from the table and choose “Pivot Table” from the “Insert” option.

Apply Slicers to Filter Data in Pivot Table

  • From the new window, click the “Existing Worksheet” and choose a cell according to your choice in the worksheet.
  • Press OK to continue.

Apply Slicers to Filter Data in Pivot Table

A right pane will pop up.

  • Drag your headings to different locations to rearrange your pivot table.

  • Choose any cell from the pivot table and click the “Insert Slicer” option from the “PivotTable Analyze” feature.

Apply Slicers to Filter Data in Pivot Table

  • Select any category from the list to open multiple slicers.
  • Press OK to continue.

Apply Slicers to Filter Data in Pivot Table

  • You will get the chosen slicers for the pivot table.

In the following image, we wanted to see the “Price” for the “Home Appliance” item sold in “2018” with a review of “4”.

Clicking the filters from multiple slicers we have the final output.

Apply Slicers to Filter Data in Pivot Table


Download Practice Workbook


Further Readings


Get FREE Advanced Excel Exercises with Solutions!
Kawser Ahmed
Kawser Ahmed

Kawser Ahmed is a Microsoft Excel Expert, Udemy Course Instructor, Data Analyst, Finance professional, and Chief Editor of ExcelDemy. He is the founder and CEO of SOFTEKO (a software and content marketing company). He has a B.Sc in Electrical and Electronics Engineering. As a Udemy instructor, he offers 8 acclaimed Excel courses, one selected for Udemy Business. A devoted MS Excel enthusiast, Kawser has contributed over 200 articles and reviewed thousands more. His expertise extends to Data Analysis,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo