Excel Slicers: A Clear Guide to Filtering Data

In Excel for Microsoft 365 on Windows, a slicer is a set of clickable buttons that filters a table or PivotTable by selected values. Select the table and choose Table Design > Insert Slicer, or click inside a PivotTable and choose PivotTable Analyze > Insert Slicer; then select the fields you want to filter.

Slicers make a filter visible and easy to change, which is useful when you want to explore a report without repeatedly opening column menus. They do not change or delete the underlying records: they temporarily hide rows or categories that do not match the selection.

What an Excel slicer does

A slicer presents the values in a chosen field as buttons. For a sales table with a Region column, for example, a Region slicer might show East, North, South, and West. Clicking East filters the table to matching records. A slicer for Product can be added beside it, letting someone narrow the view to a region and a product at the same time.

Slicers are available for Excel tables and PivotTables. A table slicer filters the rows of its associated table. A PivotTable slicer filters that PivotTable and, when configured, other compatible PivotTables in the workbook. Slicers can also control related PivotCharts. Their exact effect depends on the object and connections they are attached to.

A slicer is not a separate copy of the data and is not a formula. The source records remain in the workbook, and clearing the slicer restores the unfiltered view. This makes slicers useful for interactive summaries, shared workbooks, and dashboards where a reader needs to see which filters are active.

How to add a slicer to an Excel table

First, make sure the data is arranged as a single rectangular range with one header row. Each column should have a descriptive heading, and there should not be blank rows or merged cells breaking up the range. Converting the range to an Excel table helps Excel manage its boundaries as records are added.

Click a cell in the data range. If it is not already a table, select Insert > Table, confirm the range, and indicate whether the table has headers.
Click any cell in the table, then choose Table Design > Insert Slicer.
In the Insert Slicers dialog, select the fields you want people to filter by, such as Region, Category, or Status, and select OK.
Move and resize the slicer so it does not cover the table. Click a button to apply a filter.

For a table, each slicer belongs to that table and filters its rows. If you add new records within the table, the table expands and the slicer can reflect the values after the data is updated. A slicer attached to one table does not automatically control a different table merely because both tables contain a column with the same heading.

How to add a slicer to a PivotTable

Click inside the PivotTable and choose PivotTable Analyze > Insert Slicer. Select one or more fields in the dialog, then select OK. Excel places a slicer on the worksheet for each selected field. For example, a PivotTable summarizing revenue by month can be filtered with slicers for salesperson and region.

A PivotTable slicer filters the PivotTable’s displayed results, not the source rows themselves. If source data changes, refresh the PivotTable so its summary and available slicer items are current. When practical, using an Excel table as the PivotTable source can make the source range expand as new rows are added, but the PivotTable still needs refreshing to update its results.

You can connect one slicer to multiple PivotTables when they are compatible. Select the slicer, then use the Slicer tab and choose Report Connections (called PivotTable Connections in some Excel versions). Select the PivotTables to control. A PivotTable may be missing from the list if it does not share a compatible PivotTable cache or data source; matching field names alone are not enough to guarantee a connection.

Using slicer buttons and clearing filters

Click a button to filter to that value. To select several values, use the slicer’s multi-select button if it is displayed, or hold Ctrl while clicking additional buttons on Windows. On Mac, use Command-click to add or remove selections when selecting multiple items. The available modifier behavior can depend on the Excel version and selection mode, so the multi-select control is the clearest option when present.

To remove a filter, select the clear-filter icon near the top-right corner of the slicer. It usually resembles a small filter with a red mark. Clearing one slicer removes only that slicer’s selection; filters in other slicers or column filter menus can remain active. This explains why a table may still look incomplete after one slicer has been cleared.

When multiple slicers are active, Excel applies their selections together. Selecting East in Region and Furniture in Category shows records meeting both conditions. Within a single slicer, selecting more than one button generally includes any of those selected values; selections across different slicers narrow the results in combination.

Formatting and arranging slicers

Select a slicer to display its contextual Slicer tab. The controls there let you apply a slicer style, adjust the number of button columns, set the button height or width, and change the slicer’s displayed heading. The Slicer Settings dialog can also control options such as whether the header appears and how items without data are shown.

For a compact dashboard, use a few meaningful fields rather than adding a slicer for every column. A slicer with many unique customer IDs or transaction numbers may take up substantial space and be difficult to use. Fields with a manageable number of categories—such as department, quarter, product family, or order status—are often more practical.

Consider alignment and reading order. Keep related slicers together, label them clearly, and leave enough room for long button names. If a slicer has many items, increasing its height or using multiple columns can reduce scrolling. Test the report at the size at which people will actually view it, especially if it will be printed or opened on a smaller screen.

Slicers, ordinary filters, and timelines

Excel’s column filter menus are a good choice for quick, occasional filtering. They are compact and available from a table or range header, but a reader may need to open a menu to discover which filters are active. Slicers use more worksheet space, but their visible buttons make report controls easier to notice and operate.

Use a slicer when users need to switch among a small or moderate set of categories and understand the current selection at a glance. Use ordinary filters when worksheet space is limited, the data has many distinct values, or the person working with the file is comfortable with Excel’s filter menus. Both methods can affect the same table, so check all active filters when results seem unexpectedly limited.

For PivotTables with date fields, a Timeline can provide a visual way to filter by years, quarters, months, or days. Click the PivotTable and choose PivotTable Analyze > Insert Timeline, then select a date field. Timelines are specifically for PivotTables; for a regular Excel table, use a slicer on a date-related field or the table’s date filters instead. A regular slicer can filter date values, but it may show individual dates rather than the continuous range controls provided by a Timeline.

Common problems and practical fixes

The Insert Slicer command is unavailable. Click inside an Excel table or PivotTable first. The relevant contextual tab and command appear only when the supported object is selected. A plain cell range may need to be converted to a table.
The slicer does not show a new category. For a PivotTable, refresh it using PivotTable Analyze > Refresh. Also check that the new record is included in the PivotTable’s source data and that the field value is spelled consistently.
A slicer will not control another PivotTable. Select the slicer and inspect Report Connections. The PivotTables must be compatible for a shared connection; they may need to be built from the same source or cache.
Some buttons are unavailable or show no results. Another slicer or filter may already exclude those values. Clear other filters to check whether the values return. PivotTable options can also affect how items without data appear.
The slicer covers worksheet content. Move or resize it, adjust its button columns, or place dashboard controls in a dedicated area. Avoid placing it over cells users need to edit.

If a workbook is opened in Excel for the web or an older Excel release, available slicer commands and editing options may differ. If a command is absent, open the workbook in the desktop version of Excel for Microsoft 365 and check whether the file is in a compatible format. On Mac, slicers are supported in current desktop Excel, but contextual tab names and some controls can differ slightly from Windows.

When slicers are a good choice

Slicers work especially well in reports designed for exploration rather than data entry. A manager could use Region and Quarter slicers to change the view of a sales PivotTable; a project tracker could use Status and Owner slicers to show open work for a team; an inventory table could use Category and Warehouse slicers to narrow a list of stock items.

They are less suitable when there are hundreds or thousands of distinct values, when the worksheet must remain extremely compact, or when filtering needs to follow complex rules that slicer buttons cannot express. In those cases, use table filters, a carefully designed PivotTable, or other reporting tools. A slicer is an interface for filtering, not a replacement for sound data organization or access permissions: hiding rows with a filter does not secure confidential information.

Frequently Asked Questions

Can I add a slicer to any Excel data?
No. In the standard desktop workflow, slicers are added to Excel tables and PivotTables, not to an arbitrary unformatted range. Convert a suitable range to a table first, or create a PivotTable from it.

Can one slicer filter two tables?
A table slicer is tied to its own table and cannot directly filter a separate table. PivotTable slicers can control multiple compatible PivotTables through Report Connections, but the PivotTables must support a shared connection.

Do slicers change or delete my data?
No. They filter what is displayed; they do not delete the underlying records. Clear the slicer filter to show the data again. Remember that filtering is not a way to protect private information in a workbook.

Why does my PivotTable slicer not include a new item?
Refresh the PivotTable and confirm the new record is inside its source range. If the PivotTable source is a fixed range that stops before the new row, update the source or use an Excel table as the source for easier expansion.

Can I use a slicer to filter dates by month?
Yes. A slicer can filter a date field, though its buttons may represent individual date values or grouped PivotTable fields. For a PivotTable, Insert Timeline offers dedicated controls for filtering date ranges by time period.

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.