How To Use Slicer In Excel To Filter Data In Pivot Table

Introduction to Using Slicers in Pivot Tables in Excel

A pivot table is a powerful tool in Excel that allows you to quickly summarize and analyze large amounts of data. One of the most useful features of pivot tables is the ability to use slicers to filter the data and view specific subsets of information. In this tutorial, we will walk through the steps of using slicers in pivot tables in Excel.

Step 1: Create a Pivot Table

Before you can use slicers in a pivot table, you first need to create the pivot table itself. To do this, select the data you want to analyze and then click the “Insert” tab on the ribbon. From there, select “PivotTable” and then choose where you want to place the pivot table.

Step 2: Add Fields to the Pivot Table

Once you have created the pivot table, you can add fields to it by clicking the “Add Fields” button in the “PivotTable Fields” pane. You can add any fields that you want to analyze, such as sales figures, product names, or date ranges.

Step 3: Create a Slicer

To create a slicer, click the “Slicer” button in the “Analyze” tab on the ribbon. In the “Insert Slicer” dialog box, select the field you want to use as the slicer and then click “OK.” The slicer will be added to the pivot table, and you can use it to filter the data.

Step 4: Use the Slicer

Once you have created the slicer, you can use it to filter the data in the pivot table. To do this, simply click on the items in the slicer that you want to include in the analysis. The pivot table will automatically update to show only the data that matches the selected items.

Step 5: Format the Slicer

You can also format the slicer to change its appearance and make it more user-friendly. To do this, right-click on the slicer and select “Format Control.” From there, you can change the font size, color, and other settings to make the slicer look the way you want.


Using slicers in pivot tables in Excel is a great way to quickly and easily filter and analyze large amounts of data. By following the steps outlined in this tutorial, you can create and use slicers to view specific subsets of information and gain valuable insights into your data.

Free Excel Templates


General Ledger

General Ledger (GL) in accounting is a collection of accounts …


GPA Calculator

Have you ever wondered “How much will my GPA change …


Personal Income Expense Tracker

Personal Income Expense Tracker is an excel template display in …

Gantt Chart with Milestones v1

Gantt Chart Milestones

Gantt charts are excellent project planning tools, but many are …

We Create Your Life Easy With Our Free Excel Templates & Spreadsheet Dashboards

Use free Excel Templates, Tools and Dashboards to create and draft a professional looking dashboards and computation sheet for your personal and business use. You can Explore Calendars, Activity Planners, Invoice Templates, Sales Forecast Sheets, Budget templates and various business information delivering Templates in Excel and Spreadsheet at XLSX Templates. 

These templates, dashboards and tools are useful in various occasions. You can also customize these templates as per your requirement. Modification of fields and data source helps in making the template more relevant.

Learn Microsoft Excel : Blogs and Articles

Learn about various tips and tricks in Microsoft Excel and Spreadsheet. Create best templates and dashboards using free tricks and tutorials in excel and spreadsheet. These tutorial posts are useful for everyone who wants to master the skills in excel and spreadsheet.