To add a slicer to an Excel table in Microsoft 365 for Windows, select a cell in the table, choose Table Design > Insert Slicer, select the column or columns you want to filter, and click OK. The slicer then provides clickable buttons for filtering the table without opening each column’s filter menu.
What an Excel table slicer does
A slicer is a floating control made up of labeled buttons, usually one button for each distinct value in the selected table column. Clicking a button filters the table to show matching rows. For example, a slicer for a Region column might have buttons for East, North, South, and West. Selecting East hides rows from the other regions; it does not delete them or change the source data.
Slicers make filters easier to see and use, especially in a worksheet designed for other people. Rather than inspecting small dropdown arrows in the header row, readers can see the available categories and the current selection at a glance. A slicer can also be moved and resized, so it can sit beside a table as a simple interactive filter panel.
A table slicer is different from a chart or a formula. It applies a filter to the Excel table itself, so it works with the table’s normal rows and columns. The other table filters remain available too, and their conditions can work together: choosing East in a Region slicer and selecting 2026 in a Year slicer displays rows that satisfy both conditions.
Check the data before adding a slicer
Slicers attach to Excel tables, not to an arbitrary block of cells. A table has a header row and built-in filtering. If your data is currently a plain range, click within it and create a table first. On Windows, use Ctrl+T, confirm the proposed range, and check My table has headers if the first row contains column names. You can also use Insert > Table. On a Mac, use Insert > Table if the keyboard shortcut differs in your setup.
Before inserting the slicer, check that the table is structured clearly. Each column should have a useful heading, and each row should represent one record. A sales table, for instance, could have columns named Date, Product, Region, and Amount, with one transaction per row. A slicer on Product is much more useful when product names are consistent; entries such as Notebook, notebooks, and Notebook (large) will be treated as different values.
- Make sure the active cell is inside the table, not merely beside it.
- Use clear, distinct column names so the field choices in the dialog are easy to identify.
- Decide whether a column has a manageable number of categories. A slicer for a short list of departments is often practical; one for thousands of customer IDs may be cumbersome.
- Keep the table’s source data intact. Filtering hides nonmatching rows from view but does not remove them.
Steps to add a slicer in Excel for Windows
- Click any cell within the table. The contextual Table Design tab appears on the ribbon. If it does not appear, check that the selected cell is actually in an Excel table.
- Choose Table Design > Insert Slicer. Excel opens a list of the table’s column headings.
- Select the checkbox for each field you want to filter by. For example, select Region and Product to create two separate slicers.
- Click OK. Excel places the slicer or slicers on the worksheet, usually over or near the table.
- Drag a slicer by its border to move it, or drag a sizing handle to change its dimensions. Click a value button to filter the table.
If you want the slicer beside the data rather than on top of it, move it into a clear area of the sheet. You can also move it to another worksheet, but keep it in the same workbook as the table it filters. If the table is wide, placing slicers above it or on a dedicated dashboard sheet can make the layout easier to read.
On Excel for Mac, select a cell in the table and look for Insert Slicer on the contextual Table Design tab; ribbon placement and labels can differ by release. If the command is not available, check that you are using the desktop Excel application and that the selected data is a table. Excel for the web has a different ribbon and feature support can vary, so use the desktop app to create or adjust the slicer when the command is missing.
Use, select, and clear slicer filters
Click a button to show rows that match that value. To select more than one value in the same slicer, use its multi-select control if it is displayed, or hold Ctrl while clicking additional buttons on Windows. On a Mac, use the equivalent Command-based selection where supported by the current Excel build; you can also use the slicer’s multi-select button. A highlighted button indicates a selected value. The exact appearance depends on the chosen slicer style.
Selections within one slicer generally mean any of the selected values can match. For example, selecting East and West in the Region slicer shows records from either region. When you also select a Product value in another slicer, Excel applies both field filters, so the visible rows must match one of the selected regions and the selected product.
To remove a filter, click the clear-filter icon in the slicer header, commonly shown as a small funnel with a red mark. Clearing that slicer restores all values for its field, subject to any filters still applied elsewhere. You can also use the dropdown in a table header to adjust or clear that column’s filter. If a slicer appears to leave out records, check the header filters and any other slicers before assuming data is missing.
Format and arrange slicers
Select a slicer to reveal its contextual Slicer tab. There you can choose a visual style and adjust options such as the number of button columns, button height, and button width. More columns can make a long list shorter vertically, while a single column is often easier to scan for a short list. Use a style with enough contrast to make selected and unselected buttons distinguishable.
The slicer’s size should fit the labels. If a button shows only part of a long category name, widen the slicer or its buttons. If the slicer contains many values, increase its height or arrange buttons in columns; a scrollbar appears when all the values cannot fit in the available space. Avoid making the control so small that users cannot tell which values are selected.
For a compact report, consider which fields deserve a visible slicer. A slicer is most helpful for a field users will filter repeatedly and that has a reasonable number of choices. A column with a unique invoice number on every row is usually better handled with the regular header filter or Find, while a short list such as status values—Open, Pending, and Closed—works naturally as a slicer.
Table slicers versus PivotTable slicers
Both kinds of slicer offer clickable filtering, but they filter different objects. A slicer attached to an Excel table hides and shows the table’s individual source rows. A slicer attached to a PivotTable filters the summarized view produced by that PivotTable. If the goal is to inspect or share filtered records, use a table slicer. If the goal is to summarize sales by month, product, or region, a PivotTable slicer may be a better fit.
A PivotTable slicer can sometimes control more than one PivotTable through its Report Connections or PivotTable Connections options, provided the PivotTables share a compatible data source or pivot cache. That is not the same as connecting one table slicer to several unrelated Excel tables: a table slicer filters the table to which it is attached. If you need coordinated controls across multiple summaries, build the report around PivotTables with compatible connections rather than expecting a regular table slicer to control separate ranges.
There is also a practical difference in updates. A table slicer acts on the current table rows. A PivotTable is a summary that may need to be refreshed after its source data changes, depending on how it is configured. If a slicer is meant to control a PivotTable report, refresh the PivotTable when new source records do not appear in the summary.
Common problems and fixes
If Insert Slicer is missing or unavailable, first click a cell inside the table and confirm that Table Design appears. If the data is a plain range, convert it to a table. If the workbook or worksheet is protected, protection settings may prevent structural changes; follow the workbook owner’s instructions before changing protection. Also check whether you are working in a browser or a version of Excel with a different ribbon layout.
If the slicer is present but does not show a value you expect, check that the value exists in the table and that the table includes the relevant row. Look for spelling differences, extra spaces, or inconsistent categories. Also inspect other slicers and the table’s header filters: a second filter can exclude rows even when the first slicer looks correct. For a date or numeric column, remember that a table slicer presents distinct values as buttons; it is not a continuous date timeline or a numeric range slider.
If new rows are not included in the table, add them directly below the table or expand the table range. Excel tables normally extend as data is entered directly beneath them, but pasted data placed elsewhere may remain outside the table. A slicer cannot filter rows that are not part of its source table. When a worksheet becomes crowded, move the slicer, resize it, or keep the filtering controls on a separate report sheet.
When to choose a slicer or another filter
Use a slicer when discoverability matters: readers should be able to see the filter choices and change them with a click. It is particularly useful on a shared report sheet where users may not know Excel’s header dropdowns. It is also a clear way to expose two or three common filters without asking readers to open menus.
Use a standard column filter when the field has many distinct values, when you need text or number conditions such as begins with or greater than, or when worksheet space is limited. For dates, the table’s filter menu can be more convenient for date ranges than a slicer containing many individual dates. You can also use a PivotTable, a chart filter, or a formula-driven report when the task is summarizing data rather than filtering the original table rows. Choose the control that matches the job, rather than adding slicers for every column.
Frequently Asked Questions
Can you add a slicer to a normal range in Excel?
No. Convert the range to an Excel table first, then select a cell in that table and use Table Design > Insert Slicer. A PivotTable is another supported source for slicers, but a plain range by itself is not.
Can one slicer filter multiple Excel tables?
A slicer attached to a regular table filters that table, not several independent tables. For coordinated filtering across multiple PivotTables, check whether they can share a data source or pivot cache and use the PivotTable slicer’s connection options.
Does a slicer delete rows from my table?
No. It filters the display so nonmatching rows are hidden. Clear the slicer filter to show them again; the underlying records remain in the table.
Can I use a slicer for dates or numbers?
Yes, if the column is in the table, but a table slicer shows distinct values as buttons. For a date range or a condition such as amounts greater than a threshold, use the column’s filter menu instead.
Why is Insert Slicer grayed out?
The selected cell may not be in an Excel table, or you may be using an app or workbook state that does not allow the command. Confirm that Table Design appears after selecting a table cell, and check whether sheet protection or the web version is limiting available commands.
Related
- Conditional Formatting in Excel: Rules and Examples
- Excel Conditional Formatting Based on Text: How to Set It Up
- Compare Values Between Two Sheets in Excel
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Remove Checkboxes in Google Sheets Without Losing DataTo remove a checkbox in Google Sheets, select the cell or range, choose Data > Data validation, select…
- Protect Sheet and Workbook in Excel: What’s the Difference?In Excel for Microsoft 365 on Windows, use Review > Protect Sheet to restrict changes to a worksheet,…
- Excel Print Area: Set It, Adjust Pages, and Print ClearlyIn Excel for Microsoft 365 on Windows, select the cells you want to print, then choose Page Layout…
- Cash Flow Format in Excel: Build a Simple StatementA practical cash flow format in Excel uses one column for each month and separate sections for operating,…
- How to Set Out of Office in Outlook on the WebTo set an out-of-office reply in Outlook on the web, open Settings, find Automatic replies, turn them on,…
- Google Sheets Conditional Formatting for CheckboxesYes—Google Sheets can use conditional formatting to change a cell’s appearance when a checkbox is checked, but the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.