Excel Slicer Tool: How to Add, Use, and Customize It

How-to basics · Updated November 21, 2026

The Excel slicer tool is a visual filter: it adds clickable buttons that let you show selected categories in an Excel table or PivotTable. To add one in Microsoft 365 for Windows, click inside the table or PivotTable, choose the relevant Insert Slicer command on the ribbon, select one or more fields, and click OK.

What an Excel slicer is

A slicer is a small on-sheet control made up of labeled buttons. Each button represents a value in a field, such as a product, salesperson, region, or year. Clicking a button filters the connected table or PivotTable to show matching records or results. Unlike a dropdown filter tucked into a column heading, a slicer keeps the available choices visible on the worksheet.

Slicers are useful when a workbook is meant to be explored by someone who may not know Excel’s filter menus. A reader can click West, for example, to view western-region sales, then click a product button to narrow the results further. The slicer makes the active selection apparent and usually offers a clear-filter control so the user can return to an unfiltered view.

A slicer is not a new copy of the data, a formula, or a chart. It changes which records a supported table or PivotTable displays; the source records remain in the workbook. A PivotChart connected to a PivotTable can reflect that PivotTable’s slicer filtering as well.

Where slicers work

In Excel, slicers are designed to filter Excel tables and PivotTables. They do not attach to an arbitrary block of cells just because the block has headings. If the data is an ordinary range, convert it to a table first using Insert > Table or Home > Format as Table, and confirm that the range has headers. A PivotTable can also be built from a range or table and then filtered with slicers.

A regular table slicer filters rows in that one table. PivotTable slicers filter a PivotTable and can sometimes control other PivotTables that share a compatible data source or PivotCache. That distinction matters in reports: adding a slicer to a table does not make it a general-purpose control for every chart and table on the sheet.

Dates can be filtered with a slicer when treated as date categories, but Excel also has a separate Timeline control for PivotTables. A Timeline gives date-oriented ranges such as months, quarters, or years. It is often more convenient than selecting many individual date buttons, but it is not the same feature as a standard slicer.

How to add a slicer to a table

  1. Click a cell inside the Excel table. If the data is not already a table, select it and choose Insert > Table; make sure the header option is correct.
  2. On the ribbon, choose Table Design > Insert Slicer. The Table Design tab appears when a table cell is selected.
  3. In the Insert Slicers window, check the column or columns you want to filter by, such as Region and Product, then select OK.
  4. Move and resize the slicer, then click its buttons to filter the table. Use its clear-filter icon to remove the slicer’s selection.

For example, imagine a table with Order Date, Region, Product, and Sales columns. A Region slicer can show only East records, while a Product slicer can further narrow that view to a particular item. Multiple slicers work together: choosing East and a product means rows must satisfy both selections. Within one slicer, selecting several values means the table can show records matching any of those selected values.

How to add a slicer to a PivotTable

Click inside the PivotTable and choose PivotTable Analyze > Insert Slicer. Select the fields you want, then click OK. Excel inserts one slicer for each selected field. For a date field, use PivotTable Analyze > Insert Timeline when you want a timeline-style date control and the PivotTable’s date field is eligible.

PivotTable field names and slicer labels come from the source data. Clear, consistent column headings make the controls easier to understand. If the source contains inconsistent categories such as North, N. and NORTH, Excel treats them as separate values; clean the source categories if you want one button for one real-world category.

To connect a PivotTable slicer to additional PivotTables, select the slicer and choose Slicer > Report Connections (the command may be labeled PivotTable Connections in some Excel builds). Check the PivotTables it should control. Only compatible PivotTables appear as available connections; sharing a field name alone does not guarantee that separately created PivotTables can share a slicer. If the desired report is absent, check whether the PivotTables use the same source and PivotCache or rebuild them from a common source.

Using and customizing slicers

Click a button to filter to that value. To select multiple values, use the slicer’s multi-select button if it is shown, or hold Ctrl while clicking additional buttons on Windows. The clear-filter icon, usually shown as a filter with a red X, removes the selection for that slicer. Clearing one slicer does not necessarily clear other slicers, so check all controls when a report still looks filtered.

With a slicer selected, the Slicer tab on the ribbon provides options for its appearance and layout. Depending on the Excel version and selected object, you can choose a style, change the number of button columns, adjust button height or width, set the slicer’s height and width, and control how items without data are displayed. You can also move it so it does not cover the data or chart it is meant to help explore.

  • Use a short, meaningful field label so readers know what the buttons filter.
  • Place related controls together and use consistent sizes and styles in a dashboard.
  • Give a slicer enough room to show useful labels; narrow buttons can make categories hard to distinguish.
  • Test the report with no selections and with several combinations before sharing it.

A slicer can be used alongside the table’s ordinary header filters. They are separate controls, however: a hidden filter in a column menu can restrict results even after the slicer is cleared. If the displayed rows seem incomplete, inspect both the slicers and the header dropdowns.

Slicers compared with ordinary filters and timelines

Ordinary column filters are compact and practical for occasional filtering or for a table with many fields. They appear in header dropdowns and can offer text, number, or date filtering options. Slicers take more worksheet space, but expose choices as visible buttons and make it easier for a report reader to see what has been selected.

Use a slicer when a workbook is being used as an interactive report, when a small set of categories needs to be easy to browse, or when you want a clear on-sheet filter for a PivotTable. Use a normal filter when space is limited or when users need more specialized filter conditions. Use a Timeline when the task is to choose date periods from a PivotTable. These tools can coexist, so the best choice depends on the reader and the layout, not on one control replacing every other filter.

Common problems and fixes

  • The Insert Slicer command is unavailable: Confirm that the selected cell belongs to an Excel table or PivotTable. A plain range must first become a table or be summarized in a PivotTable.
  • A slicer does not control another PivotTable: Select the slicer and inspect Report Connections or PivotTable Connections. If the other PivotTable is missing, it may not share a compatible source or cache.
  • Expected values are missing: The source data may not contain them, or the PivotTable may need refreshing. For a PivotTable, use PivotTable Analyze > Refresh; also check whether other filters exclude the values.
  • The table shows too few rows: Check other slicers and the table’s header filters. A cleared slicer does not clear a separate filter applied elsewhere.
  • New source categories do not appear: Check that new records are inside the table’s range. Excel tables generally expand when data is entered directly below them, but pasted or separately stored data may not be included. Refresh PivotTables after updating their source data.
  • The slicer is crowded or hard to read: Resize it, adjust its button columns, or use a shorter field label. Too many distinct values may make a slicer cumbersome; a normal filter or a better summary field may suit that field better.

When sharing a workbook, remember that a slicer changes the visible report state. It does not erase records, but the recipient may open the file with the last saved filter selections still active. Save the workbook in the view you want readers to see first, and make clear how they can clear filters.

Excel versions and platform notes

The instructions above use Microsoft 365 Excel for Windows. Current desktop Excel versions also support slicers, but ribbon placement and labels can differ slightly by release. On Mac, the same basic idea applies to supported tables and PivotTables, though ribbon organization and some options may differ. Excel for the web can display and interact with slicers in supported workbooks, while the ability to create or configure them can depend on the feature and current web-app support. If a command is missing, open the workbook in the desktop app and check the relevant table or PivotTable tab.

Slicers are worksheet objects, so they can be moved, resized, and formatted like other report elements. They do not require a special add-in. The underlying table or PivotTable still determines what data is available, and a slicer cannot repair an incorrect source range or inconsistent source values.

Frequently Asked Questions

What is the purpose of a slicer in Excel?
A slicer provides clickable, visible filters for an Excel table or PivotTable. It helps users narrow a report by categories without opening filter dropdowns.

Can one slicer control multiple PivotTables?
Yes, if the PivotTables are compatible with the slicer, commonly because they share a source and PivotCache. Select the slicer, open Report Connections or PivotTable Connections, and choose the PivotTables to control.

How do I clear a slicer filter?
Click the clear-filter icon on the slicer. If results remain restricted, clear other slicers too and check the table or PivotTable’s ordinary filters.

Can I add a slicer to a normal range?
Not directly. Convert the range into an Excel table, or create a PivotTable from the data, then insert a slicer for that supported object.

What is the difference between a slicer and a Timeline in Excel?
A slicer presents category values as buttons. A Timeline is a date-focused control for eligible PivotTables that lets users select date periods such as months, quarters, or years.

Do slicers delete or change source data?
No. They filter what the connected table or PivotTable displays. The source records remain in the workbook unless someone edits or deletes them separately.

Related

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.