Excel Slicer Examples for PivotTables and Tables Explained

Useful Excel slicer examples include filtering a sales PivotTable by region, a product table by category, or a dashboard by month and salesperson. In Microsoft 365 for Windows, select the PivotTable and choose PivotTable Analyze > Insert Slicer; for an Excel table, select a cell in it and choose Table Design > Insert Slicer.

What an Excel slicer does

A slicer is a visible, clickable filter control. It displays the available values from a field—such as East, West, or Central—and updates the associated table or PivotTable when a user selects one or more values. Unlike a filter hidden in a column menu, a slicer keeps the current selection in view, making it easier to understand and change the report.

Slicers filter existing data; they do not create new calculations or change the source records. A PivotTable still summarizes its source data, while a table slicer hides rows that do not match the selection. The slicer also does not automatically control every chart or report on a worksheet. Its effect depends on which table or PivotTables it is connected to.

A slicer is most useful when people need to explore a report without editing its layout. For example, a manager can click a region button to view that region’s results, then clear the selection to return to all regions. A slicer is not a replacement for a formula, a data-cleaning step, or a filter that permanently removes records.

How to insert and use one

For a PivotTable, click inside it, open PivotTable Analyze, and choose Insert Slicer. Select one or more fields, such as Region or Product, and choose OK.
For a formatted Excel table, click inside the table, open Table Design, and choose Insert Slicer. Select the column or columns that should be available as filters.
Move and resize the slicer near the report it controls. Click a button to filter. Use the slicer’s clear-filter icon to remove its selection.

To select multiple values, use the slicer’s multi-select control if it is displayed, then click the desired buttons. In many slicer layouts, holding Ctrl while clicking also lets you add or remove individual selections. A selected button usually appears highlighted; the exact appearance depends on the workbook’s theme and slicer style.

On Excel for Mac, the ribbon labels and placement can differ from Windows. Select the PivotTable or table and look for Insert Slicer on the contextual ribbon or Insert tab. Excel for the web may also present a different ribbon layout; when a command is unavailable, use the desktop app to create or configure the slicer. A person viewing a workbook should confirm that their Excel version supports the slicer features used in it.

Practical slicer examples

Sales by region: Put Region in a PivotTable’s report fields or use it as a slicer. A click on West filters the summarized sales to that region. Add a second slicer for Year to compare a particular region and year.
Product performance: Add a Category slicer for a PivotTable that summarizes revenue by product. A user can focus on Accessories or Furniture without changing the PivotTable’s row and value fields.
Order review: Add a slicer for Order Status to a formatted table containing order records. Selecting Open leaves matching rows visible, which can help someone review outstanding orders. This filters the table view; it does not update the underlying status values.
Customer support dashboard: Use slicers for Support Team and Priority to filter a PivotTable or PivotChart showing ticket counts. A person can view high-priority tickets for one team, provided the PivotTable’s source data contains those fields.
Survey analysis: Add slicers for Department and Response Type to a PivotTable summarizing survey results. This makes it possible to compare groups interactively, while keeping the same summary structure on screen.

These examples work best when field values are consistent. If one row says “North” and another says “N.,” Excel treats them as separate values, so a Region slicer may show both. Clean or standardize the source data when those entries should represent the same category.

Building a clear slicer dashboard

A dashboard can become harder to use if it has many controls or if the controls do not match the visuals. Choose slicers for the questions a reader is likely to ask, rather than adding one for every source-data column. Region, year, product category, and status are common choices because they represent useful ways to narrow a report.

Use short, recognizable field names and consistent category labels.
Place related slicers together and keep them close to the charts or summaries they affect.
Use a compact number of columns when a slicer contains many buttons; resize it so labels remain readable.
Test each selection and the cleared state, including combinations of two or more slicers.
Make the default view obvious. A slicer with no active restriction typically represents all available items.

To change a slicer’s visual appearance, select it and use the Slicer tab to choose a style or adjust its settings. Options can include the number of button columns and the height or width of buttons. These are presentation choices: changing a style does not change the filter logic.

Connecting slicers to multiple PivotTables

A single slicer can control more than one PivotTable when those PivotTables are compatible, commonly because they share the same source or PivotTable cache. Select the slicer, open the Slicer tab, and choose Report Connections (called PivotTable Connections in some Excel interfaces). In the dialog, select the PivotTables the slicer should filter.

If a PivotTable does not appear in that dialog, it may not share a compatible cache or data source with the slicer’s PivotTable. A similar-looking source range is not always enough to make two PivotTables share a cache. Consider creating the reports from the same source and, where appropriate, using the workbook’s Data Model. Check the connection list rather than assuming that a slicer controls every report on the sheet.

Table slicers have a narrower role: they filter the table they belong to. Do not assume that a slicer attached to one independent Excel table will filter a separate table or an unrelated PivotTable. If a dashboard needs several summaries to respond together, build compatible PivotTables and verify their Report Connections.

Slicers, filters, and timelines compared

A slicer is a convenient visual interface for a field, while a standard column filter is a compact menu attached to a table or range header. Column filters can be a better fit for detailed worksheets or occasional filtering. Slicers are often easier for dashboard readers because the available choices and current selection are visible without opening a menu.

A Timeline is a separate interactive control for filtering date fields in PivotTables. It lets a reader choose a period and change the time scale, such as years, quarters, or months, when the PivotTable’s date field is suitable. Use a regular slicer for categorical fields such as region or status; use a Timeline when date-range exploration is the central task. A Timeline is not simply a slicer with a different appearance.

For more complex reporting, PivotTable filters, the Data Model, or Power Query may be more appropriate than adding more slicers. Those tools address report structure or data preparation; slicers mainly make supported filters easier to operate.

Common slicer problems and fixes

The slicer shows unexpected choices: Check the source field for spelling differences, blanks, old categories, or values that should have been standardized. Refresh a PivotTable after its source data changes.
A slicer does not affect a chart: Confirm that the chart is based on a PivotTable controlled by the slicer. A regular chart based directly on a range does not necessarily respond to a PivotTable slicer.
One PivotTable is missing from Report Connections: Check whether it shares the required source or cache. Rebuilding compatible PivotTables from a common source may be necessary.
The report appears blank: Several active slicers may combine to leave no matching records. Clear one or more filters and check whether the selected values exist together in the source data.
A slicer is covering worksheet content: Move or resize it, or adjust the layout around it. Slicers are worksheet objects, so they can overlap cells and other objects.

When a PivotTable seems stale, use PivotTable Analyze > Refresh to update it from its source. Refreshing does not correct inconsistent source labels, and it does not guarantee that a PivotTable uses the intended source range. Check the source and the slicer’s connections separately when the displayed results are wrong.

Frequently Asked Questions

Can one slicer control multiple PivotTables?
Yes, if the PivotTables are compatible with that slicer, often because they share a PivotTable cache or common Data Model. Select the slicer and check Report Connections to see which PivotTables can be connected.

Can I add a slicer to a normal Excel table?
Yes. Select a cell in the formatted table, then choose Table Design > Insert Slicer and select one or more columns. A slicer for a table filters that table’s rows; it does not automatically control separate reports.

How do I clear a slicer selection?
Click the clear-filter icon in the slicer, usually shown as a funnel with a clear symbol. This removes that slicer’s restriction. Other slicers can remain active, so the report may still show a filtered result.

Can I use a slicer for dates?
Yes, a regular slicer can filter date values as field items. For a PivotTable date field where users need to choose a time period or time scale, a Timeline is often easier to use.

Why does my slicer not show a new category?
For a PivotTable, refresh it after adding source records and check that the new value is in the PivotTable’s source range or table. Also confirm that the new value is spelled consistently and is not excluded by another active filter.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.