Excel Slicer Tutorial: Add, Format, and Connect Filters

To add an Excel slicer, select a PivotTable and choose PivotTable Analyze > Insert Slicer, or select an Excel table and choose Table Design > Insert Slicer; then select the fields to filter. Click the buttons on the slicer to filter the data, and use the slicer’s clear-filter icon to restore the full view.

What an Excel slicer does

A slicer is a visual filter made of clickable buttons. Rather than opening a column’s drop-down menu and checking values in a list, you can see the available categories on the worksheet and select the ones you want. For example, a sales report might have slicers for Region, Product, and Year. Clicking West and Office Supplies can narrow the report to those records, while the PivotTable recalculates its totals.

Slicers filter the display and calculations; they do not delete rows from the source data or change the underlying values. They are available for Excel tables and PivotTables. A PivotChart linked to a PivotTable responds when that PivotTable is filtered by a slicer, which makes slicers useful for interactive dashboards. A slicer is not a general-purpose filter for any arbitrary range of cells.

Unlike a standard column filter, a slicer stays visible on the sheet. That makes the current selection easier to spot and gives report readers a straightforward way to explore the data without editing the source table.

Prepare the data first

Before adding a slicer, check that the source data has one clear header row, with a distinct heading for each column. Each row should represent one record, such as a sale or support ticket. Avoid merged cells, blank header names, and completely empty rows or columns inside the data range; these can make tables and PivotTables harder to build or refresh reliably.

For a regular data range, select a cell in the data and choose Insert > Table. Confirm the range and whether the table has headers, then select OK. Converting a range to a table gives it expanding boundaries as records are added, but a PivotTable based on the data still needs to be refreshed to include new records. A well-named table, set under Table Design > Table Name, is also easier to recognize later.

Think about the fields you want readers to filter. Slicers work best for categorical values such as region, department, status, or product type. A field with thousands of distinct customer IDs can produce a very large slicer that is awkward to use; a narrower category or a search-enabled filter may be a better choice.

Insert a slicer for a PivotTable

Click anywhere inside the PivotTable. If the PivotTable is not built yet, select the source data and choose Insert > PivotTable, then arrange fields in the PivotTable Fields pane.
On the ribbon, choose PivotTable Analyze > Insert Slicer. In some Excel layouts, the command may appear under the PivotTable Analyze tab with a slightly different spacing or ribbon arrangement.
In the Insert Slicers dialog, check the fields you want to use, such as Region and Product, and select OK. Excel places a separate slicer on the worksheet for each selected field.
Drag a slicer by its border to position it, and use its sizing handles to make the buttons fit. Click a value to filter the PivotTable.

For example, suppose the source has Date, Region, Product, and Sales columns, and the PivotTable summarizes Sales by Product. A Region slicer lets a reader switch between all regions, East, or West without changing the PivotTable layout. If the source includes dates and you want date-range controls, a Timeline is a related option: select the PivotTable and choose PivotTable Analyze > Insert Timeline, then select a date field. Timelines are specifically for date fields; they are not a substitute for ordinary text or category slicers.

Insert a slicer for an Excel table

To filter a table directly, click inside it and choose Table Design > Insert Slicer. Select one or more column names in the dialog and choose OK. The resulting slicer filters the table rows, while the table’s own column filter arrows remain available as well.

For example, a task table with Owner, Priority, and Status columns can have a Status slicer with buttons for Not Started, In Progress, and Complete. Selecting In Progress hides the other rows from view; it does not remove them. Clear the slicer selection to show the full table again.

Table slicers and PivotTable slicers serve related but different purposes. A table slicer filters that table; it does not automatically control a separate PivotTable built from the same source. To build a dashboard where one control filters several summaries, use PivotTables and connect a slicer to compatible PivotTables, as described below.

Use slicer buttons and clear selections

Click one button to filter to that item. To select multiple items, click the slicer’s Multi-Select button if it is shown, then click the desired values; in many slicers, holding Ctrl while clicking also adds or removes items. The exact interaction can vary with the Excel interface, so the visible Multi-Select control is the clearest option when available. Selected values are highlighted, while values with no matching records may appear dimmed or unavailable.

To remove a slicer’s filter, select the clear-filter icon in the slicer header, usually shown as a funnel with a red mark. This clears that slicer only; filters from other slicers or PivotTable fields can still restrict the results. To return a report to its original view, clear every active slicer and any additional filters that were applied through the PivotTable or table menus.

Several slicers can be used together. If a report has Region and Product slicers, selecting West and then a product narrows the results to records matching both selections. This is an intersection of filters, not a choice between them. If no records match the combination, the table or PivotTable may show no results.

Format and arrange slicers

Select a slicer to display its contextual Slicer tab. Use the slicer style gallery to change its colors, and adjust the button layout with options such as Columns, Button Height, and Button Width. Increasing the column count can make a long list shorter on the sheet, but narrow buttons may make labels harder to read. Resize the slicer to show enough buttons without crowding the report.

The Slicer tab also includes controls for the slicer’s caption and settings. A clear caption such as Filter by Region is more helpful than a field name that needs explanation. In the settings, you can often choose whether items with no data are shown, and you can change how the header or selection behavior appears. Available options can depend on whether the slicer belongs to a table or PivotTable.

For a clean dashboard, align slicers with the report and use consistent sizes and styles. Keep the slicers close to the charts or summaries they control, and leave enough space for longer category names. A slicer is an interactive control, so do not rely on color alone to communicate what it filters; use a descriptive caption or nearby label.

Connect one slicer to multiple PivotTables

A slicer can control more than one PivotTable when those PivotTables are compatible. Select the slicer, open the Slicer tab, and choose Report Connections or PivotTable Connections; the label can vary by Excel build and context. Check the PivotTables you want the slicer to filter, then select OK. Clicking a slicer button should now update all selected summaries.

If a PivotTable is missing from the connections list, the PivotTables may not share the same data source or PivotTable cache. This often happens when each PivotTable was created independently from separate ranges or sources. Rebuilding them from a common Excel table or using a shared data model may be necessary. Do not assume that matching column names alone makes PivotTables connectable.

Connections apply to PivotTables, not to every object on the sheet. A PivotChart connected to one of the selected PivotTables will reflect that PivotTable’s filtered results. A regular chart based on a separate range, or an unrelated table, will not automatically respond to the slicer. Check each report object’s data source if some visuals change and others do not.

Common problems and practical limits

The Insert Slicer command is unavailable: Click inside a supported Excel table or PivotTable first. A plain range alone does not provide the contextual slicer command.
New records do not appear in a PivotTable: Confirm that the source table includes them, then refresh the PivotTable. Use PivotTable Analyze > Refresh, or right-click the PivotTable and choose Refresh.
A slicer filters only one report: Use Report Connections or PivotTable Connections and check the other PivotTables. If they are absent from the list, investigate whether they share a compatible cache or data model.
The slicer shows too many buttons: Choose a field with fewer distinct values, make the slicer larger, or arrange the buttons in more columns. A slicer is not ideal for every high-cardinality field.
The report appears blank: Clear selections in each slicer and inspect other filters. Two individually valid selections can combine to produce no matching rows.

Excel for the web can be useful for viewing and interacting with workbooks, but the ribbon and available editing commands may differ from desktop Excel. For creating or configuring slicers, especially for a connected PivotTable dashboard, use Excel for Microsoft 365 on Windows if the needed command is not available in the web interface. On Mac, the same basic table and PivotTable concepts apply, but ribbon placement and some options can differ by version.

Slicers compared with other filters

Use a slicer when readers need visible, repeatable controls for a report. A standard filter drop-down is often quicker for occasional filtering or for columns with many distinct values; it takes less worksheet space but hides the current choices until opened. A PivotTable report filter puts a field above the PivotTable and can be compact, but it is less visual and typically presents one field at a time.

A Timeline is useful when the question is about periods of time, such as months or quarters, and the PivotTable contains a recognized date field. For detailed criteria, such as filtering dates by a specific condition or searching a long list, a regular filter may offer more practical control. These tools can coexist: choose the control that makes the report’s intended interaction clearest.

Frequently Asked Questions

Can I add a slicer to any Excel range?
No. A slicer can be added to an Excel table or PivotTable, not directly to an unformatted range. Convert the range to a table with Insert > Table, or create a PivotTable from it first.

Do slicers change or delete my source data?
No. A slicer filters what is displayed in a table or PivotTable. The underlying records remain in the source data, and clearing the filter brings the full view back.

Can one slicer control multiple PivotTables?
Yes, if the PivotTables are compatible and appear in the slicer’s Report Connections or PivotTable Connections list. If one is missing, check whether the PivotTables share a data source and cache or use a compatible data model.

Why can’t I see a slicer option for my data?
First click inside an Excel table or PivotTable. If the data is only a plain range, create a table or PivotTable; the contextual Insert Slicer command appears for supported objects.

How do I remove a slicer filter without deleting the slicer?
Click the clear-filter icon in the slicer header. That resets the selection while leaving the slicer on the worksheet for future filtering.

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.