Excel Slicer Colors: How to Change and Customize Them

To change Excel slicer colors in Microsoft 365 for Windows, select the slicer, open the contextual Slicer tab, and choose a design from Slicer Styles. For more control, create a custom slicer style and format its selected, unselected, header, and other button states; the color of a button reflects the slicer’s filtering state, not the color of the underlying data.

Apply a built-in slicer style

Built-in styles are the quickest way to change a slicer’s overall appearance. They coordinate the fill, text, borders, and button states, so you do not have to format each part separately. To apply one:

Click the slicer. If you do not see a Slicer tab on the ribbon, make sure the slicer itself—not the worksheet or a cell—is selected.
On the Slicer tab, find the Slicer Styles gallery.
Click a visible style to apply it. Open the gallery’s More button to see additional styles.

Excel’s style names and previews can vary with the workbook’s theme and Excel release. The preview is useful for narrowing down options, but check the slicer in the worksheet after applying a style: the number of buttons, the header, and the current selection all affect what you see. Applying another built-in style replaces the slicer’s previous style; it does not change the field being filtered or the source data.

What slicer colors communicate

A slicer is a visual filter for an Excel Table or PivotTable. Each button represents an item in the field, such as a product category, month, salesperson, or region. Selecting a button filters the connected table or report. The style uses different formatting for states such as selected and unselected items, so color is part of the control’s feedback rather than a decoration alone.

Depending on the style and the available data, Excel can display different appearances for items with data and items with no data. Custom styles can also include hover states. A button’s appearance may therefore change when you select it, move the pointer over it, or apply another filter that leaves the item with no matching records. This is why a selected button can look different from the same button in a slicer that has no active filter.

Slicer colors do not recolor matching cells, change chart series colors, or alter the source values. They only affect the slicer control. To color worksheet cells according to values, use a separate feature such as conditional formatting; to recolor a chart, format the chart itself.

Create a custom slicer style

A custom style is useful when the built-in choices do not match a report’s colors or when readers need stronger contrast between selected and unselected buttons. In Excel for Microsoft 365 on Windows, select the slicer, open Slicer, expand Slicer Styles, and choose New Slicer Style. In the style dialog, give the style a name, choose a slicer element, and use Format to set available font, fill, and border options. Repeat for the other elements you want to change, then confirm the dialog and apply the new style from the gallery.

The element list lets you treat different parts separately. Depending on the Excel version, it can include elements such as:

Whole Slicer, for general formatting across the control.
Header, for the title area at the top of the slicer.
Selected Item with Data and Unselected Item with Data, for the main button states.
Selected Item with No Data and Unselected Item with No Data, for items that do not match the current filter context.
Hovered versions of item states, where supported, for the appearance under the pointer.

Exact labels and available formatting controls can differ by Excel build. If an element does not appear in the dialog, that version may not expose it as a separate style component. You can often choose theme colors, standard colors, or a custom color in the formatting controls; the precise color picker depends on the selected formatting property.

Choose colors that make filtering clear

Start by deciding what a reader needs to distinguish. A strong, consistent fill for selected items and a quieter treatment for unselected items usually makes the active filter easy to spot. Keep the text readable on both fills, and use borders or font weight as additional cues rather than relying on a subtle shade difference alone.

For example, a sales dashboard with a dark blue header could use a light neutral fill for unselected regions and a saturated blue fill with white text for selected regions. If a region has no matching records after another filter is applied, give that state a visibly subdued but still legible treatment. Avoid using the same strong accent for selected and unselected buttons: readers may otherwise have to inspect the report to work out what the slicer is doing.

Consider these practical checks before settling on a palette:

Check text contrast at the worksheet’s normal zoom, not only in the style dialog.
Use more than color alone to signal selection when the report is important for quick reading. A clear border or weight difference can help.
Preview the slicer with no filter, one item selected, and multiple items selected.
Check the result on the workbook’s actual background and alongside its charts and headings.

Style a slicer for a Table or PivotTable

The basic appearance controls work similarly for slicers connected to Excel Tables and PivotTables, but the way you create and connect them differs. For a Table, select a cell in the table and use Table Design > Insert Slicer, then choose the fields. For a PivotTable, select the PivotTable and use PivotTable Analyze > Insert Slicer. After insertion, select the slicer to access its contextual formatting tab.

A Table slicer filters rows in its associated table. A PivotTable slicer filters the connected PivotTable, and it may be possible to connect it to other PivotTables that share a compatible data source or PivotTable cache. Use Slicer > Report Connections (the command may be named PivotTable Connections in some Excel versions) to review available connections. A slicer that is not connected to a particular report will not filter that report, no matter what colors you choose.

When several slicers or reports are on one sheet, use a consistent visual system. For instance, use the same selected-button color across related slicers, while distinguishing different filter groups with clear headers or placement. This helps readers understand that the controls belong to one dashboard without making every slicer compete for attention.

Adjust the slicer’s layout as well as its color

A color style cannot compensate for a cramped slicer. With the slicer selected, the Slicer tab provides layout controls such as button columns and button dimensions in supported desktop versions. Increasing the number of columns can reduce the slicer’s height, but long item names may wrap or become difficult to read. Wider buttons help with long labels; fewer columns can make a long list easier to scan.

You can also change the slicer’s overall size by dragging its handles or entering dimensions in the size controls where available. The Slicer Settings command includes options for the caption and the display of items with no data, though the exact choices vary with the slicer and Excel version. Hiding the header can save space, but it also removes an important clue about what the buttons represent. If you hide it, provide the field name nearby in a worksheet label.

For long lists, a search box may be available in the slicer, depending on the Excel version and slicer type. A search option can be more useful than shrinking the text or making every button tiny. Slicers also have a clear-filter control, usually shown as a small filter icon with a clearing mark near the upper-right area. It removes that slicer’s filter; it does not reset every other slicer on the sheet.

Common color and formatting problems

The Slicer tab is missing. Click the slicer object. A click on a worksheet cell selects the cell and hides contextual slicer commands. If the slicer is protected or the workbook is open in a mode with limited editing, some commands may also be unavailable.

The selected item color seems unchanged. The chosen style may use similar fills for selected and unselected states, or the slicer may not currently have a selection. Try a style with a stronger state difference, or edit the relevant selected and unselected elements in a custom style. Also check whether a hover appearance is making a button look different while the pointer is over it.

Some buttons look faded. This can indicate items with no matching data under the current filter context, depending on the slicer and its settings. It is not necessarily a formatting fault. Test by clearing filters on the connected slicers and checking whether the item becomes available again.

A custom style is not visible in another workbook. Custom styles are associated with the workbook in which they were created; do not assume that a style made in one file will automatically appear in a separate file. Recreate it in the other workbook or use a workbook that already contains the style. If sharing with people using different Excel versions or the web app, confirm the appearance in their environment because editing controls and rendering can differ.

The color changes after a theme change. Styles that use theme colors can respond to a workbook theme change. If keeping a precise palette matters, review the slicer after changing the theme and reapply or edit the style as needed. Theme colors are generally preferable when a report should follow the workbook’s design; custom colors can be useful when the palette must be fixed.

Excel for Mac and Excel for the web

The instructions above target Excel for Microsoft 365 on Windows. Excel for Mac also supports slicers, but ribbon placement, style galleries, and the availability of detailed custom-style editing can vary by Mac release. Select the slicer and look for its contextual slicer tab; if the Windows dialog’s individual style elements are not available, use a built-in style or make the detailed edits in desktop Excel for Windows.

Excel for the web can display and use slicers in supported workbooks, but it does not necessarily provide the same full set of desktop authoring and custom-formatting controls. If you cannot find a command in the browser, open the workbook in the desktop app rather than assuming the feature or style has been removed. In every version, check the saved workbook after switching apps, especially if custom formatting is important to the report.

Frequently Asked Questions

Can I change the color of just one slicer button?
Standard slicer formatting is based on button states and slicer elements, not independent manual formatting for each item. You can format selected or unselected buttons as a group with a custom style, but the normal style controls do not provide a separate color setting for every category.

Can slicer colors show which data is selected?
Yes. The slicer style can give selected and unselected items different appearances, making the active filter visible. It does not highlight the corresponding source rows with those colors; it formats only the slicer buttons.

How do I remove a slicer’s filter without deleting the slicer?
Click the clear-filter icon on the slicer, usually near its upper-right corner. This clears that slicer’s selection while leaving the slicer object and its style in place.

Can I use the same slicer style for several slicers?
Yes. Apply the same built-in or custom style to each slicer from the Slicer Styles gallery. A shared style helps make related controls look consistent, although each slicer can still filter a different field or report.

Why are some slicer items unavailable or faded?
Another active filter may leave those items with no matching records. The slicer can show such items differently according to its style and settings. Clear the relevant filters or check the connected report to confirm the data context before changing the colors.

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.