Excel Slicers Explained: Filtering PivotTables and Tables

Excel slicers are on-sheet buttons that let you filter an Excel Table or PivotTable by clicking values such as a region, product, or month. They show which choices are selected and make report filters easier to see and change than standard drop-down menus.

What an Excel slicer is

A slicer is a visual control linked to a field in a Table or PivotTable. If a sales report has a Region field, for example, its slicer might show buttons for East, North, South, and West. Clicking East filters the linked report to show East records; clicking another choice changes the selection. The filtered view updates without deleting or rewriting the source data.

Slicers are useful when a workbook is meant to be explored by other people. A reader can see the available categories and the current selection at a glance, rather than wondering whether a small filter arrow is active. They are especially common in dashboards, where a few prominent controls can let someone explore sales by region, product, or sales representative.

A slicer is attached to a particular field, not to a whole workbook. A Region slicer filters using values in the Region field; it does not create a new calculation or change the underlying data. Slicers can filter Excel Tables as well as PivotTables, though their connection and reporting options differ.

How slicers filter data

When you click a slicer button, Excel applies a filter to the linked Table or PivotTable. In a Table, rows that do not match the selected values are hidden from view. In a PivotTable, the displayed summary is recalculated to include only matching records. The source records remain present, so clearing the slicer restores the broader view.

A slicer usually shows all the values available for its field, with visual differences between selected values and unselected ones. Depending on the report and its settings, values with no matching data may appear unavailable or may be hidden. The slicer header includes a clear-filter control; clicking it removes that slicer’s selection and returns the report to an unfiltered state for that field.

Multiple slicers can filter the same report at once. Selecting Region = East and Product = Chairs, for instance, shows records that meet both conditions. Within a single slicer, selecting several values generally includes records matching any selected value—for example, East or West—while other slicers add further conditions.

How to add a slicer in Excel for Microsoft 365

On Windows, first make sure your data is organized as an Excel Table or summarized in a PivotTable. A plain cell range does not have the same slicer support; convert it to a Table or create a PivotTable from it. Then use the appropriate ribbon command:

For an Excel Table: click a cell in the Table, open Table Design > Insert Slicer, select one or more fields, and choose OK.
For a PivotTable: click inside the PivotTable, open PivotTable Analyze > Insert Slicer, select the fields you want, and choose OK.

Excel places a slicer object on the worksheet for each selected field. Drag a slicer to position it, and use its sizing handles to adjust its dimensions. Once selected, the contextual Slicer tab provides options for its style, layout, and settings. To remove one, select its outer edge and press Delete; this removes the control, not the source field or records.

Excel for Mac also provides slicers in supported desktop versions, although ribbon labels and available options can vary by release. Excel for the web can work with slicers in supported workbooks, but some creation or formatting controls may not be available in every build. If a command is missing, open the workbook in the desktop app and check that the object is a supported Table or PivotTable.

How to use slicer buttons

Click a button to filter by that value. To select more than one value, use the slicer’s Multi-Select control if it is displayed, or hold Ctrl while clicking additional buttons in Excel for Windows. On a Mac, the equivalent modifier is generally Command, though keyboard behavior can depend on the Excel release. Clicking a selected value again can remove it from a multi-value selection.

For example, a regional sales Table might have a slicer for Year and another for Product. Choose 2025 in the Year slicer, then select Desks and Chairs in Product. The Table shows only rows matching 2025 and either of those products. To return to all years, use the clear-filter icon on the Year slicer; clearing one slicer does not clear the selection in the other.

Keep in mind that filtering a Table hides rows but does not necessarily make every calculation elsewhere in the workbook respond to the filter. A regular SUM over the source range can still include filtered-out rows. Functions designed to account for filtered or hidden rows, such as SUBTOTAL in suitable uses, behave differently. Check how a dashboard’s formulas are built before assuming a slicer changes every displayed number.

Connecting slicers to multiple reports

A PivotTable slicer can sometimes control more than one PivotTable, which is useful when a dashboard has several views of the same records. Select the slicer and use Slicer > Report Connections (the command may be labeled PivotTable Connections in some versions). Select the compatible PivotTables you want it to control.

The PivotTables generally need to share a compatible source or PivotTable cache; merely using columns with similar names is not enough. PivotTables based on different caches may not appear in the connection list. If the reports are not listed, consider rebuilding them from the same source in a way that shares a cache, or using the same Data Model where appropriate. A slicer attached to an Excel Table does not automatically control unrelated PivotTables.

If a PivotChart is based on a PivotTable controlled by a slicer, the chart normally reflects the filtered PivotTable. This makes slicers useful for interactive charts as well as tabular summaries. Test each connection and chart after setting up a dashboard so the controls affect the intended views and do not leave a report looking inconsistent.

Formatting and arranging slicers

Slicers can be styled to match a report and arranged so that controls are easy to find. With a slicer selected, choose a style from the Slicer tab. You can also adjust the number of button columns and the slicer’s height or width. A long list of categories may need more space, or a narrower layout with several columns.

Useful design choices include:

Use clear field labels, such as “Region” or “Order year,” so readers know what each control filters.
Place related slicers together and leave enough room for longer button names.
Use consistent styles and sizing so slicers look like one set of dashboard controls.
Test the worksheet at the zoom level and window size people are likely to use.

Slicers are floating worksheet objects, so they can cover cells if moved carelessly. They can also be aligned with other shapes or report elements. Avoid relying on color alone to explain a selection: the selected buttons should remain understandable, and the field label should make the purpose of the control clear.

Slicers compared with filters and timelines

Standard Table and PivotTable filters are compact drop-down menus attached to column or field headings. They can be convenient when worksheet space is limited or when a user needs less prominent controls. Slicers use more room, but make filter choices visible and easier to operate in a presentation-style report. Both methods filter data; slicers are a more visual interface, not a different kind of source data.

Excel also has Timelines for filtering PivotTables by date. A Timeline presents dates along a time scale and can make it easier to select a period such as a quarter or a range of months. It is intended for date fields in PivotTables, while a standard slicer presents discrete field values. If the goal is to choose a particular date interval, a Timeline may be more convenient; for categories such as Region or Product, use a slicer.

Neither a slicer nor a Timeline is a security feature. Filtering a report does not remove excluded records from the workbook or prevent someone with access from examining the source data. Do not use a filtered view to protect confidential information.

Common problems and practical fixes

If a slicer does not show a value you expect, check the source field for spelling differences, blanks, or inconsistent categories. “North” and “North ” with an extra trailing space can be treated as different entries. For a PivotTable, refresh the PivotTable after changing its source data; new records may not appear in the slicer until the PivotTable’s source range includes them and the report is refreshed. An Excel Table usually expands as adjacent data is added, but confirm the PivotTable source and refresh it.

If clicking a slicer does not change one of your PivotTables, select the slicer and inspect Report Connections. That report may not be connected, or it may not share a compatible cache. If a slicer disappears or looks different after a workbook is opened in another Excel environment, check whether that version supports the object and its formatting options.

If the report remains filtered after you think you have cleared it, check every slicer and any ordinary field filters. Clearing one slicer only clears that control. Also check whether rows are hidden manually or by another filter, since those conditions can make the displayed result look similar to a slicer selection.

When slicers are a good choice

Use slicers when readers need to explore a report repeatedly and the key filtering choices are limited enough to display clearly. A sales dashboard with Region, Year, and Product slicers is a natural example. They may be less suitable when a field contains hundreds of distinct values: the control can become large and awkward, and a standard filter or a redesigned report may be more practical.

For very large or complex workbooks, consider whether the report should be simplified, whether users need a PivotTable or Table filter instead, or whether a different reporting tool better fits the job. Slicers are most effective when each control has an obvious purpose and the user can understand the results without needing to know how the source data is structured.

Frequently Asked Questions

Do Excel slicers change or delete the original data?
No. They filter the displayed rows in a Table or the results in a PivotTable. The underlying source records remain in the workbook.

Can one slicer control multiple PivotTables?
Yes, if the PivotTables are compatible, typically because they share a PivotTable cache or suitable Data Model connection. Select the slicer and use Report Connections to choose which PivotTables it controls.

Why is my new data missing from a PivotTable slicer?
The PivotTable may need its source range updated or refreshed. Confirm the data source includes the new records, then refresh the PivotTable so Excel can include the updated field values.

Can I use a slicer on a normal range?
Not directly in the same way as on a Table or PivotTable. Convert the range to an Excel Table or create a PivotTable, then insert a slicer for one of its fields.

Are slicers available in Excel for Mac and the web?
Supported desktop versions of Excel for Mac include slicer functionality, though some commands may differ. Excel for the web supports slicers in supported workbooks, but creation and formatting options can vary; use desktop Excel if a needed command is unavailable.

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.