To reset an Excel slicer in Microsoft 365 for Windows, click the slicer and choose its Clear Filter button—the small funnel with a red X, usually at the slicer’s upper-right corner. You can also select the slicer and use Slicer > Clear Filter on the ribbon. This removes that slicer’s selection and shows all items available to it; it does not clear other slicers or every filter in the workbook.
Reset one slicer step by step
A slicer is a visual control for filtering an Excel Table or PivotTable. When one or more slicer buttons are selected, the connected table or PivotTable displays only records matching those selections. Clearing the slicer returns its own field to an unfiltered state.
- Click anywhere inside the slicer you want to reset. The slicer becomes active and its contextual Slicer tab appears on the ribbon.
- Click Clear Filter on the Slicer tab, or click the funnel-and-red-X icon in the slicer header.
- Check the connected table, chart, or PivotTable. Items previously excluded by that slicer should now be included again, subject to any other active filters.
For example, if a Region slicer is set to West, clearing it removes the West-only restriction. It does not remove an active Year selection from a separate slicer, nor does it undo a filter applied from a PivotTable field drop-down. The result can therefore still look filtered even though the slicer you cleared is reset.
What a slicer reset does—and does not do
Clear Filter removes the current choice from one slicer. It does not delete the slicer, alter the underlying source data, change the slicer’s size or position, or erase the field it controls. The slicer remains available for the next person to use. After clearing, the control generally shows that no specific item is selected, and all available items for that field are included.
That distinction matters because a report can have several independent filtering mechanisms. A PivotTable can also have report filters, row or column label filters, value filters, and manually hidden items. A Table can have ordinary AutoFilter selections in its column headers. Clearing a slicer does not clear those settings. If some records remain absent, inspect the other controls before concluding that the slicer did not reset.
Nor does clearing a slicer restore data that is missing from the source range, excluded from a PivotTable’s source, or unavailable because of another report condition. The reset only removes the slicer’s own filter. It is a display and analysis action, not a data-recovery command.
Table slicers and PivotTable slicers
Slicers can be attached to an Excel Table or a PivotTable, and the basic reset action is the same for both. A Table slicer filters rows in that table. A PivotTable slicer filters the PivotTable field it represents and can also affect other compatible PivotTables if they share a data source or PivotTable cache and have been connected to the slicer.
To identify the object behind a slicer, click it and inspect the contextual ribbon. For a PivotTable, select the PivotTable and use PivotTable Analyze > Insert Slicer to add one. For a Table, click inside the Table and use Table Design > Insert Slicer. These paths are useful when you need to verify what kind of report the control filters; they are not needed just to clear a selection.
A slicer connected to multiple PivotTables can make a reset seem broader than expected: clearing it removes that field’s restriction from every connected report. To review those connections, select the slicer and look for Report Connections on the Slicer tab. Depending on the workbook and Excel build, the command may be labeled PivotTable Connections. The list shows which compatible PivotTables the slicer controls; it is not a command for clearing the slicer.
Resetting several slicers or a whole report
Excel does not provide a single standard Clear Filter button on one slicer that automatically clears every unrelated slicer on the sheet. If a dashboard has Region, Year, and Product slicers, clear each one individually. A practical reset routine is to start with the slicer buttons, then check PivotTable report filters and Table header filters, and finally confirm that charts and summary totals display the expected overall view.
For a reusable dashboard, make the reset process visible to readers. You can add a short instruction such as Clear each slicer’s filter icon to show all items. Arrange slicers together and use consistent sizing so the reset icons are easy to find. If a workbook needs a one-click reset for many controls, that requires a separately designed solution, such as a macro or carefully configured report workflow; the normal slicer control resets only its own filter.
There is also a difference between resetting a report and restoring a saved starting view. Clearing filters creates an unfiltered state for the selected slicer, but it does not necessarily restore every layout, sort order, field arrangement, or other filter to the author’s preferred defaults. If the intended starting view includes a particular year or region, clearing all slicers may actually move away from that intended view.
When the reset button is missing or unavailable
If you cannot see the reset icon, first click inside the slicer. The icon is part of the slicer header, and it can be hard to spot if the control is narrow, the header is hidden, or the display is crowded. Selecting the slicer should also reveal its contextual Slicer tab, where the Clear Filter command is available in desktop Excel.
- The control is not selected: Click its border or a button in the slicer, then look for the contextual tab and command.
- The slicer is too small: Widen or enlarge it so the header icons are visible. You can also use the Slicer tab command after selecting it.
- No filter is active: The clear command may be disabled, or the icon may appear unavailable, because there is nothing to clear.
- You have selected a chart or PivotTable instead: Click the slicer itself. A chart selection shows chart tools, not slicer commands.
- The sheet is protected: Protection can restrict interaction or editing. Check the workbook’s protection settings or ask its owner for permission rather than trying to modify protected content.
If the Slicer tab does not appear even after clicking the control, confirm that the object really is a slicer and that the workbook is open in an Excel version that supports interacting with it. In Excel for Mac, selecting a slicer also reveals contextual slicer controls, though ribbon placement and labels can vary by version. Excel for the web has a different interface and may not expose every desktop editing command; if the reset control is unavailable there, open the workbook in the desktop app.
Why a filter can seem to return
Clearing a slicer changes its current selection, but it does not guarantee that the workbook will always reopen in that state. The workbook may be saved with a later selection, another user may apply a filter, or a refresh may change the items available in the source. If the slicer appears filtered again, check whether the file was saved after the reset and whether another filter or connected report is affecting the same results.
Refreshing a PivotTable updates its report from the source; it is not the same action as clearing a slicer. If a source value was renamed or removed, the slicer’s item list may change after refresh. A selected item that no longer exists can lead to confusing results, so clear the slicer and inspect the refreshed report. Also confirm that the PivotTable’s source range includes newly added records. A reset cannot include records that the PivotTable does not yet know about.
For a Table slicer, verify that the Table itself contains the rows you expect. For a PivotTable slicer, verify the data source and refresh status. If the displayed results still seem wrong after clearing all relevant controls, compare the report with the source data and check for filters on other fields. This method helps distinguish a slicer problem from a source-range or report-configuration issue.
Using slicers without losing your place
Slicers are useful precisely because their current state is visible. Selected buttons show the active categories, while other buttons may be dimmed or styled differently depending on the data and slicer settings. The multi-select control in the slicer header lets you select more than one item; in many cases, you can also use Ctrl-click to add or remove individual selections. Clear Filter is the quickest way back to all available items for that field when you no longer need the selection.
Before sharing a report, consider what an unfiltered view should mean. A slicer may show all items for its field while a separate Year slicer still limits the report to one year. In a dashboard with several PivotTables, a slicer might control only some of them. Explain those connections in the workbook so readers do not mistake a partial reset for a workbook-wide reset. A clear label and a saved default view make reports easier to interpret.
Frequently Asked Questions
How do I clear all slicers in Excel at once?
In the standard Excel interface, clear each slicer separately by selecting it and choosing Slicer > Clear Filter, or by clicking its clear-filter icon. Clearing one slicer does not automatically reset the others. Also check for ordinary PivotTable and Table filters if you need a fully unfiltered report.
Does clearing a slicer delete it?
No. Clear Filter removes the current selection only. The slicer stays on the worksheet and continues to control its connected Table or PivotTable. To remove the control itself, select the slicer and delete it; that is a different action and does not mean the source data has been deleted.
Why are some slicer buttons still grey after I reset it?
Other active filters or relationships between fields can affect which items have matching records. Clear the other slicers and report filters, then check the source data and connections. A grey or unavailable item does not by itself prove that the reset failed.
Can I reset a slicer with a keyboard shortcut?
Excel does not have a dedicated universal keyboard shortcut for clearing a slicer filter. Select the slicer and use the ribbon’s Clear Filter command, or click the icon in its header. Keyboard focus and available ribbon shortcuts can vary, so the visible command is the clearest method.
Will a slicer reset stay in place when I reopen the workbook?
It remains only if the workbook is saved in the desired state and no later change alters it. Clear the slicer, check other filters, save the workbook, and reopen it to confirm the intended starting view. A reset is not a permanent lock on the report’s filter state.
Related
- Excel Protected Sheet Unlock Online Free: Safe Methods
- Excel Protected Sheet Unlock Online: What Works Safely
- Excel Protected Sheets: How to Allow Sorting Safely
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Deleting Columns in Excel Not Working? Try These FixesIf deleting columns in Excel is not working, first select the column letter, then choose Home > Cells…
- Hyperlink Not Working in Outlook 365? Fixes to TryIf a hyperlink is not working in Outlook 365, first test it with Ctrl+click in classic Outlook, then…
- How to Find Invalid Formulas in Excel and Fix ErrorsTo find invalid formulas in Excel, select the worksheet and choose Home > Find & Select > Go…
- Excel Spill Error: Why It Keeps Happening and How to Fix ItYou keep getting a spill error in Excel when a formula is trying to return multiple results but…
- Excel Cell Reference Shows Formula Not Value? Fix ItIf your Excel cell shows the formula text (like =A1+B1) instead of the calculated result, the cell is…
- Excel Freeze Panes Wrong Selection? How to Fix ItIf Excel freezes the wrong rows or columns, first choose View > Freeze Panes > Unfreeze Panes, then…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.