Edit a Slicer in Excel: Change Its Style, Size, and Settings

How-to basics · Updated November 18, 2026

To edit a slicer in Excel for Microsoft 365 on Windows, click the slicer and use the contextual Slicer tab to change its style, button layout, size, or settings. To change what it filters, select different buttons in the slicer; to change which PivotTables it controls, use Slicer > Report Connections (the command may be labeled PivotTable Connections in some Excel versions).

What “edit a slicer” can mean

A slicer is a set of clickable buttons that filters an Excel table or PivotTable. People asking how to edit one may mean several different things: changing its appearance, adjusting its settings, changing the selected filter, or connecting it to other reports. These are separate tasks, so identify the goal before changing options.

For example, a sales report might have a slicer for Region. Choosing West filters the connected data; changing the slicer’s color only changes its appearance; connecting it to another PivotTable changes which reports respond to that same choice. Editing the slicer does not, by itself, alter the underlying source data or the calculations in the report.

  • Change the filter: click one or more item buttons.
  • Change appearance or layout: use the Slicer tab and the slicer’s sizing handles.
  • Change behavior: open Slicer Settings.
  • Change connected reports: open Report Connections or PivotTable Connections.

Before you edit: identify the slicer type

Excel slicers can filter an Excel table or a PivotTable. Click the slicer and inspect the contextual ribbon tab and available commands. A table slicer is associated with its table. A PivotTable slicer can often control more than one PivotTable, but the reports generally need to share a compatible data source or PivotTable cache. A slicer cannot be connected to any arbitrary range or unrelated chart simply because the fields look alike.

If the slicer is missing or its buttons do not match current data, check the source table or PivotTable first. A slicer filters fields already present in its source; it does not create a new field or repair missing source records. For a PivotTable, refresh the report if its source data has changed. For a table, confirm that the table includes the records and field values you expect.

It is also useful to distinguish editing a slicer from editing its source. Renaming a field, changing a table’s data, or modifying a PivotTable layout may affect what the slicer displays. If the workbook is shared, consider whether other people rely on the existing filter or report connections before changing them.

How to change slicer settings

To adjust a slicer’s behavior, select it, then open Slicer > Slicer Settings. You can also right-click the slicer and choose Slicer Settings when that command is available. The dialog’s options depend on the slicer and Excel version, but commonly include its caption, whether its header is displayed, sorting, and how items without data are shown.

  1. Click the slicer’s outer border so the slicer itself is selected, rather than a button inside it.
  2. On the Slicer tab, choose Slicer Settings.
  3. Change the available options. For instance, edit the caption to make a field label clearer, or adjust the sorting option if the button order is not useful.
  4. Choose OK to apply the change.

A caption is the label shown in the slicer header; it does not rename the source column. If the source field is called “Product Category” but the caption is changed to “Choose a product,” the underlying field remains Product Category. Likewise, hiding a header changes what is displayed, not which field the slicer filters.

Options related to items with no data can be confusing. They affect whether values that currently have no matching records are shown, and sometimes how they appear. The exact available choices depend on the source and report. If a value seems absent, check whether the source contains it, whether the report has been refreshed, and whether another filter is excluding its records.

Change the slicer’s selection

Click a button to filter for that item. To select several items, use the slicer’s Multi-Select control if it is displayed, or hold Ctrl while clicking additional buttons in Excel for Windows. On a Mac, use Command-click for multiple selections where supported; the on-slicer Multi-Select control is a useful alternative. The precise interaction can vary with the slicer and Excel version.

To remove a slicer’s filter, click the Clear Filter icon in its header, which usually looks like a filter with a clear or red-cross mark. Clearing the filter returns that slicer to showing all its items; it does not clear filters in other slicers. If the header is hidden, the clear-filter control may not be visible, so restore the header in Slicer Settings or use the available ribbon command for clearing the filter.

Selections combine with other filters. If a Region slicer is set to West and a Year slicer is set to 2025, the report generally shows records matching both choices. A blank-looking report can therefore result from a valid combination that has no matching records, rather than a broken slicer. Clear filters one at a time to find which combination is excluding the data.

Change the slicer’s style, size, and layout

To change the visual design, select the slicer and choose a style from the gallery on the contextual Slicer tab. Built-in styles change colors and borders; they do not change the filter field or report calculations. A style that contrasts clearly with the worksheet background is easier to use, especially when the workbook may be viewed on different screens or printed.

To adjust the number of buttons across, select the slicer and change Columns in the Buttons group on the Slicer tab. More columns can reduce the slicer’s height, but they make each button narrower. Fewer columns usually make long labels easier to read. If names are cut off, increase the slicer’s width, use fewer columns, or shorten the caption where appropriate.

Resize the slicer by dragging its edge or corner handles. You can also set its height and width using the size controls on the ribbon when they are available. Move it by dragging its border, taking care not to drag a button and accidentally change the selection. Excel may align or position objects differently depending on worksheet settings and version.

For a useful dashboard layout, leave enough room for the longest button label and for the number of values users need to see. A slicer with dozens of items may require scrolling; widening it does not make every item visible if its height is limited. Consider whether a compact multi-column arrangement or a different report design will be easier to navigate.

Connect a slicer to other PivotTables

A PivotTable slicer can sometimes control multiple PivotTables. Select the slicer and choose Slicer > Report Connections or PivotTable Connections, depending on the label shown in your Excel version. In the dialog, select the PivotTables that should respond, then confirm. The list only includes reports Excel considers compatible with that slicer.

If a PivotTable is not listed, the usual issue is that it does not share the slicer’s compatible source or cache. Two PivotTables built separately from similar-looking ranges are not necessarily connected in a way that lets one slicer control both. Check how each report was created and whether they use the same source and PivotTable cache. Depending on the workbook, rebuilding reports from a shared source or using the Data Model may be needed; there is no general setting that forces an incompatible PivotTable into the list.

Table slicers work differently: they filter their associated Excel table and do not use the PivotTable Report Connections dialog to control unrelated PivotTables. A chart linked to a PivotTable will usually reflect changes to that PivotTable, but a slicer does not automatically filter every chart on the worksheet. Check the chart’s data source and the report connection before assuming the slicer is malfunctioning.

Common editing problems and fixes

  • The Slicer tab does not appear: click the slicer’s border rather than a worksheet cell or an individual button. If the object is protected or the workbook is in a restricted editing state, the owner may need to change those permissions.
  • The slicer is greyed out or cannot be moved: check whether the worksheet is protected and whether editing objects is permitted. Workbook sharing or permissions can also limit changes.
  • A value is missing: verify the source data, refresh a PivotTable if needed, and review other active filters and Slicer Settings. The value may have no matching records under the current filter combination.
  • A selection does not affect a report: confirm that the report is connected to the slicer. For PivotTables, open Report Connections; for a table slicer, check that you are viewing the associated table.
  • The slicer appears empty or shows unexpected items: clear its filter, inspect other report filters, and refresh the source report. If the source field contains blanks or changed labels, those differences can also affect the buttons.
  • The buttons are difficult to read: widen the slicer, reduce the number of columns, or choose a less crowded style. A longer caption or item label may need more space.

When changing a shared workbook, make one adjustment at a time and check the result in the connected reports. This helps distinguish a visual change from a changed filter state or connection, and makes it easier to undo the specific change if it was not intended.

Excel for Mac and Excel for the web

In Excel for Mac, selecting a slicer exposes contextual slicer commands, though ribbon labels and the arrangement of controls can differ from Excel for Windows. Look for the Slicer tab or its equivalent contextual controls for settings, style, and layout. Mac keyboard conventions differ: Command is commonly used in place of Ctrl for multi-selection. If a command is not visible, check the contextual ribbon and right-click or Control-click the slicer for available options.

Excel for the web can display and interact with slicers in supported workbooks, but editing commands and feature availability may differ from the desktop application. If you cannot find a setting, need to adjust a complex PivotTable connection, or need a control not offered in the browser, open the workbook in the desktop version of Excel. Save changes and confirm that the workbook has finished syncing before closing it.

Frequently Asked Questions

How do I change the name shown at the top of a slicer?
Select the slicer, open Slicer > Slicer Settings, and edit its caption if that option is available. This changes the displayed heading, not the source column’s name.

How do I select more than one item in an Excel slicer?
Use the slicer’s Multi-Select control, or hold Ctrl while clicking items in Windows. On Mac, Command-click may be used where supported. To return to all items, use the slicer’s Clear Filter control.

Can one slicer control two PivotTables?
Often, yes, if Excel recognizes both PivotTables as compatible. Select the slicer and open Report Connections or PivotTable Connections. If the second report is not listed, check whether the PivotTables share a compatible source or cache.

Can I edit a slicer without changing its filter?
Yes. You can change its style, size, caption, or button columns without intentionally selecting a different filter. To avoid changing the selection by accident, drag the slicer’s border or use its ribbon controls rather than clicking an item button.

Why can’t I edit or move a slicer?
The worksheet may be protected, the object may be locked, or you may not have editing permission. Check the workbook’s protection and sharing settings, or ask its owner to allow object editing.

Can I use a slicer to filter a normal range?
Slicers filter Excel tables and PivotTables, not an arbitrary unformatted range. Convert a suitable data range into a table with Insert > Table, or build a PivotTable, then insert a slicer for one of its fields.

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.