A data slicer in Excel is a clickable on-sheet control that filters a table or PivotTable by the values you select. In Microsoft 365 for Windows, select the table or PivotTable, choose the appropriate Insert Slicer command, select the fields to filter, and click the slicer buttons to explore the data.
What an Excel slicer is
A slicer presents a field’s values as labeled buttons, rather than making you open a drop-down menu in a column heading. For example, a sales report might have buttons for North, South, East, and West. Click South and the connected report displays records for that region; select another button to change the filter.
Slicers are useful when a workbook is meant to be explored by someone who may not know Excel’s filter menus. They make the active filter visible on the worksheet, which can make a dashboard easier to understand and operate. A slicer can show its field name, and its buttons visibly indicate which values are selected.
A slicer is not a new copy of the data and does not change the underlying records. It applies a filter to a supported Excel table or PivotTable. Rows that do not match are hidden from the filtered view, not deleted. Clear the selection to return to the unfiltered view.
How slicers work
Each slicer is tied to one field, such as Region, Product, or Status. Its buttons represent values in that field. Selecting one or more values filters the connected object to show matching records. With several slicers, Excel applies their filters together: selecting South in a Region slicer and Furniture in a Category slicer shows records that meet both conditions.
Values that cannot produce a match under the current selections may appear unavailable or dimmed, depending on the object and Excel version. That is useful feedback: it shows that a combination of filters has no matching data. The slicer does not calculate a separate summary; a PivotTable updates its totals and layout in response to the filter, while a table simply shows matching rows.
One slicer can sometimes control multiple PivotTables, but the PivotTables must be compatible. In many workbooks, that means they share the same data source and PivotTable cache. A slicer for an ordinary Excel table does not automatically control a separate PivotTable, even if both use similar-looking data.
Add a slicer to a PivotTable
First, click a cell inside the PivotTable you want to filter. Excel displays the contextual PivotTable tabs when the PivotTable is selected. Then use these steps in Excel for Microsoft 365 on Windows:
- Select PivotTable Analyze > Insert Slicer.
- In the Insert Slicers dialog box, select the check box for each field you want to filter, such as Region or Category.
- Choose OK. Excel places the slicer on the worksheet.
- Click a button in the slicer to filter the PivotTable. Use Ctrl-click on Windows to select multiple individual items, or use the slicer’s multi-select control when available.
To remove the slicer’s filter, use the clear-filter icon near the upper-right corner of the slicer. The icon looks like a small filter with a red mark in many Excel versions. Clearing the filter does not remove the slicer; it returns that field to showing all available values.
If you cannot find PivotTable Analyze, confirm that a cell inside the PivotTable is selected. Clicking an ordinary worksheet cell hides the contextual tab. The exact contextual tab label can vary slightly across Excel versions, but Insert Slicer is the relevant command.
Add a slicer to an Excel table
Slicers can also filter a structured Excel table, without creating a PivotTable. The data must be formatted as a table rather than left as an ordinary range. Select a cell in the data and choose Insert > Table, confirm whether the table has headers, and select OK if it is not already a table.
With a cell in the table selected, choose Table Design > Insert Slicer, select one or more column names, and choose OK. Click a value in a slicer to filter the table rows. The table’s filter arrows and the slicer can both be used; they are different ways of filtering the same table.
This option works well for a detailed list that people need to browse, such as a task tracker or an inventory table. A table slicer does not create grouped totals or a summary layout. If the purpose is to compare sales totals by region or month, a PivotTable with slicers is usually a better fit.
Use, arrange, and format slicers
Click a slicer button to select one value. To select several values, use the slicer’s multi-select button if shown, then click the desired items. On Windows, Ctrl-click also selects or deselects individual items in many slicer interactions. To select a continuous range of buttons, click the first item and Shift-click the last. The available interaction can differ by platform and selection mode.
When a slicer is selected, the contextual Slicer tab provides layout and style controls. You can change the slicer’s visual style, set how many columns of buttons it uses, and adjust its height or width. A wider slicer or a multi-column layout can make long lists easier to scan, but very small buttons can be difficult to use. Drag the slicer’s border to move or resize it, taking care not to cover important report content.
Use a slicer caption that makes the field obvious, particularly if the underlying column heading is abbreviated or technical. For example, a caption such as Delivery status is clearer to a reader than a source heading like ShipStat. Keep the selected state visible and leave room for users to clear filters; otherwise, a report can appear incomplete without making the reason apparent.
Connect a slicer to more than one report
A slicer can control multiple PivotTables when those PivotTables are eligible to share it. Select the slicer, open the contextual Slicer tab, and choose Report Connections (called PivotTable Connections in some Excel versions). Select the PivotTables you want the slicer to control, then confirm.
If a PivotTable is missing from the connections list, the reports may not share a compatible source or cache. Two PivotTables can look alike and still have been created in a way that prevents them from sharing a slicer. In that case, consider rebuilding them from the same source and in a compatible way, or use separate slicers. Do not assume that a slicer connected to one report is filtering every chart or summary on the sheet.
PivotCharts based on a connected PivotTable respond to its slicer filters. Before presenting a dashboard, click each slicer and check that every intended chart and PivotTable changes. This simple check can reveal an unconnected report before another person relies on the displayed figures.
Slicers compared with filters and timelines
Column filter arrows are compact and familiar, and they work well for occasional filtering or when worksheet space is limited. Slicers take up more room but make important filter choices prominent. They are especially useful on a shared dashboard, where a visible control helps readers understand how to change the view.
A timeline is a related control designed for date fields in PivotTables. It lets users filter by periods such as years, quarters, months, or days, depending on the source and available settings. Use a regular slicer for categories such as department or product, and consider a timeline when readers need to adjust a date range. A timeline is not a general-purpose replacement for category slicers.
Neither a slicer nor a filter changes the source data itself. If you need to permanently remove records, edit the source data deliberately rather than treating a filtered view as a deletion. Likewise, a slicer is not a formula or a data-validation list: it is a visual control connected to a supported table or PivotTable.
Common slicer problems and fixes
- Insert Slicer is unavailable: Click inside an Excel table or PivotTable first. For an ordinary data range, create a table with Insert > Table before adding a table slicer.
- A new value is missing: Check that the source data contains the value and refresh the PivotTable. Use Data > Refresh All to refresh workbook connections and PivotTables when appropriate. A table slicer reflects values in the table, so check that new rows are actually included in the table.
- One report does not respond: Select the slicer and inspect Slicer > Report Connections or PivotTable Connections. Confirm that the report is connected and compatible.
- The slicer shows old or unexpected items: Refresh the PivotTable and review its source data. PivotTable settings can retain items that no longer appear in the source, so check the PivotTable’s data-retention options if stale items persist.
- The buttons are crowded: Resize the slicer, increase its number of columns, or give it more worksheet space. If there are too many distinct values for a convenient button list, a standard filter may be more practical.
Excel for the web and Excel for Mac have different interface details and may not offer every command or management option in the same place as Excel for Windows. If a particular slicer operation is missing, open the workbook in the desktop version of Excel for Windows and check the relevant contextual tab. Avoid assuming that a button or menu has the same name across every platform.
Frequently Asked Questions
Can I add a slicer to a normal range?
A slicer needs a supported Excel table or PivotTable. Convert a normal range to a table using Insert > Table, or build a PivotTable from the range, then add the slicer to that object.
Can one slicer control multiple PivotTables?
Yes, if the PivotTables are compatible and can share the slicer. Select the slicer and use Slicer > Report Connections or PivotTable Connections to choose the reports. If a report is not listed, check whether it shares the required source or cache.
How do I clear a slicer in Excel?
Click the clear-filter icon in the slicer. This removes the filter selection for that field while leaving the slicer on the sheet. Other slicers can still filter the report.
Can I select more than one slicer item?
Yes. Use the multi-select control when available, or use the selection behavior supported by your Excel version, such as Ctrl-clicking individual buttons on Windows. Multiple selections show records matching any of the chosen values in that slicer field.
Why does my slicer not show a new item?
For a PivotTable, refresh it after updating the source data and confirm the new rows are included in its source range or table. For a table slicer, verify that the added rows belong to the table. A slicer cannot offer a value that is absent from its connected data.
Related
- Change the Print Area in Excel: Steps and Fixes
- Excel Text to Columns: How to Split Data
- Excel Slicer: Change a Vertical List to Horizontal
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Compare Two Excel Sheets: Find Differences Step by StepTo compare two Excel sheets, use a cell-by-cell formula when corresponding cells line up, or match records by…
- Excel Goal Seek Precision: Accuracy and LimitsExcel Goal Seek can find an input value that makes a formula reach a target, but it does…
- 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 Freeze Panes: Why the Option Is UnavailableIf Excel will not let you freeze panes, first press Esc to exit cell-editing mode, then click a…
- Add a Slicer in Excel: How It Works and Common FixesTo add a slicer in Excel for Microsoft 365 on Windows, select a table and choose Table Design…
- Google Sheets ARRAYFORMULA: How It Works and When to Use ItIn Google Sheets, ARRAYFORMULA lets one formula calculate across a range and return results into multiple cells. With…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.