How to Use a Slicer to Filter Data in Excel

Tired of manually filtering data through clunky dropdown menus in Excel? There's a much more intuitive and visual way to do it: using slicers. This guide will walk you through exactly how to create, use, and customize slicers to make your data tables, PivotTables, and dashboards fully interactive.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What Exactly Are Excel Slicers?

Think of slicers as large, user-friendly buttons you can click to filter your data. Instead of digging into tiny filter dropdowns in your column headers, you get a clean, graphical interface that shows you exactly what you’re filtering by. They were first introduced for PivotTables but are now available for regular Excel Tables as well.

Slicers are especially useful when you're building a dashboard or sharing a report with colleagues who might not be as comfortable with Excel's more technical features. They make it immediately obvious what filters are currently applied and allow anyone to easily explore the data by simply clicking buttons.

Here’s why they beat traditional filters:

• They are visual: You can see all the available filtering options at a glance.
• They are interactive: Just click a button to filter your dataset. No extra steps needed.
• They show the current state: A slicer always highlights the current active filter, making it easy to understand the data you’re looking at.
• They can control multiple reports: A single slicer can be connected to multiple PivotTables, allowing you to update an entire dashboard with one click.

Step 1: Get Your Data Ready

Before you can add a slicer, your data needs to be in a structured format that Excel understands. This means it must be formatted as an official Excel Table or a PivotTable. Using a simple range of cells won’t work.

If your data is just a standard range, converting it to an Excel Table is a quick process and comes with many benefits beyond slicers, like automatic formatting and formula filling.

Here’s how to create an Excel Table:

1. Click anywhere inside your data range.
2. Go to the Insert tab on the Ribbon.
3. Click the Table button. Alternatively, you can use the keyboard shortcut Ctrl + T.
4. A "Create Table" dialog box will appear. Excel will automatically guess your data range.
5. Ensure the "My table has headers" box is checked if your data has column titles (which it should!).
6. Click OK.

Your data range will now be a formatted table, and you’ll see a new contextual tab called Table Design appear on the Ribbon whenever you click inside it. This is your cue that you’re ready to add a slicer.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 2: How to Insert a Slicer for an Excel Table

Once your data is in an Excel Table, adding a slicer takes just a few clicks. For this example, let's imagine we have a sales report with columns for Order Date, Product Category, Region, and Sales Amount.

Follow these steps to insert your first slicer:

1. Click any cell inside your formatted Excel Table.
2. Go to the Table Design tab on the Ribbon.
3. In the Tools group, click Insert Slicer.
4. The "Insert Slicers" dialog box will pop up, displaying a list of all the column headers from your table.
5. Check the box next to each column you want to create a filter for. Let's start by checking Region and Product Category.
6. Click OK.

Two slicer boxes will now appear on your worksheet, one for Region and one for Product Category. You can click and drag them anywhere you like on your sheet.

Step 3: How to Use a Slicer to Filter Data

Using slicers is remarkably intuitive. Each slicer has buttons for every unique item in its corresponding column.

To filter by a single item:

Simply click a button in a slicer. For example, clicking "North" in the Region slicer will instantly filter your table to show only sales data from the North region. The button you clicked will stay highlighted, and any irrelevant buttons in other connected slicers will be grayed out.

To select multiple items:

What if you want to see data for both the North and South regions? You have two options:

• Ctrl + Click: Hold down the Ctrl key and click each item you want to include in your filter.
• Multi-Select Button: Click the "Multi-Select" button (it looks like a checklist) at the top of the slicer. Once activated, you can just click on multiple buttons to select or deselect them. Click the "Multi-Select" button again to turn it off.

To clear a filter:

When you're ready to see all your data again, just click the "Clear Filter" icon (a funnel with a small red 'x') at the top-right corner of the slicer.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Using Slicers with PivotTables

While slicers are great with tables, they are truly transformative when paired with PivotTables. They make complex data analysis interactive and accessible to everyone. The process for adding a slicer to a PivotTable is very similar.

1. First, create a PivotTable by selecting your data, going to the Insert tab, and clicking PivotTable.
2. Click anywhere inside your PivotTable to bring up the contextual tabs on the Ribbon.
3. Go to the PivotTable Analyze tab.
4. In the Filter group, click Insert Slicer.
5. Choose the fields you want to filter your PivotTable by from the dialog box that appears and click OK.

Now, when you click a button on the slicer, your PivotTable will instantly update to reflect your selection. This combination is the foundation of most modern dashboards built in Excel.

Connecting One Slicer to Multiple PivotTables

Here’s where slicers really shine. Imagine a dashboard with two PivotTables and two charts, all built from the same data source. You can connect a single slicer to control all of them at once, creating a truly unified dashboard experience.

Here’s how to do it:

1. Create a slicer for one of your PivotTables using the steps above.
2. Right-click on the slicer and choose Report Connections.
3. A dialog box will appear, listing all the PivotTables in your workbook that can be connected to this slicer (they must share the same data source).
4. Check the boxes for all the PivotTables (and PivotCharts) you want this slicer to control.
5. Click OK.

That's it! Now, clicking a button on that single slicer panel will filter every report you connected, updating your entire dashboard in an instant.

How to Customize the Look and Feel of Your Slicers

The default blue slicers are functional, but you can easily customize them to match your report's branding or your personal preference. When you click on a slicer, a contextual Slicer tab will appear on the Ribbon.

Changing the Style and Colors

In the "Slicer Styles" section of the Slicer tab, you’ll find a gallery of different pre-made color schemes. You can hover over them for a live preview and click one to apply it. You can even create your own custom style by right-clicking a style and selecting "Duplicate."

Adjusting the Layout

Sometimes, a long list of items in a slicer takes up too much vertical space. You can easily arrange the buttons into a grid layout:

1. Select the slicer you want to adjust.
2. On the Slicer tab, look for the "Buttons" group.
3. In the Columns box, change the number from "1" to "2", "3", or however many columns you need.
4. You can also adjust the Height and Width of the buttons themselves for a perfect fit.

For example, if you have a slicer for months, arranging it in three columns makes it a compact, calendar-like panel instead of a long list.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Other Slicer Settings

Right-click any slicer and choose Slicer Settings for a few more useful options:

• Name: Change the name of the slicer that appears in its header (caption).
• Display header: Uncheck this box if you want to remove the title bar from the slicer entirely for a cleaner look.
• Hide items with no data: This is a very handy feature. It automatically hides any slicer buttons for which there is no corresponding data in your current filtered view, keeping your slicer clean and relevant.

Bonus Tip: Use Timelines for Filtering Dates

If you're working with date fields in a PivotTable, there’s an even better tool than a regular slicer: a Timeline. It's a special type of slicer designed specifically for filtering by date ranges.

To insert one:

1. Click inside your PivotTable.
2. Go to the PivotTable Analyze tab.
3. Click Insert Timeline.
4. Select your date field and click OK.

A timeline slicer will appear, allowing you to filter your data by Years, Quarters, Months, or even individual Days. You can click and drag to select a range, making time-based analysis incredibly fast and easy.

Final Thoughts

Excel slicers fundamentally change the way you interact with your data. They transform static reports into interactive dashboards, empowering both you and your colleagues to explore data and uncover insights with simple clicks. By mastering slicers for tables and PivotTables, you can build dynamic, professional-looking reports effortlessly.

While slicers are fantastic for making local spreadsheets interactive, the game changes when your data lives across different platforms like Google Analytics, Shopify, or Salesforce and needs to be updated constantly. We built Graphed to solve this very problem. It lets you connect all your data sources and create live, automatically refreshing dashboards using simple, natural language. Instead of manually filtering spreadsheets, you can just ask questions and get instant answers and visualizations in real time.