Slicers for Excel Columns: Filter a Table or PivotTable

Formulas & functions · Updated November 21, 2026

Yes. In Excel for Microsoft 365 on Windows, you can add a slicer for a column in an Excel table or PivotTable: select the table or PivotTable, choose the appropriate contextual ribbon tab, select Insert Slicer, and choose the column (field) to filter. A slicer is a set of clickable buttons that filters matching rows or PivotTable results without opening a drop-down filter menu.

What an Excel slicer does

A slicer is a visual filter for a field in a table or PivotTable. If a sales table has columns named Region, Product, and Order Date, a Region slicer can show buttons such as East, West, and Central. Clicking West filters the table to records whose Region value is West. In a PivotTable, the slicer filters the summarized results for the selected field instead.

The word “column” can be slightly misleading here. You do not insert a slicer into a worksheet column or use one to filter arbitrary cells in an ordinary range. You select a column in a structured Excel table or a field in a PivotTable. Excel uses the values in that field as the slicer’s choices. A slicer also does not rearrange or change the underlying data; it changes which records or summaries are currently displayed.

Unlike a column’s filter arrow, a slicer remains visible on the sheet and makes the active selection easy to see. This is useful for a report that other people need to explore, especially when they may not know how to use filter menus.

Add a slicer to an Excel table

First make sure the data is an Excel table. Click inside the data and look for the Table Design tab. If it is not a table yet, select the data and choose Insert > Table; confirm that the range and header setting are correct. A table should have one header row with a distinct name for each column.

  1. Click a cell inside the table.
  2. Choose Table Design > Insert Slicer.
  3. In the Insert Slicers dialog box, check the column or columns you want to filter, such as Region or Status, and select OK.
  4. Move or resize the slicer, then click one of its value buttons to filter the table.

Excel adds a separate slicer for each selected column. For example, a support log with Team, Priority, and Status columns could use three slicers so a reader can choose a team, then narrow the visible records to high-priority open cases. The table’s ordinary filter arrows remain available; slicers supplement them rather than replace them.

Add a slicer to a PivotTable

PivotTable slicers filter a PivotTable field, whether the field is displayed in the Rows, Columns, or Filters area. Click inside the PivotTable, then choose PivotTable Analyze > Insert Slicer. Select the fields to use and choose OK. Clicking a button filters the PivotTable’s summarized results according to that field.

For instance, a PivotTable that summarizes revenue by month and product can have a Region slicer. Selecting East leaves the monthly and product summaries for that region. The source data still contains all regions; the slicer changes the PivotTable view, not the source records. Refresh the PivotTable when its source data changes so the summary and available field items reflect the updated data.

Do not confuse a slicer with a report filter. A report filter is placed in the PivotTable’s Filters area and usually appears as a compact drop-down above the report. A slicer uses a visible button panel, which can make the current selection clearer and easier to change.

Choose which column to make a slicer

Good slicer fields have a manageable number of useful, consistent values. Category fields such as Region, Department, Product Type, or Status are often effective. They let readers narrow the report using labels they understand. A field with hundreds or thousands of unique customer names, transaction IDs, or exact timestamps may create an unwieldy slicer; a search-capable filter or a different report design may be more suitable.

Before creating one, check that the column’s values are clean. For example, “Open,” “open,” and “Open ” (with a trailing space) can be treated as separate items, and blanks may appear as an item too. Standardizing spelling, spacing, and blank-value handling in the source data makes the slicer easier to use. In a date field, individual dates can produce a long list; grouping dates in a PivotTable or using a Timeline for a PivotTable date field may be more practical.

  • Use a slicer when readers need to switch among a short list of meaningful categories.
  • Use a filter menu when the field has many unique values or the filter is needed only occasionally.
  • Consider a PivotTable Timeline for date filtering when the report is a PivotTable and the date field is suitable.
  • Keep the slicer’s label and position close to the report it controls so its purpose is obvious.

Use selections and clear a filter

Click a slicer button to select a value. To select more than one value, use the slicer’s Multi-Select button if it is shown, then click the desired items; Ctrl-clicking additional items is another option in Excel for Windows. A selected button indicates an active choice, and the filtered table or PivotTable updates accordingly. Available controls can vary slightly with the slicer and Excel version.

To remove that slicer’s filter, select its Clear Filter icon, usually shown as a small filter with a red mark at the top-right of the slicer. This clears the slicer selection; it does not delete the slicer or alter the data. If other slicers or filter settings are active, the displayed records may still be restricted by those other filters.

Slicers can be formatted and arranged to fit a dashboard. Select a slicer to display its contextual Slicer tab, where options include styles and settings such as the number of columns of buttons. A narrow, tall slicer can be changed to a wider panel with multiple button columns. Keep enough space for longer labels, and avoid covering the report cells that users need to read.

Connect a slicer to more than one report

A PivotTable slicer can control multiple PivotTables when those PivotTables share a compatible data source or PivotTable cache. Select the slicer, then choose the tab for the slicer and open Report Connections (called PivotTable Connections in some Excel versions). Check the PivotTables the slicer should control and confirm. If a PivotTable is missing from the list, it may not share the required cache or data model with the others.

This is useful for a dashboard with several PivotTables, such as sales by month and sales by product. A shared Region slicer can keep both views focused on the same region. Test each selection in every connected report: a slicer can be connected to some reports but not others, and a user may otherwise assume the whole dashboard is responding when one chart remains unchanged.

Table slicers and PivotTable slicers are not interchangeable connection controls. A slicer created for an Excel table filters that table; it does not automatically control unrelated PivotTables. If a dashboard needs coordinated PivotTable filtering, create the slicer from a PivotTable and use Report Connections where the PivotTables are compatible.

Common problems and fixes

If Insert Slicer is unavailable, first check what is selected. Click inside a formatted Excel table or PivotTable rather than a plain range, chart, or blank cell. For a plain range, create a table with Insert > Table before trying the table-slicer steps. For a PivotTable, click within its report so the PivotTable Analyze contextual tab appears.

If the slicer is present but a value is missing, check for filters already applied, blanks, inconsistent source values, or a PivotTable that has not been refreshed. A PivotTable may retain old items depending on its settings and source; refresh it and inspect the source field. If a new source-data category does not appear, confirm that the PivotTable source range or table includes the new records.

If clicking a slicer changes one PivotTable but not another, open Report Connections or PivotTable Connections and verify the desired reports are checked. If one is not listed, matching field names alone do not guarantee that the PivotTables can share a slicer: their underlying cache or data source compatibility matters. Rebuild the PivotTables from a common source if coordinated filtering is essential.

When a slicer seems to show no effect, check whether its buttons are already set to all items, whether another filter is restricting the data, and whether the target table or report is the one connected to it. Also inspect the underlying field values: a value that looks identical on screen can differ because of extra spaces or other hidden characters.

Excel for Mac and Excel for the web

The steps above are for Excel for Microsoft 365 on Windows. Excel for Mac also provides slicers for tables and PivotTables in supported current versions, but the ribbon layout and contextual tab names can differ. Select the table or PivotTable and look for the Insert Slicer command on its contextual tab. Connection and formatting controls may not be in exactly the same location as on Windows, so use the Mac ribbon’s contextual Slicer or PivotTable controls.

Excel for the web has a more limited feature set than the desktop app, and the commands available can depend on the workbook and current release. If you cannot create or manage the slicer you need in the browser, open the workbook in desktop Excel. A slicer already in a workbook may still be useful for interacting with a report, but do not assume every desktop authoring or connection option is available online.

Alternatives to a slicer

For a quick filter on a table, use the drop-down arrow in the column header. It offers sorting and filtering choices without taking up dashboard space. For PivotTables, the Filters area provides a compact report filter, while a Timeline can make date-range selection more convenient. These options are useful when a persistent panel of buttons would be distracting or a field has too many items.

For a report that needs several simultaneous conditions or more specialized logic, consider filtering the source table with its header filters or redesigning the report around a PivotTable. A slicer is best understood as an accessible interface to a supported field filter, not as a formula, a new data column, or a way to filter every unrelated range on a worksheet.

Frequently Asked Questions

Can I add a slicer to a normal Excel range?
Not directly. Convert the range to an Excel table with Insert > Table, then select a cell in the table and choose Table Design > Insert Slicer. A PivotTable also supports slicers through PivotTable Analyze > Insert Slicer.

Can one slicer filter multiple columns?
A slicer is based on one field, so it filters one column or PivotTable field. To filter by two fields, add two slicers, such as one for Region and one for Status.

Can one slicer control multiple PivotTables?
Yes, when the PivotTables are compatible and share the required data source or cache. Select the slicer and use Report Connections or PivotTable Connections to choose the reports it should control.

How do I show all rows again?
Click the slicer’s Clear Filter icon. If rows remain hidden, check for another slicer, a table header filter, or another PivotTable filter that is still active.

Why is a column not listed in Insert Slicer?
Check that you selected a table or PivotTable and that the column has a usable header. If the source is an ordinary range, convert it to a table first. In a PivotTable, the fields shown depend on its source and data model.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.