Microsoft Excel Slicers: How They Work and How to Use Them

A Microsoft Excel slicer is a set of clickable buttons that filters a table or PivotTable by the values in a chosen field. To add one in Excel for Microsoft 365 on Windows, select a table or PivotTable, choose the relevant Insert Slicer command on the ribbon, and select the field you want people to filter.

What an Excel slicer does

A slicer makes a filter visible on the worksheet instead of tucking it into a column’s filter menu. Each button represents a value in the field you selected. For example, a slicer for a Region column might show East, North, South, and West. Clicking East filters the associated data to show records for that region.

Slicers are useful in reports and dashboards because readers can see which filter choices are available and which ones are active. They can also make a workbook easier to use for someone who does not know where Excel’s standard filter controls are. A slicer is not a chart or a formula: it is an interactive control that changes which records are displayed in its connected data source.

Excel provides slicers for Excel tables and PivotTables. A slicer connected to a table filters the table’s rows. One connected to a PivotTable filters the summarized results. A PivotChart linked to that PivotTable usually responds to the same filter, so a reader can use the slicer to explore a chart as well as the summary.

How slicers work

When a slicer is added, Excel builds its buttons from the distinct values in the selected column or PivotTable field. Clicking a button applies a filter; clicking a different button changes the selection. The slicer remains a separate object on the sheet, so you can move or resize it without changing the underlying data.

Selected items are visually distinguished from items that are not selected. Depending on the data and slicer settings, values with no matching records may appear unavailable or may be hidden. The clear-filter icon in the slicer header removes that slicer’s selection and restores its unfiltered state. Clearing one slicer does not necessarily clear filters applied elsewhere in the workbook.

For example, imagine a sales table with columns for Date, Region, Product, and Revenue. A Region slicer set to East and a Product slicer set to Printer narrow the visible records to sales that meet both conditions. In a PivotTable, the same choices filter the calculation, so the displayed revenue total reflects only the matching records. Slicers combine as filters; selecting East in one slicer and Printer in another does not mean either condition can be ignored.

Add a slicer to an Excel table

A table slicer is a straightforward way to make a list of records easier to explore. First, the data should be organized as a rectangular range with one header row and no completely blank rows or columns dividing the range. Convert it to an Excel table if it is not already one.

Select a cell in the data range and choose Insert > Table. Confirm the range and whether the table has headers, then select OK.
Click inside the new table. On the Table Design tab, choose Insert Slicer.
In the Insert Slicers dialog, check one or more column names, such as Region or Product, and select OK.
Move the slicer into position. Click a button to filter the table, or use the slicer’s clear-filter icon to remove its selection.

In Microsoft 365 for Windows, Table Design > Insert Slicer is the usual route when a table cell is selected. If you do not see the Table Design tab, check that the active cell is actually inside an Excel table, not just a formatted range. A normal range must be converted to a table before you can add a table slicer.

Add a slicer to a PivotTable

A PivotTable slicer filters a field in a summary without requiring the reader to open the field’s dropdown menu. Select a cell in the PivotTable, then choose PivotTable Analyze > Insert Slicer. Select the fields you want to control and choose OK. Excel adds a separate slicer for each selected field.

For example, a PivotTable that summarizes revenue by month and product can have a Region slicer. Selecting West updates the summary to show the West region’s results. If the PivotTable has a related PivotChart, that chart can update with the same selection. A slicer does not automatically change the underlying source records; it filters the PivotTable’s view and calculations.

Excel for Mac has slicers for tables and PivotTables as well, though ribbon layout and command placement can vary by release. Select the table or PivotTable first and look for Insert Slicer on the contextual table or PivotTable ribbon tab. Excel for the web can display and interact with many existing slicers, but desktop Excel is the dependable choice when you need to create or configure a workbook feature and do not see the relevant command in your web version.

Choose fields and arrange slicers well

A slicer is most helpful when its field has a manageable number of clear, meaningful values. Region, department, status, and product category are common choices. A field with hundreds or thousands of unique customer names can make a slicer unwieldy; a search box in a standard filter menu or a different report design may be more practical.

Use short, recognizable field values so the buttons are easy to scan.
Prefer a few useful slicers over one control for every column. Too many controls can crowd a dashboard and make it unclear which filters matter.
Place related slicers near the report they control, and leave room for the buttons to expand if the workbook gains new values.
For date ranges in a PivotTable, consider a Timeline rather than a slicer with a long list of individual dates. A Timeline is a separate date-filter control for PivotTables.

When a slicer is selected, Excel displays a contextual Slicer tab. Its commands include style and layout options; available settings depend on the slicer and Excel version. You can change the number of button columns, adjust button dimensions, and apply a built-in style to make the control fit the report. Resizing the slicer object can also reveal more buttons at once, but it does not change which records are included.

Connect one slicer to multiple PivotTables

A single PivotTable slicer can sometimes control several PivotTables, which is useful when a dashboard contains multiple summaries of the same data. Select the slicer, open the Slicer tab, and choose Report Connections or PivotTable Connections, depending on the ribbon label. Then select the PivotTables that should respond.

The important limitation is that the PivotTables generally need to share a compatible data source and PivotTable cache, or use the same Data Model setup. If a PivotTable is missing from the connections list, it may not share the required source or cache. Similar-looking PivotTables are not automatically compatible just because their fields have the same names. A slicer attached to an Excel table also cannot be connected to PivotTables through the PivotTable Report Connections command; table slicers and PivotTable slicers have different connection behavior.

Before distributing a dashboard, test each slicer against every report it is meant to control. A slicer can appear to work while leaving a second PivotTable unchanged if that report was not connected. Clear the slicer and test a different selection to confirm that the relevant summaries and charts all respond.

Slicers compared with filters and Timelines

Standard column filters are compact and available for ordinary ranges and tables. They are often the better choice for detailed data-cleaning tasks or for fields with many unique entries. A slicer takes more worksheet space, but it makes the active choices visible and provides large, clickable controls that suit an audience-facing report.

A Timeline is designed for date fields in PivotTables. Rather than presenting a button for every date, it lets a reader filter by a period such as a year, quarter, month, or day, depending on the selected scale and available dates. It is not simply a date-formatted slicer: it is a distinct PivotTable filtering tool. For a table’s date column, use the table’s regular filter or a date slicer where supported; do not assume that a PivotTable Timeline will control an ordinary table.

Slicers are also different from form controls such as dropdown lists. A dropdown can be useful when a worksheet uses a selection in formulas or other custom logic, but it does not automatically filter an Excel table or PivotTable. If the goal is direct, visible filtering of a supported data source, a slicer is usually the more direct tool.

Common slicer problems

Insert Slicer is unavailable: Select a cell inside an actual Excel table or PivotTable. A plain range, chart, or blank cell does not provide the same contextual command.
A new value is missing: Check that the value is present in the table or PivotTable source. For a PivotTable, refresh it after changing the source data. Also check whether the slicer is set to hide items with no data.
One PivotTable does not respond: Select the slicer and inspect Report Connections or PivotTable Connections. Confirm that the target PivotTable is listed and checked, and that the reports use a compatible source or cache.
The slicer is crowded: Resize it, increase its button-column count, or choose a field with fewer distinct values. A standard filter may be a better fit for a very long list.
The report looks filtered after a selection: Use the clear-filter icon on the relevant slicer. Check other slicers and standard field filters too; each can apply its own condition.

If an expected value is still absent, verify the source field for extra spaces, inconsistent spelling, or blanks. For instance, East and East followed by a space can be treated as different text values. Cleaning the source data and refreshing a PivotTable can resolve what looks like a slicer error but is actually a data-quality issue.

Frequently Asked Questions

What is a slicer in Microsoft Excel?
A slicer is a visual filter made of buttons. It filters an Excel table or PivotTable by one or more values in a selected field, and it can also control connected PivotTables.

Can I add a slicer to any Excel range?
No. For a table slicer, convert the range to an Excel table first. For a PivotTable slicer, select a PivotTable. A slicer is not a general-purpose filter for every arbitrary range on a worksheet.

How do I select more than one slicer item?
Use the slicer’s Multi-Select control if it is shown, then click the desired buttons. You can also turn off Multi-Select and use the supported modifier-click behavior for your Excel version. Click the clear-filter icon to remove the selection.

Can one slicer filter multiple PivotTables?
Yes, when the PivotTables are compatible with the slicer’s data source or cache. Select the slicer, open Report Connections or PivotTable Connections, and check the reports to connect. If a report is not listed, its source setup may not be compatible.

How do I remove a slicer?
Click the slicer’s outer border to select the object, then press Delete. This removes the slicer, not the underlying table or PivotTable data. Clearing the filter is different: it keeps the slicer and resets its selection.

Do slicers work in Excel for the web?
Excel for the web supports interaction with many slicers in workbooks, but available authoring and configuration commands can differ from desktop Excel. If you cannot create or adjust a slicer in the browser, open the workbook in the Microsoft 365 desktop app and use the table or PivotTable ribbon commands.

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.