An Excel slicer is a set of clickable buttons that filters a table or PivotTable by the values in one or more fields. In Excel for Microsoft 365 on Windows, select the table or PivotTable, choose the relevant Design or Analyze tab, and click Insert Slicer to add one.
What a slicer does in Excel
A slicer makes filtering visible and interactive. Instead of opening a column’s filter menu and checking items in a list, you click labeled buttons such as North, South, or West. The connected table or PivotTable updates to show records matching your selection. A slicer also shows which values are selected, so it is easier to tell at a glance what is affecting the results.
For example, imagine a sales table with columns for Region, Product, and Revenue. A Region slicer can let a reader click West to see only western sales. Add a Product slicer and the reader can narrow the results further, such as to West and Laptops. Slicers change the displayed data; they do not rewrite the original values in the worksheet.
Each slicer is tied to a field, and its buttons correspond to values in that field. A slicer for Region filters by regions, while a slicer for Product filters by products. It is a dashboard control, not a formula or a separate data summary.
Which Excel data can use slicers?
You can add slicers to an Excel table or a PivotTable, but the setup and connections differ. A regular range must first be made into a table. Select a cell in the range and use Insert > Table, or press Ctrl+T on Windows. Check that the range includes the correct headers before confirming.
For a table, a slicer filters that table by one of its columns. It is useful when you want to explore a detailed list of records, such as orders or inventory. A table slicer does not automatically filter other tables or PivotTables elsewhere in the workbook.
A PivotTable slicer filters the PivotTable by a field included in its source data. It can also control compatible PivotTables that share the same underlying source or PivotTable cache. This is often useful in dashboards where several summaries need to respond to the same selection. Whether two PivotTables can share a slicer depends on how they were created; the Report Connections option shows eligible PivotTables.
Slicers are not the same as timelines. A timeline is a specialized control for filtering date fields in a PivotTable by periods such as years, quarters, or months. Use a regular slicer for categories and a timeline when date-based navigation is the main need.
How to insert a slicer
In Excel for Microsoft 365 on Windows, use the steps that match the data you want to filter:
- For a table: Click a cell inside the table. Open Table Design > Insert Slicer, select the column or columns to filter, and choose OK.
- For a PivotTable: Click inside the PivotTable. Open PivotTable Analyze > Insert Slicer, select the fields you want, and choose OK.
Excel places a slicer object on the worksheet. Drag it to position it, then use its sizing handles to change its dimensions. If the appropriate contextual tab is missing, first click inside the table or PivotTable; these tabs appear only when the relevant object is selected.
Choose fields that make sense as user-facing filters. Region, status, category, and salesperson are common choices. A field with hundreds or thousands of distinct values can produce an unwieldy slicer, so a text search or the column’s standard filter menu may be more practical. For date ranges in PivotTables, consider a timeline rather than a slicer containing many individual dates.
Excel for Mac has slicer support, though tab names and ribbon placement can vary by version. Select the table or PivotTable and look for the contextual Table Design or PivotTable Analyze options. Excel for the web can work with many existing slicers, but creation and configuration options may differ from desktop Excel. If an option is unavailable in the browser, open the workbook in the desktop app.
How to filter and clear selections
Click a slicer button to filter to that value. To select several values, turn on the slicer’s Multi-Select control, if shown, and click each required item. You can also use the usual modifier-key selection behavior supported by your version. The slicer’s clear-filter icon, commonly shown as a filter with a red mark, removes that slicer’s selection and restores all its values.
Selections from multiple slicers combine. If Region is set to West and Product is set to Laptops, the result must satisfy both conditions. In practical terms, the display shows laptop records from the West, not every record matching either selection. To broaden the results, clear one slicer or choose additional values within it.
A selected button can represent one value or part of a multi-selection. Buttons that are unavailable or appear dimmed may indicate that no matching data exists under the other active filters. The precise appearance depends on slicer settings and the data source. If you are unsure what is filtering the results, inspect every slicer on the sheet and clear them one at a time.
Connecting a slicer to multiple PivotTables
To control more than one PivotTable, select the slicer and open Slicer > Report Connections. In some Excel layouts, the command may be labeled PivotTable Connections. Check the PivotTables that should respond, then confirm. The list contains only PivotTables Excel considers compatible with that slicer.
If an expected PivotTable is absent, it may have been built from a different source range or a separate PivotTable cache. Rebuilding PivotTables from the same source or data model can make them compatible, but do not assume that matching column names alone are enough. Test the connections by clicking a slicer value and confirming that every intended summary changes.
This multi-PivotTable connection is particularly useful for a dashboard with, for example, a revenue summary, a product breakdown, and a regional comparison. A single Year or Region slicer can make those summaries respond together when their PivotTables support the same connection.
Formatting and arranging slicers
Select a slicer to display its contextual Slicer tab. You can choose a slicer style, adjust the number of button columns, and change the button height or width. More columns can make a long list compact, while a single column may be easier to scan. Resize the slicer so button labels are not cut off.
Use a clear title or nearby worksheet label to explain what the control filters. A slicer labeled Region is usually understandable, but a dashboard may benefit from an instruction such as Select a region. Keep related slicers aligned and leave enough space for the longest expected labels. If the workbook is shared, test the layout at the zoom level and screen size readers are likely to use.
To remove a slicer, select its border and press Delete. This removes the control, not the source data. If you only want to reset its selection, use the clear-filter icon instead. Deleting a slicer and clearing its filter are different actions.
Slicers compared with ordinary filters
Both slicers and column filter menus restrict which records are displayed, but they suit different workflows. The standard filter menu is compact and is convenient for occasional filtering. A slicer occupies worksheet space, but makes the available choices visible and makes interactive reports easier for another person to use.
- Use a slicer when readers need prominent, repeated controls on a worksheet or dashboard.
- Use a column filter when you want to filter a detailed table without adding visible controls to the sheet.
- Use a PivotTable timeline when readers need to navigate a PivotTable by date periods rather than select category values.
A slicer is not a substitute for cleaning or organizing source data. Inconsistent entries such as West, west, and Western can appear as separate choices. Standardize field values before building a report, and refresh PivotTables after changing their source data when necessary.
Common slicer problems
Insert Slicer is unavailable: Check that you selected a cell inside an Excel table or PivotTable. A plain range is not enough for a table slicer; convert it to a table first. If working in a browser or older Excel version, open the workbook in a supported desktop version and check for feature differences.
The slicer does not affect a chart or summary: A slicer only affects the table or PivotTable to which it is connected. For a PivotTable slicer, open Report Connections and check the intended PivotTables. A normal chart based on unrelated cells will not automatically become connected just because it appears next to the slicer.
New values are missing: For a table, check that the new records are actually part of the table and that the slicer is associated with the intended column. For a PivotTable, refresh it after adding source records, and confirm the source range includes them. A PivotTable may also retain old items in its cache, which can make its available labels confusing.
The slicer has too many buttons: Choose a field with fewer distinct values, make the slicer larger or add columns, or use a standard filter for a long list. For date-based PivotTable filtering, a timeline can be more convenient than a slicer containing every date.
The workbook looks different for another person: Check whether the recipient is using Excel for the web, Mac, or a desktop version with different feature support. Also ensure that filters are not already active in other slicers or table columns; more than one filter can narrow the visible results at once.
Frequently Asked Questions
Are slicers available in Excel for free?
Excel slicers are a feature of supported Excel versions, including Microsoft 365 desktop Excel. The exact options available depend on the app and version used to open the workbook. Excel for the web may not expose every creation or configuration command.
Can one slicer control a table and a PivotTable?
A table slicer filters its associated table, while a PivotTable slicer connects to compatible PivotTables. A table slicer does not generally act as a shared control for a separate PivotTable. Use PivotTable slicers and Report Connections when you need shared PivotTable filtering.
Can I select more than one slicer button?
Yes. Use the Multi-Select control when it appears, or use the selection method supported by your Excel version. Multiple selected values in one slicer include records matching those selected values, while selections in separate slicers narrow the results together.
Do slicers change or delete the original data?
No. A slicer filters what the connected table or PivotTable displays; it does not edit or delete the underlying records. Removing a slicer control also does not remove its source data.
Why can’t I connect my slicer to another PivotTable?
The PivotTable may use a different source or cache and therefore may not be compatible. Select the slicer and check Report Connections to see which PivotTables Excel allows it to control. Matching field names alone do not guarantee that a connection is possible.
Related
- Excel Protect Sheet: How to Lock Cells and Set Permissions
- Excel Protect Sheet: Allow Editing in Selected Cells
- Excel Heat Maps: How to Create, Format, and Read Them
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Add and Use Notes in a PowerPoint PresentationTo add notes in PowerPoint, open a slide in Normal view, select the Notes area below it, and…
- Microsoft Word: How to Add a Header and Page NumberIn Microsoft Word for Microsoft 365 on Windows, choose Insert > Header, select a layout, and type your…
- SUMIF Checkbox in Google Sheets: Sum Checked RowsIf your checkboxes are in A2:A20 and the values to add are in B2:B20, use =SUMIF(A2:A20,TRUE,B2:B20) to total…
- How to Set Up Out of Office in OutlookTo set up an out-of-office reply in Outlook, open Automatic Replies, switch them on, write your message, and—if…
- Excel: Copy Subtotal Rows Only Without Detail RowsYes. In Excel for Microsoft 365 on Windows, collapse the outline to level 2, select the range you…
- Excel Subscript Shortcut: Apply Subscript to Cell TextExcel does not have a single keyboard shortcut that directly turns text into subscript. In Excel for Microsoft…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.