Slicer Command in Excel: How to Add and Use It

How-to basics · Updated November 21, 2026

In Excel for Microsoft 365 on Windows, select a PivotTable and choose PivotTable Analyze > Insert Slicer. For a regular Excel table, select a cell in the table and choose Table Design > Insert Slicer. Pick the field you want to filter, then select OK; the slicer appears as a set of clickable buttons.

Where to find the Slicer command

The command is contextual: Excel shows it after you select an object that supports slicers. Click inside a PivotTable to display its PivotTable Analyze tab, then look for Insert Slicer in the Filter group. Click inside a formatted Excel table to display Table Design, where Insert Slicer is available. The command is not a worksheet formula, and typing the word slicer into a cell will not add one.

If you cannot see the relevant contextual tab or command, first check that your selection is inside the table or PivotTable rather than beside it. A plain data range is not the same as an Excel table. To turn a range into a table, select a cell in the data and choose Insert > Table, confirm the range and whether it has headers, and then select a cell in the resulting table. You can also select the data and press Ctrl+T on Windows.

What an Excel slicer does

A slicer is a visual filter. It shows the distinct values in a chosen field as buttons, so you can filter data by selecting items rather than opening a column’s drop-down menu. For example, a sales table with Region, Product, and Month columns can have a Region slicer. Selecting West displays records for the West region; selecting East instead changes the visible records to East.

For a PivotTable, the slicer filters the PivotTable’s summarized results according to the source field. For a formatted Excel table, it filters the table rows themselves. Slicers are useful on dashboards because the active selection is visible, and a reader can often understand the current filter at a glance. They do not change the underlying cell values or delete excluded records: they control which records are currently shown.

Add a slicer to a PivotTable

  1. Click any cell inside the PivotTable. If you do not yet have one, select your source data and choose Insert > PivotTable, then create the report.
  2. Open PivotTable Analyze > Insert Slicer. In the dialog, Excel lists the available fields from the PivotTable’s source.
  3. Select the field or fields you want to filter by, such as Region or Product, and click OK.
  4. Move and resize the slicer so it is easy to use. Click a button to filter the PivotTable, or use the slicer’s clear-filter control to remove its selection.

Choosing more than one field in the dialog creates a separate slicer for each field. For instance, a Region slicer and a Product slicer can be used together: choosing West and a particular product shows results that meet both selections. The field must be present in the PivotTable’s source data. If you have added a new source column since building the PivotTable, update the source or recreate the PivotTable before expecting that field to appear.

Add a slicer to a formatted table

Slicers are not limited to PivotTables. They can also filter an Excel table, which is handy when you want interactive controls for a detailed list rather than a summary. Select a cell in the table, choose Table Design > Insert Slicer, select one or more column names, and click OK. Selecting a value in the resulting slicer filters the table to matching rows.

For example, an inventory table might contain Category, Supplier, and In Stock columns. Add a Category slicer to show only one category, or use Supplier as a second slicer to narrow the visible rows further. Slicers for tables work with the table’s columns; they do not automatically control a separate PivotTable elsewhere in the workbook. To control PivotTables, use a slicer connected to compatible PivotTables instead.

Use slicer buttons and clear selections

Click a slicer button to select that value. To select multiple values, use the slicer’s multi-select control if it is displayed, or hold Ctrl while clicking additional items on Windows. On a Mac, use Command while clicking where the version supports modifier-key selection. A selection of multiple values is an “or” filter within that field: selecting East and West shows records from either region. Selections across different slicers combine as “and”: East plus a specific product shows records that meet both conditions.

To remove a slicer’s filter, click the clear-filter icon in its header, generally shown as a funnel with a clear or red-mark indicator. This clears that slicer’s selection, not every filter in the workbook. A filtered column or another slicer may still limit what appears. If the slicer is too small to show all its buttons, scroll inside it or enlarge the object. Its buttons represent field values, so adding more distinct values to a field can make the slicer longer.

Connect one slicer to multiple PivotTables

A slicer can sometimes control several PivotTables at once, which is useful when a dashboard has multiple summaries of the same data. Select the slicer and use the contextual Slicer tab’s Report Connections command (the wording or location can differ in some Excel builds). Check the PivotTables you want the slicer to control and confirm.

Only compatible PivotTables appear in the connection list. They generally need to share the same PivotTable source or cache; PivotTables based on unrelated ranges may not be connectable through that slicer. If a report is missing from the list, compare how the PivotTables were created and whether they use the same underlying source. A slicer connected to one PivotTable does not automatically filter every PivotTable in the workbook.

Format and position a slicer

Select the slicer to display its contextual formatting options. You can choose a slicer style, change how many columns of buttons it uses, and adjust its height and width. More columns can make a long list more compact, while a wider slicer may show longer item names more clearly. Drag the object to position it near the report it controls, and leave enough room for its buttons and header.

For a clean dashboard, use field names readers recognize, align related slicers, and avoid covering worksheet cells that contain important information. A slicer’s visual style does not change its filtering logic. If you rename a source column or substantially change the source data, check that the slicer and its report still reflect the fields and values you intend to offer.

Slicer versus the regular Filter command

Both slicers and column filters restrict the visible data, but they suit different situations. A column filter is compact and lives in the header row. It is often convenient for a working list with many columns or for a quick one-off selection. A slicer takes up worksheet space, but puts common filter choices in a visible, clickable panel. That makes it a practical option for a report that other people will use repeatedly.

Neither option is a substitute for changing the source data. A filter hides nonmatching rows from the current view; it does not remove them. Also, a slicer does not calculate totals by itself. A PivotTable summarizes values, while its slicer changes which source records contribute to the displayed summary. For an ordinary table, a slicer simply filters which table rows are visible.

Common slicer problems and fixes

  • Insert Slicer is missing: Click inside the actual Excel table or PivotTable. If the source is only a range, convert it to a table with Insert > Table or create a PivotTable first.
  • A field is absent from the dialog: Check the source data’s column headers and confirm that the field belongs to the table or PivotTable source. Refresh or rebuild the report if the source structure changed.
  • The slicer shows old or unexpected items: A PivotTable may need refreshing after its source data changes. Choose Data > Refresh All, then review the slicer again. Also check for blank cells or inconsistent spellings in the source column; values such as North and north may be treated as separate items.
  • A slicer does not affect another report: Select the slicer and inspect Report Connections. The other PivotTable may not share a compatible source or cache, or it may simply not be checked.
  • Items seem to be missing: Another slicer or filter may be restricting the results. Clear the relevant slicer selections and inspect the table or PivotTable’s other filters.

When refreshing a PivotTable, confirm that its source range includes newly added rows. Excel tables usually expand when data is entered directly below them, but a PivotTable based on a fixed range may not include records added outside that range. A slicer cannot display or filter records that the report’s source does not contain.

Excel for Mac and Excel for the web

The Windows steps above describe Microsoft 365 desktop Excel. Excel for Mac also supports slicers, but ribbon organization and shortcut keys differ; select the table or PivotTable and look for the corresponding table-design or PivotTable analysis command. For multi-select, Command may replace Ctrl. If the command is not visible in your Mac build, check the contextual ribbon tabs after selecting the object.

Excel for the web can work with slicers, but available creation and editing controls can depend on the object and current web features. If you can select an existing slicer but cannot create or configure the one you need, open the workbook in the desktop app and use the ribbon steps above. A workbook containing slicers can still be shared, but recipients should use a version of Excel that supports the slicer features in that workbook.

Frequently Asked Questions

Is there a Slicer function or formula in Excel?
No. A slicer is an interactive worksheet object, not a cell formula or worksheet function. Add it through the contextual ribbon command for a table or PivotTable.

Can I add a slicer to a normal range?
Not directly. Convert the range to an Excel table using Insert > Table, or build a PivotTable from it, and then insert a slicer for that object.

Can one slicer filter two PivotTables?
Yes, when the PivotTables are compatible, typically because they share a source or cache. Select the slicer, open Report Connections, and select the reports to control.

How do I remove a slicer?
Select the slicer’s outer border and press Delete. This removes the slicer object, not the source data or the PivotTable. To keep the slicer but show all items, use its clear-filter control instead.

Why does my slicer not show newly added data?
Refresh the PivotTable and confirm its source includes the new rows. For a table, check that the new records are part of the table. If the source range does not include them, update the source before expecting the slicer to show their values.

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.