Excel Remove Slicer: How to Delete or Clear One

How-to basics · Updated November 21, 2026

To remove a slicer in Excel for Microsoft 365 on Windows, click its outer border so the slicer object is selected, then press Delete. This removes the slicer control, not the worksheet data or the table or PivotTable it filters; to keep the slicer but show all items again, use its Clear Filter button instead.

Remove a slicer in a few steps

First, click the slicer’s frame rather than one of its item buttons. When the slicer is selected, handles appear around its edge and Excel displays the contextual Slicer tab on the ribbon. Press Delete on your keyboard to remove the selected slicer. The same basic method applies whether the slicer filters an Excel table or a PivotTable.

If clicking the slicer selects a cell or activates one of its filter buttons, try clicking an empty part of its border. You can also open Home > Find & Select > Selection Pane, select the slicer in the list, and press Delete. The Selection Pane is useful when slicers overlap other objects or are difficult to click. Excel may give an object a generic name, such as Slicer_City, so select entries carefully if the sheet contains several.

Removing the slicer does not erase the source records, delete the table, or remove the PivotTable. It removes the on-sheet filtering control. If you meant to keep the control and simply reset its selection, do not delete it: select the slicer and choose its Clear Filter button, usually shown as a small filter icon with a mark indicating that a filter is active.

Remove a slicer or clear its filter?

These actions solve different problems. Clear Filter resets the slicer’s current selection so that it no longer restricts the connected table or PivotTable by that slicer. The slicer remains visible and can be used again. Delete removes the slicer object from the worksheet, which is useful when the control is no longer needed or the report layout is being simplified.

For example, imagine a sales report with a Region slicer currently set to West. If you want the report to show all regions but expect to filter by region later, clear the slicer filter. If the report should no longer offer region filtering, delete the slicer. In either case, the source sales rows remain in the workbook.

  • Clear the filter when you want to restore the unfiltered view but keep the control.
  • Delete the slicer when you do not want that control on the sheet.
  • Disconnect the slicer when it should remain on the sheet but should stop filtering one or more PivotTables.

What a slicer controls

A slicer is a visual filter made of clickable buttons. For an Excel table, it filters the table by values in the chosen column. For a PivotTable, it filters the connected PivotTable by a field, such as product, salesperson, or year. Unlike a standard drop-down filter, the slicer keeps the available choices visible on the worksheet, which can make a report easier for another person to use.

A slicer is an interface to data, not the data itself. Deleting one does not delete rows or change the underlying records. It can, however, change what appears in a filtered report. After removing one, check the table or PivotTable: other slicers, column filters, report filters, or manual selections can still limit what is displayed. A report that still looks filtered does not necessarily mean the slicer failed to delete.

Slicers can also be connected to more than one PivotTable when those PivotTables share a compatible data source or PivotTable cache. In that situation, one slicer may update several views at once. Deleting the slicer removes that shared control, not the connected PivotTables themselves.

Disconnect a slicer from one PivotTable

Sometimes the slicer should stay on the worksheet and continue controlling some reports, but it should no longer affect one particular PivotTable. In that case, change its connections instead of deleting the slicer. Select the slicer, open the Slicer tab, and choose Report Connections. In the dialog, clear the check box for the PivotTable that should no longer respond, then confirm the change.

The dialog lists PivotTables that Excel can connect to that slicer. If the PivotTable you want is not listed, it may not share the required source or cache with the others. This connection-setting approach is for PivotTable slicers; an Excel table slicer filters its associated table rather than offering the same list of PivotTable report connections.

Use this option when a dashboard has several PivotTables but only some should respond to a particular filter. For instance, a Region slicer might filter a sales-by-month PivotTable while leaving a company-wide target summary unchanged. Deleting the slicer would remove the control from the sheet altogether, whereas disconnecting it preserves the control and its other connections.

Delete a slicer that is hard to select

A slicer can be difficult to click if it is behind another object, partly off the visible area, or covered by shapes. The Selection Pane provides another way to select it: choose Home > Find & Select > Selection Pane, locate the slicer in the list, select it, and press Delete. If the pane contains several similarly named objects, you can select entries one at a time and watch which item is highlighted on the sheet before deleting anything.

If Delete appears to remove cell contents instead, Excel probably had a cell selected rather than the slicer. Undo immediately with Ctrl+Z on Windows if you removed something by mistake, then select the slicer’s outer edge or use the Selection Pane. A visible border and sizing handles are a useful check that the object, rather than a cell, is selected.

A protected worksheet can also prevent changes to objects. If you are authorized to edit the sheet, use Review > Unprotect Sheet; a password may be required. Once the sheet is unprotected, select and delete the slicer, then protect the sheet again if that is part of the workbook’s intended setup. Do not try to bypass a password you are not authorized to remove.

What to check after removal

After deleting a slicer, look at the associated table or PivotTable and confirm that the displayed results make sense. If a PivotTable still shows only some categories, check its field drop-downs and report filters, then review any other slicers that may be connected. If several PivotTables responded to the deleted slicer, check each relevant view; a dashboard can contain multiple separate filtering controls.

Also check the report layout. Removing a slicer may leave an empty space where it was placed, and nearby charts or text boxes may need to be repositioned. If the workbook is shared with other people, consider whether they rely on the slicer to explore the report. A brief label or instruction can be helpful when a familiar control is removed, especially in a dashboard designed for occasional users.

If you only wanted to hide the control temporarily, deleting it may be the wrong choice. You can move it out of the main report area or use the Selection Pane’s visibility control where available, then restore it later. If you choose deletion, save the workbook after checking the report. If you are unsure whether the slicer is used in a complex dashboard, save a separate copy before making layout changes.

Excel for Mac and Excel for the web

In Excel for Mac, select the slicer by its border and press the Delete key. The ribbon tab name and exact layout can vary slightly by Excel release, but the key distinction remains: select the slicer object, not one of its buttons or a worksheet cell. If the keyboard’s Delete key behaves like Backspace, use the key that removes the selected object on that keyboard, or select the slicer in the Selection Pane and delete it.

In Excel for the web, available editing controls can depend on the workbook and current feature support. If the slicer can be selected, try selecting its border and pressing Delete. If Excel for the web does not let you remove it, open the workbook in the desktop application and use the steps above. Avoid confusing removal with clearing a slicer’s filter; the latter changes what the report displays without removing the control.

Common mistakes to avoid

  • Clicking a slicer button and pressing Delete: A button click changes the filter selection. Select the outer frame before deleting the object.
  • Assuming the source data was deleted: Removing a slicer removes a control, not the table records or PivotTable.
  • Deleting when you meant to reset: Use Clear Filter if you want the slicer available with no restriction applied.
  • Deleting when you meant to disconnect: Use Report Connections for a PivotTable slicer that should remain connected to other PivotTables.
  • Ignoring other filters: A remaining restriction may come from a different slicer, a table filter, or a PivotTable field filter.

Frequently Asked Questions

How do I remove a slicer without deleting the data?

Select the slicer’s outer border and press Delete. This removes the slicer object, not the source rows, table, or PivotTable. Check the report afterward because other filters can still affect the displayed results.

How do I clear a slicer without removing it?

Select the Clear Filter button on the slicer. This resets its active selection while leaving the slicer on the worksheet for future use.

Why can’t I select or delete a slicer?

You may be clicking a slicer button instead of its frame, or the worksheet may be protected. Select the border or choose the slicer through Home > Find & Select > Selection Pane. If you are allowed to edit a protected sheet, use Review > Unprotect Sheet first.

Will deleting a slicer remove a PivotTable?

No. Deleting the slicer removes the filtering control, not the PivotTable or its source data. The PivotTable may still be affected by other slicers and filters.

Can I stop a slicer from filtering just one PivotTable?

Yes, if it is a PivotTable slicer with that PivotTable listed in its connections. Select the slicer, choose Slicer > Report Connections, and clear the check box for the PivotTable you want to disconnect.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.