Excel Slicers: How to Create and Use Them

How-to basics · Updated November 21, 2026

To create a slicer in Excel for Microsoft 365 on Windows, click inside a PivotTable and choose PivotTable Analyze > Insert Slicer, select the fields you want to filter, and click OK. For an Excel table, click inside the table and choose Table Design > Insert Slicer.

What an Excel slicer does

A slicer is a set of clickable buttons that filters a table or PivotTable. Each button represents a value from a field, such as a product category, region, salesperson, or year. Clicking a value shows records that match it and hides records that do not. Unlike a conventional drop-down filter, a slicer stays visible beside the data and makes the active selection easier to see.

For example, a sales report might have buttons for North, South, East, and West. Click North to show the North region, then click a product button to narrow the displayed results further. The report updates to reflect both selections. A clear-filter button on the slicer restores that field to showing all available values.

Slicers are controls for filtering, not charts or calculations. They do not change the underlying values in your source data, and they do not replace a PivotTable. They make it easier to explore a report without opening a filter menu for every field.

Prepare the source data

Before inserting a slicer, check that the source is organized as a proper dataset. Use one header row, give each column a distinct heading, and avoid blank rows or merged cells within the data. Each column should contain one kind of information—for example, dates in a Date column and region names in a Region column. Consistent data makes the field choices and filtering results easier to understand.

A slicer can filter an Excel table or a PivotTable, but the setup is different. A normal range of cells is not the same thing as an Excel table. To turn a range into a table, select a cell in the data and press Ctrl+T on Windows, confirm the range and whether it has headers, and select OK. The Mac equivalent is Command+T. You can also use Insert > Table.

If you are using a PivotTable, check that its source range includes the records you want to report. Adding new rows outside a fixed source range may mean the PivotTable does not include them after refresh. An Excel table used as the PivotTable source can expand when new rows are added, although you still need to refresh the PivotTable to update its results.

Create a slicer for a PivotTable

  1. Click any cell inside the PivotTable. This makes the PivotTable-specific ribbon tab available.
  2. Choose PivotTable Analyze > Insert Slicer. In some Excel builds, the tab or command may have a slightly different label, but Insert Slicer is the command to look for.
  3. In the Insert Slicers window, select the fields you want to use as filters, such as Region, Category, or Year, and click OK.
  4. Move and resize the slicer so it sits near the report without covering important cells.
  5. Click a button in the slicer to filter the PivotTable. To choose more than one value, use the slicer’s multi-select control if available, or hold Ctrl while selecting additional buttons.

It is often useful to add only the fields readers need to explore. A slicer for a field with a handful of values is usually clear and compact. A field containing hundreds of individual customer names, for instance, can produce a very large control. A report filter or a search-enabled slicer may be more practical for a long list.

Create a slicer for an Excel table

For a regular Excel table, click a cell in the table, open the Table Design tab, and choose Insert Slicer. Select one or more column headings and click OK. The slicer buttons then filter the rows of that table. If Insert Slicer is unavailable, confirm that the selected cell is inside an actual Excel table rather than an unformatted range.

Table slicers are useful for interactive lists, trackers, and small summaries where you want users to filter rows directly. For example, a task table with Owner, Status, and Priority columns can have slicers for Status and Priority. Clicking In progress and High priority displays rows that meet both selections.

A table slicer applies to its associated table; it does not automatically filter unrelated cells elsewhere on the worksheet. If you need one control to update several summaries, a PivotTable-based report with connected PivotTables is often a better design. You can also use a PivotTable and PivotChart when the goal is to summarize or visualize data rather than simply show matching records.

Use and arrange slicers

Click a slicer button to apply a filter. To select several values, click the multi-select icon at the top of the slicer and then select the values you want; in many cases, Ctrl-clicking additional buttons also adds selections. Click the clear-filter icon in the slicer header to remove that slicer’s selections. Clearing one slicer does not necessarily clear other slicers, so check each control when you want to return the entire report to an unfiltered state.

When a selection is active, the selected button is visually distinguished from unselected buttons. Depending on the slicer and its settings, values with no matching records may appear unavailable or may be hidden. This is not necessarily a data error: it can mean that the current selections in other slicers leave no matching records for that value.

To improve readability, select the slicer and use the Slicer tab to choose a style, adjust the number of button columns, or set the button height and width. A narrow slicer with one column suits a short list; several columns can make a longer list more compact. Keep labels readable and avoid using so many colors or styles that the filter controls compete with the report itself.

You can move or resize a slicer by dragging its edges. For more precise placement and behavior, right-click the slicer and choose Size and Properties or Slicer Settings, where available. If a slicer moves unexpectedly when rows or columns change, review its properties and choose whether it should move or resize with cells, or remain positioned independently.

Connect one slicer to multiple PivotTables

A slicer can control more than one PivotTable when those PivotTables are compatible. Typically, they need to share the same PivotTable cache or use the same data model, and the slicer field must exist in a usable form in each report. Two PivotTables that look alike are not automatically connected just because they display similar data.

To check connections, select the slicer and look for Report Connections on the Slicer tab. In some versions or contexts, the command may be named PivotTable Connections. Select the PivotTables that the slicer should control and confirm the choice. If a PivotTable is missing from the list, it may use a different source or cache; rebuilding it from the same source or data model may be necessary.

This feature is helpful for dashboards with several views of the same information—for example, a sales PivotTable and a sales PivotChart. A shared Region slicer can make both views respond to the same selection. Test each connection after setting it up, especially when a dashboard contains several PivotTables, because a slicer may update only a subset of the objects a reader expects.

Slicers versus ordinary filters and timelines

Column filter arrows are compact and work well for detailed tables or occasional filtering. Slicers are more visible and easier for another person to use in a dashboard, but they take up worksheet space. Neither option is universally better: use a slicer when the filter should be prominent and interactive, and use standard filters when the dataset is large or screen space is limited.

For date-based PivotTable reports, a Timeline offers a visual way to filter by periods such as years, quarters, months, or days. It is designed for date fields, while a slicer is the more general control for categories and other fields. Timelines are associated with PivotTables and are not a substitute for a slicer on an ordinary Excel table.

Some users expect a slicer to act like a dashboard-wide filter for every chart or formula on a sheet. It does not do that by default. It filters its associated table or connected PivotTables. For other kinds of interactive calculations, options include PivotTables, ordinary filters, or formulas designed to respond to selected criteria.

Common problems and fixes

  • Insert Slicer is missing: For a PivotTable, click inside the PivotTable first. For a table, click inside the table and verify that it is an Excel table, not just a formatted cell range.
  • A new value does not appear: Check that the source includes the new row. If the data feeds a PivotTable, refresh it using PivotTable Analyze > Refresh. Then check whether the source range or table includes the added record.
  • A slicer does not control another PivotTable: Select the slicer and inspect Report Connections or PivotTable Connections. The other PivotTable may use a different cache or data source.
  • The list contains an unexpected blank: Look for empty cells in the source field. For a PivotTable, refresh after correcting the source data; the blank item may remain until the report updates.
  • Buttons appear unavailable: Other active slicers or filters may have excluded all records for those values. Clear other filters to check whether the values become selectable.
  • The slicer covers report content: Move it to a dedicated dashboard area, resize it, or reduce its number of columns. Keep enough room for longer button labels.

Excel for the web and Excel for Mac may not show exactly the same ribbon layout or feature options as Excel for Microsoft 365 on Windows. If a workbook already contains slicers, the web or Mac version may allow interaction depending on the feature and current app support. For creating or managing a slicer when a command is missing, open the workbook in the Windows desktop app and use the steps above.

Frequently Asked Questions

Can I create a slicer without a PivotTable?
Yes. Convert the data range into an Excel table, click inside it, and choose Table Design > Insert Slicer. The slicer filters rows in that table.

How do I select multiple items in an Excel slicer?
Use the multi-select control in the slicer header, then click each item you want. Depending on the control and Excel build, you can also hold Ctrl while selecting additional buttons.

How do I remove a slicer filter?
Click the clear-filter icon in the slicer header. This clears that slicer’s selection; repeat for other slicers if you want to remove their filters too.

Why is my slicer not showing new data?
Make sure the new rows are included in the source. If the slicer belongs to a PivotTable, refresh the PivotTable, then confirm its source range includes the added records.

Can one slicer filter two PivotTables?
Yes, if the reports are compatible and share a PivotTable cache or data model. Select the slicer, open Report Connections or PivotTable Connections, and select the PivotTables to control.

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.