How to Use Slicers To Filter Data In Microsoft Excel

How to Use Slicers To Filter Data In Microsoft Excel

Slicers provide an interactive way to filter the data with list and buttons. It shows which filters have applied and a list of possible values in a presentable manner. Using the existing dropdown filter which lacks showing all the possible values on the sheet for presentation. Strongly recommended the feature Slicers when presenting data analysis to customers and stakeholders with an interactive dashboard.

1.

Slicers in Microsoft Excel


1. Interactive ways to show a list of values and buttons for filter.
2. Smart and easy way to filter data in tables and pivot tables.
3. Single or multiple values selectable.
4. Cascading of slicers updates itself based on the filter selection.

Slicers Microsoft Excel - Main

2.

Data Set


Following data set used to demonstrate slicers in Microsoft in this post. Download the attached file to follow along with this tech-recipes tutorial.

How to Use Slicers In Microsoft Excel

3.

Insert Slicer – Excel Table


1. Select any random cell in the Microsoft Excel table and go to the Design tab.
2. Click on Insert Slicers.
3. Select a list of columns to create multiple slicers.

Insert Slicers Microsoft Excel

Insert Slicers Microsoft Excel_1

4.

Insert Slicer – Excel Pivot Table


1. Select any random cell in the Microsoft Pivot table and go to the Analysis tab.
2. Click on Insert Slicers.
3. Select a list of columns to create multiple slicers.

Insert Slicers Excel Pivot Table

5.

Filter Slicers In a Table – Single Selection


In the following image, a single filter Central in Region slicer is selected to filter out the data.

Slicers Excel - Single Selection

5.

Filter Slicers In a Table – Multi Selection


Here following the figure, multiple values are selected. Hold the SHIFT key and select multiple values from slicers list.

Slicers Excel - Multi Selection

6.

Filter Slicers In a Pivot Table


Similar to the table we can filter out data using slicers in the Pivot table. Single selection & multi selection works here too. Slicer needs to be inserted from the Analysis tab in case of Pivot tables.

Slicers Microsoft Excel - Pivot Table

7.

Slicers – More Customization


Numerous customization options are possible to added slicers. Select the slicer and navigate to the Options tab. We can change the colour, height, weight from the options tab. Click on Slicers Settings in Options tab to decide the Order of items in slicers list and rename the Slicers title head.

Slicers Settings - Microsoft Excel

Summary


In a nutshell, we have learnt to use Slicers to create interactive filters and dashboard. This shows the data and filters in a more presentable manner to customers and stackholders. Data analysis becomes easy to present to larger audience with ease. If you like this post you may read more on Microsoft Excel on Tech recipes.

1. How to Convert Your Excel Spreadsheets to Google Sheets
2. How to Freeze Panes in Excel — Lock Columns and Rows
3. How to Remove Duplicates in Excel
4. How to View Excel on Two Monitors

 

About Vishwanath Dalvi

Vishwanath Dalvi is a gifted engineer and tech enthusiast. He enjoys music, magic, movies, and gaming. When not hacking around or supporting the open source community, he is trying to overcome his phobia of dogs.
View more articles by Vishwanath Dalvi

The Conversation

Follow the reactions below and share your own thoughts.

Leave a Reply