To add a slicer in Excel for Microsoft 365 on Windows, select a table and choose Table Design > Insert Slicer, or select a PivotTable and choose PivotTable Analyze > Insert Slicer. Pick the column or field to filter, select OK, then use the slicer buttons to show the records you want.
What an Excel slicer does
A slicer is a clickable, on-sheet filter control. Instead of opening a column’s filter menu and checking values in a list, you click visible buttons such as East, West, or Central. Excel filters the connected table or PivotTable to match your selection. The slicer also shows that a filter is active, which can make an interactive report easier for someone else to understand.
A slicer does not edit or delete the underlying data. With an Excel table, it hides rows that do not meet the selected criteria; clear the slicer to see them again. With a PivotTable, it filters the records used to calculate the summary, so the displayed totals and categories change. A slicer is not a chart, a formula, or an add-in, and it is not the same as a timeline. Timelines are a separate date-filtering control available for PivotTables.
Prepare the data first
Slicers need a supported object to control: an Excel table or a PivotTable. A plain block of cells is not enough. For a regular data list, check that each column has a clear header and that each row represents one record. For example, a sales list might have Order Date, Region, Product, and Amount columns. Avoid merged cells in the header row and blank header names, which make the data harder to turn into a useful table.
To make a table, click inside the data and use Insert > Table, or press Ctrl+T on Windows. Confirm the range and check My table has headers if the first row contains field names. On Mac, Command+T opens the table creation dialog in Excel; the contextual ribbon tab and button names can vary slightly by build. You can also create a PivotTable from a data list using Insert > PivotTable. Choose the object that suits the task: a table is useful for filtering individual records, while a PivotTable summarizes data into totals or counts.
- Use consistent values in a column. For example, avoid mixing North, N., and northern if they are meant to describe one region.
- Keep one type of information in each column. A Region column should contain regions, not notes or totals.
- Make sure the table or PivotTable includes the fields you want to filter. A slicer cannot filter on a field that is not part of its source.
Add a slicer to an Excel table
For a table, first click any cell within it. The Table Design contextual tab appears on the ribbon. Choose Table Design > Insert Slicer, select one or more column names in the dialog, and choose OK. Excel places a slicer for each selected column on the worksheet. For instance, selecting Region and Product gives you separate controls for narrowing the table by location and product.
Move a slicer by dragging its border, and resize it using its handles. If the Insert Slicer command is unavailable, check that the selected cell is inside a formatted Excel table rather than an ordinary range, and that you have selected the table itself. If the contextual tab is hidden because the ribbon is collapsed, expand the ribbon or click inside the table again. Excel for Mac has slicer support in current desktop versions; look for Insert Slicer on the contextual table ribbon, noting that tab labels and placement can differ by version.
Add a slicer to a PivotTable
Click inside the PivotTable, then choose PivotTable Analyze > Insert Slicer. In the dialog, check the fields you want to filter and select OK. A slicer for Region, for example, can limit a PivotTable’s sales totals to one or several regions. The PivotTable updates to reflect the selected items. This works whether the PivotTable shows sums, counts, or another supported summary of its source data.
To filter by a date field, you can insert a regular slicer if the date field is available as a PivotTable field. If you want a control organized around years, quarters, and months, use PivotTable Analyze > Insert Timeline when that command is available and the PivotTable has a usable date field. A timeline is related to slicers but is a distinct control, so it may not appear in the Insert Slicer field list as a special date option.
Use slicer buttons and clear a filter
Click a button to filter to that item. To choose several items, use the slicer’s multi-select control, usually shown near the top-right of the slicer, and then click the desired buttons. In many cases, holding Ctrl while clicking also adds or removes selections on Windows; on Mac, the equivalent modifier can differ, so the multi-select control is the clearest approach. The exact appearance depends on the Excel version and slicer style.
To remove the filter from one slicer, select its Clear Filter icon, typically a small filter symbol with a red mark near the slicer’s upper-right corner. This clears that control’s selection; it does not clear filters applied by other slicers or by a column’s ordinary filter menu. If you have a Region slicer and a Product slicer, clearing Region leaves the Product selection in place. That combination is useful for narrowing a report by several conditions at once.
Format and position slicers
Select the slicer to display its contextual Slicer tab. From there, you can choose a visual style, set the number of columns of buttons, change the slicer’s height or width, and adjust its settings. More columns can make a long list of categories take up less vertical space, though very narrow buttons can make labels difficult to read. Use a clear title or caption so readers know what the control filters.
For a tidy dashboard, align slicers with the report and leave enough room for long category names. A slicer can cover worksheet cells without changing their contents, but it may obscure data or charts underneath. You can move it to another worksheet, or use the size and position controls available in the slicer formatting options. Consider testing the layout at the zoom level and screen size people will use; a dashboard that fits on a large monitor may require scrolling on a laptop.
Connect one slicer to multiple PivotTables
A slicer can control more than one PivotTable when those PivotTables share a compatible data source or PivotTable cache. Select the slicer, then choose Slicer > Report Connections or PivotTable Connections, depending on the ribbon label. Check the PivotTables it should control and confirm. The selected PivotTables then respond together, which is useful when a dashboard has separate summaries for revenue, units, and orders but all are based on the same data.
If a PivotTable is missing from the connections list, the reports may have been created from different source ranges or caches. Having columns with identical names does not necessarily make two PivotTables share a cache. You may need to recreate the PivotTables from the same source or use a shared Data Model, depending on how the workbook is built. Table slicers and PivotTable slicers are not interchangeable connection controls: a slicer attached to a regular Excel table does not automatically filter unrelated PivotTables.
Refresh data and understand slicer limits
When records are added to an Excel table, the table generally expands as data is entered directly beneath it, and its slicer reflects the table’s categories. If the new records come from an external source or the table range did not expand, check the table range. PivotTables often need refreshing after their source data changes: click inside the PivotTable and choose PivotTable Analyze > Refresh, or use Data > Refresh All to update workbook connections and reports. Refreshing can add new items to a slicer, but it does not fix a source range that excludes the new rows.
Slicers are convenient, but they have practical limits. A column with hundreds or thousands of unique values can create a crowded control; a normal dropdown filter may be easier for such a field. A slicer also filters only its connected object or PivotTables, not every calculation or chart on a worksheet. Charts based on a filtered table may respond to hidden rows depending on their settings and data source, so confirm the behavior you want. For privacy or data protection, do not treat a slicer as access control: users may be able to reveal records by clearing filters or opening the source data.
Common slicer problems and fixes
- Insert Slicer is missing: Click inside an actual Excel table or PivotTable. A normal range does not expose the same contextual command. Convert a regular range to a table or create a PivotTable first.
- A category is absent: Check the source range and spelling in the relevant column. For PivotTables, refresh the report after changing source data. Values with extra spaces or different punctuation can appear as separate categories.
- The slicer filters only one report: For PivotTables, open Report Connections or PivotTable Connections and select the other compatible reports. If a report is not listed, check whether it shares the source or cache.
- The slicer looks too crowded: Resize it, increase the number of button columns, or choose a field with fewer distinct values. For a very long list, use the regular filter dropdown instead.
- The filter seems stuck: Clear the slicer selection and check for other active slicers, PivotTable filters, or worksheet filters. More than one filter can be active at once.
Frequently Asked Questions
Can I add a slicer to a normal cell range?
Not directly. Convert the range to an Excel table with Insert > Table, or create a PivotTable from it, and then insert the slicer from that object’s contextual ribbon.
Can I use more than one slicer at a time?
Yes. Add separate slicers for different fields, such as Region and Product. Their selections work together, so the result shows records that meet the active filters.
How do I remove a slicer without removing the data?
Select the slicer object and press Delete. This removes the control, not the underlying table records. If you only want to stop filtering temporarily, use its Clear Filter icon instead.
Can a slicer control multiple PivotTables?
Yes, if the PivotTables share a compatible source or cache. Select the slicer and use Report Connections or PivotTable Connections to choose the reports it should filter.
Does a slicer delete rows that do not match?
No. For a table, it temporarily filters which rows are displayed. For a PivotTable, it changes which source items contribute to the displayed summary. Clearing the filter restores the broader view.
Can I add slicers in Excel for the web?
Capabilities can differ from the desktop app and may depend on the workbook and current web version. If you cannot create or configure the slicer in a browser, open the workbook in desktop Excel, add it there, and then check whether the web version supports the interactions you need.
Related
- How to Create a Hyperlink in Excel: Links to Files and Pages
- How to Hyperlink in Excel on a Mac: Web, Files, and Cells
- Detect Circular References in Excel: Step-by-Step
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Data Entry: Enter and Manage Cell ValuesTo enter a value in Excel, select a cell, type a number, text, date, or formula, and press…
- Excel Shortcut Keys for Faster Work on Windows and MacExcel shortcut keys let you perform common tasks with the keyboard instead of navigating menus. In Excel for…
- Share an Outlook Calendar with Another User: Steps & TipsTo share an Outlook calendar, open Calendar, select Share or Share Calendar, enter the other person’s email address,…
- Excel Hide Specific Columns: Steps and TipsTo hide specific columns in Excel for Microsoft 365 on Windows, select the column letter or letters, then…
- How to Make a Digital Poster in PowerPoint That WorksTo make a digital poster in PowerPoint, set the slide to the proportions and size your destination needs,…
- How to Add Styles in Microsoft Word: A Practical GuideTo add a style in Microsoft Word, select the text and choose a style from Home > Styles;…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.