Excel Slicer to Filter Data: How to Set Up and Use It

To filter data with an Excel slicer, select a table cell and choose Table Design > Insert Slicer, or select a PivotTable cell and choose PivotTable Analyze > Insert Slicer. Select the field you want to filter, choose OK, then click a value in the slicer; the table or PivotTable displays matching records.

What an Excel slicer does

A slicer is a panel of clickable buttons that filters a table or PivotTable by the values in one of its columns or fields. For example, a slicer for a Sales Region field might show buttons for North, South, East, and West. Clicking South filters the connected data to records for that region. Unlike a small drop-down arrow in a column heading, a slicer stays visible on the worksheet and makes the active filter easy to see.

Slicers are interactive controls, not separate copies of your data. They change which rows or PivotTable items are displayed; they do not delete the other records. A selected button indicates a value included in the filter, while unavailable or dimmed buttons can indicate values with no matching records under the current combination of filters.

In Excel for Microsoft 365 on Windows, slicers can filter Excel tables and PivotTables. They are not added directly to an ordinary, unformatted cell range. If your data is a range, convert it to a table first. A slicer is particularly useful on a dashboard or shared worksheet where people need to explore a few categories without opening column menus.

Add a slicer to an Excel table

Tables are a good fit when each row is a record and each column has a heading, such as a sales log with Date, Product, Region, and Amount columns. To make a slicer for a table in Excel for Microsoft 365 on Windows:

Click a cell inside the data. If it is not already a table, select the range and press Ctrl+T. Check that the range and header setting are correct, then select OK.
With a cell in the table selected, open Table Design > Insert Slicer.
In the dialog, select the checkbox beside each column you want to filter by, such as Region or Product, and choose OK.
Move or resize the slicer, then click one of its buttons to filter the table.

Each slicer represents one column. You can insert several—for example, one for Region and one for Product—and their filters work together. If you select South and Laptop, the table shows rows that satisfy both selections, not rows that match either one. This is useful for narrowing a large list, but it also means an overly restrictive combination can leave no visible records.

On a Mac, current Excel versions provide slicers for tables and PivotTables as well; the contextual tab names and ribbon layout can differ slightly from Windows. Look for the table-design or PivotTable analysis tab after selecting the relevant object. Slicer creation and selection are also distinct from filtering an ordinary range: convert a range to a table before inserting a table slicer.

Add a slicer to a PivotTable

A PivotTable summarizes data, so a slicer filters the PivotTable’s displayed categories and results rather than simply hiding matching source rows in a list. Click inside the PivotTable, choose PivotTable Analyze > Insert Slicer, select one or more fields, and choose OK. Click a slicer button to filter the report. You can add a slicer for a field that is already used in the PivotTable, or for another available source field.

For dates in a PivotTable, a Timeline can be more convenient than a regular slicer. Select the PivotTable and use PivotTable Analyze > Insert Timeline, then choose the date field. A Timeline offers a date-based control with options such as years, quarters, months, or days. It is a separate feature from a date-field slicer and is useful when users need to adjust a continuous time period.

If the source records change, a PivotTable may need to be refreshed before the report reflects those changes. Use PivotTable Analyze > Refresh, or the workbook’s refresh commands, as appropriate. A table slicer works directly with the table’s values, but it still depends on the source table being updated correctly. Check that new records are actually part of the table before troubleshooting the slicer.

Select, clear, and arrange slicer filters

Click a slicer button to select one 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 on Windows. The slicer’s clear-filter icon removes that slicer’s selection and restores all values for its field, subject to any other active filters. Clearing one slicer does not clear the selections in other slicers.

Slicers can be moved and resized like other worksheet objects. Select one to reveal its slicer tab, where you can change its style, button height or width, number of columns, and other layout settings. Multiple columns can make a slicer with many short labels more compact. A consistent style and alignment can make a dashboard easier to scan, but keep the buttons large enough to select without confusion.

For a clearer report, give each slicer a useful position and make its field obvious. If a dashboard contains several controls, leave enough space for labels and buttons to expand when the workbook opens on a different screen. A slicer only controls the object or objects to which it is connected; placing two slicers side by side does not automatically make them control every table on the sheet.

Connect slicers to reports and manage updates

A slicer created for a table filters that table. It does not automatically filter a second, separate table, even if both tables contain a column with the same name. For PivotTables, one slicer can control multiple reports when the PivotTables share a compatible data source or PivotTable cache. Select the slicer, open Slicer or Slicer Tools on the ribbon, and choose Report Connections (the command may be labeled PivotTable Connections in some versions). Select the PivotTables to connect.

If a PivotTable is missing from the connections list, it may not share the required source or cache with the slicer’s PivotTable. Matching field names alone do not guarantee a connection. For reports built from the same data, creating the PivotTables from a shared source can make coordinated filtering possible; otherwise, the reports may need to be rebuilt or designed differently.

When you add categories to the source, a table slicer can reflect values present in the table. PivotTable results and slicer items may require a refresh to show new source values. If removed values remain in a PivotTable slicer, review the PivotTable’s retention settings and refresh the report. Before sharing a workbook, test each slicer and connection after updating the source so the visible report corresponds to current data.

When to use a slicer instead of a filter menu

Both slicers and ordinary column filters help narrow data, but they suit different workflows. A filter drop-down is compact and convenient for occasional filtering, especially in a table with many columns. A slicer uses more worksheet space, but makes the filter visible and offers a direct, button-based way to change it. That visibility is valuable when someone else will use the workbook or when the filtered view is part of a dashboard.

Choose a slicer when users need to switch frequently among a small or moderate set of categories and should be able to see the active selection.
Choose a column filter when worksheet space is limited, filtering is occasional, or the field has too many distinct values for a practical button panel.
Choose a PivotTable Timeline when the report is a PivotTable and users need to adjust a date range by time period.
Use both thoughtfully when a report needs prominent controls for key categories and standard filters for less common fields.

A slicer is not a substitute for data cleanup. Values such as East, EAST, and East with a trailing space may appear as separate categories because the underlying text differs. Standardize categories in the source before building a polished report. Similarly, a slicer is not a security feature: filtering rows does not protect hidden data from someone who can access the workbook.

Common slicer problems and fixes

The Insert Slicer command is unavailable. Select a cell inside an Excel table or PivotTable first. A plain range does not support a slicer until it is converted to a table with Ctrl+T on Windows. If the selection is already a table, confirm that the contextual Table Design tab is active.

The slicer does not show a new category. Check that the new records are included in the table or PivotTable source. For a PivotTable, refresh it and confirm that the field’s source values include the category. A misspelling or extra space can create a different item from the value you expected.

The filter appears to do nothing. Check for other active slicers and column filters. Their combined criteria may already exclude the records you expect to see. Clear filters one at a time, then select a value again. For a PivotTable slicer, also check Report Connections to verify that the intended PivotTable is connected.

There are too many slicer buttons. A field with hundreds of unique values is often better handled with a column filter, a PivotTable filter, or a different report design. Slicers work best when their values are recognizable and the panel remains usable. If the categories are essential, consider placing the slicer on a dedicated report sheet and adjusting its layout.

Frequently Asked Questions

Can I add a slicer to a normal Excel range?
Not directly. Convert the range to an Excel table first, or create a PivotTable from the data and add a slicer to that. A slicer filters its connected table or PivotTable; it is not a general control for arbitrary cells.

How do I select multiple items in an Excel slicer?
Click the multi-select control on the slicer if available, then select the desired buttons. On Windows, you can also hold Ctrl as you click additional values. The selected values are included together in the filter.

How do I remove a slicer filter?
Use the clear-filter icon in the slicer header. This clears the selection for that slicer only. Other slicers and worksheet filters can remain active, so clear those separately if you want to see all records.

Can one slicer filter two PivotTables?
Yes, when the PivotTables are compatible and share the relevant source or cache. Select the slicer and use Report Connections or PivotTable Connections to choose the reports it controls. Separate tables with similar columns are not automatically connected.

Why is my slicer not showing new data?
Verify that the new rows are part of the source table or PivotTable range. Then refresh a PivotTable and check for differences in spelling, spaces, or data type. A slicer cannot display a category that is absent from its connected source.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

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

Spotted an error in this guide? Let us know.