Excel Table Slicers: How to Add, Use, and Troubleshoot

How-to basics · Updated November 18, 2026

An Excel table slicer is a clickable filter panel for an Excel table: choose a button such as a region or product name, and the table displays only matching rows. In Excel for Microsoft 365 on Windows, select a cell in the table, choose Table Design > Insert Slicer, select the column or columns to filter, and click OK.

What an Excel table slicer does

A slicer turns a table’s ordinary column filter into a visible set of buttons. Instead of opening a small dropdown in a column heading and selecting checkboxes, you can click a labeled item in a separate on-sheet panel. This is useful when a worksheet is shared with people who may not know where to find the filter menus, or when you want the current view to be obvious.

For example, imagine a table of orders with columns for Date, Region, Product, and Salesperson. A Region slicer can show buttons for East, North, South, and West. Clicking East filters the table to orders whose Region value is East. The rows are filtered from view; the slicer does not delete them or alter their values.

A slicer is not a chart, a formula, or a separate copy of the data. It is a visual control attached to a table column. The filtered table remains the source data, and formulas that refer to the table continue to refer to the table rather than to a newly created filtered dataset.

How to insert a slicer for a table

First, make sure the data is an Excel table, not just a range with headings and formatting. Click inside the data and look for the Table Design tab. If it is not a table, select the data and use Insert > Table; confirm that the range is correct and that My table has headers is selected when appropriate.

  1. Click any cell inside the table. The contextual Table Design tab appears on the ribbon.
  2. Choose Table Design > Insert Slicer.
  3. In the Insert Slicers dialog box, select the check box beside each column you want to filter, such as Region or Product.
  4. Click OK. Excel places a slicer for each selected column on the worksheet.
  5. Drag a slicer to position it, and use its sizing handles to change its dimensions. Click a button to filter the table.

In Excel for Mac, select the table and use the Table tab’s Insert Slicer command; the ribbon labels and placement can differ slightly by release. Excel for the web can display and use slicers in supported workbooks, but the available creation and editing controls may differ from the desktop app. If you cannot find the command or need to configure a slicer, open the workbook in the current desktop version of Excel.

You can insert more than one slicer for the same table. For instance, a sales worksheet might have separate slicers for Region, Product, and Salesperson. Each one filters a different field, while the visible table shows records that satisfy the active selections together.

How slicer selections filter rows

By default, a slicer shows the distinct items in its connected table column as buttons. Clicking one item filters the table to rows with that value. Items that do not match the current filter combination may appear unavailable or visually muted. The slicer provides a quick indication of the field and selection controlling the view.

Selections within one slicer work as alternatives. If you select East and West in a Region slicer, the table includes rows from East or West. When you combine different slicers, their filters narrow the results together: selecting East or West and also selecting Product A means the table shows Product A rows from either of those regions. In filtering terms, the choices within one field are joined with OR, while different fields are joined with AND.

To select multiple items, use the slicer’s Multi-Select control if it is displayed, then click the desired buttons. You can also use the clear-filter icon at the top of the slicer to remove that slicer’s selection. The icon typically looks like a filter with a red cross. Clearing one slicer does not necessarily clear filters applied through other slicers or through the table’s column dropdowns.

Table slicers work alongside the filter dropdowns in the table headings. If a column-heading filter and a slicer both filter the same table, the resulting view reflects both. When the table appears to omit records unexpectedly, check each slicer and each heading dropdown, and clear any filters that should no longer apply.

Positioning and formatting slicers

A slicer is a worksheet object, so its location and size affect how easy the table is to use. Place controls near the table they filter, leave enough room for their labels, and avoid covering headings or data. For a dashboard-style sheet, a row of compact slicers above the table can make the filtering options easy to find.

Select a slicer to show its contextual Slicer tab. Its controls vary somewhat by Excel release, but generally let you choose a slicer style, set the number of button columns, and adjust the height and width of buttons or the overall object. Button columns control how the slicer’s choices are arranged inside the panel; they do not change the number of columns in the worksheet table. A narrow panel may wrap long labels or hide part of them, so check the result after resizing.

  • Choose a style with enough contrast to distinguish selected, unselected, and unavailable items.
  • Use a suitable number of button columns when a field has many choices, but keep labels readable.
  • Give the slicer a clear position and enough space so users can see its heading and all relevant buttons.
  • Keep several slicers aligned and consistently sized when they form one filter area.

Changing a slicer’s visual style does not change the data or its filtering logic. If you move or resize the table, review the slicer layout too; Excel does not treat slicers as part of the table’s cell grid.

Table slicers versus PivotTable slicers

Excel uses slicers with both ordinary tables and PivotTables, but the two connections are not interchangeable. A table slicer filters the particular Excel table for which it was created. It does not automatically control a separate table elsewhere in the workbook, even if that second table has similar headings or data.

PivotTable slicers are designed to filter PivotTables. Depending on how those PivotTables were created and whether they share a compatible data source or cache, the slicer’s Report Connections or PivotTable Connections options can let one slicer control multiple PivotTables. Do not assume that this connection feature will make a table slicer control unrelated tables; ordinary table slicers do not provide the same cross-report connection behavior.

Choose a table slicer when you want to interactively filter the detailed rows in a normal Excel table. Choose a PivotTable slicer when you are filtering a PivotTable summary or need supported connections among compatible PivotTables. A date timeline is a separate PivotTable-oriented control; a date-column slicer for an ordinary table is not a timeline with a continuous date-range slider.

Common problems and practical fixes

If Insert Slicer is unavailable, first check that the active cell is inside an actual Excel table and that the Table Design tab appears. A formatted range is not automatically a table. Also check whether the workbook is open in an app or file mode with limited editing support; using the desktop Excel app is a practical way to access the full table-slicer controls.

If a slicer does not show a value you expect, confirm that the value occurs in the connected table column and that no other filter is excluding its rows. Look for differences that are easy to miss, such as a trailing space, a spelling variation, or a blank cell. A slicer lists distinct field values, not every row as a separate choice. Repeated occurrences of East, for example, normally appear as one East button.

If newly added records do not appear in the filtered table, check that the records are actually part of the table. Typing immediately below a table often expands it, but pasted data or a gap between the table and new rows can leave records outside its boundary. Use the table’s resize controls or add the records directly to the table, then check the slicer again. Unlike a PivotTable, an ordinary table does not require a PivotTable refresh to recalculate its visible rows after a direct data edit.

For date and number fields, a table slicer can be less convenient than a dropdown filter. A date slicer presents date values as items rather than providing the PivotTable timeline’s range control; a numeric table slicer is not a slider for choosing a minimum and maximum. If the task is to filter dates between two endpoints or numbers above a threshold, use the column’s filter dropdown, or consider a PivotTable or other analysis setup that offers the needed control.

When another filter is a better choice

Slicers are most useful when the available choices are manageable and people need to change filters repeatedly. They occupy worksheet space, so adding a slicer for every column can make a sheet crowded. For a one-time filter, or for a column with hundreds of distinct values, the standard column dropdown may be more practical, especially when its search box can help locate an item.

Use the table’s heading filters for less prominent or more detailed conditions, such as a date range or a text rule. Use a PivotTable when the goal is to summarize records by category, calculate totals, or build a report that can use PivotTable slicers. A slicer improves navigation, but it does not replace a well-structured table, clear headings, or a suitable analysis method.

Frequently Asked Questions

Can one Excel table slicer filter multiple tables?
A slicer created for an ordinary Excel table filters that connected table, not other independent tables. If you need a control that filters multiple compatible PivotTables, use a PivotTable slicer and check its connection options.

Can I add more than one slicer to a table?
Yes. Insert a slicer for each useful table column, such as Region and Product. Their selections combine, so the table shows only records matching the active choices across those fields.

How do I clear a table slicer?
Click the clear-filter icon in the slicer, usually shown as a filter with a red cross. This clears that slicer’s selection; it does not necessarily remove filters set in other slicers or table heading dropdowns.

Does a table slicer delete or change rows?
No. It filters which table rows are visible. The underlying records remain in the table, and clearing the filter makes matching hidden rows visible again.

Can a table slicer filter a date range?
A date-column slicer for an ordinary table offers date items, not the continuous range slider provided by a PivotTable timeline. For a between-dates condition, use the table column’s filter dropdown or an appropriate PivotTable-based report.

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.