Once you have a slicer on a table, you can use styles to quickly change how a slicer looks. You’ll find slicer styles on the Slicer Tools ribbon, which appears whenever a slicer is selected. Just click a thumbnail image to apply a style. Notice each style has a name that appears when you hover with the cursor for a few seconds. The currently applied style is highlighted with a thick border. Although you can create a new slicer style from scratch, you may want to start with an existing style that’s close to what you want. Let’s walk through that process. I’ll first apply the existing dark orange style. Notice this style uses a yellow gradient with black text to highlight hovered items. Let’s make a custom version of the style with a different hover effect. You can’t modify a built-in style directly. If I right-click the style in the menu, Modify is dimmed. To modify an existing style, first right-click and choose duplicate from the menu. Then name and apply the style. Finally, right-click and choose modify. Slicer styles control five main areas of formatting:

  1. The slicer background 2. the header 3. selected items 4. unselected items, and  5. hovered items. Hovered items control the look of buttons when a mouse cursor hovers over them. If I first clear all the hover styles, you can see the yellow gradient effect is gone. Now I’ll add in a green fill for all hovered items with data. Back in the slicer, you can see the buttons with data have a green fill, but buttons without data don’t. To apply the custom style to another slicer, just select the slicer and click the style. Any changes you make to a custom style will automatically apply to all slicers using that style.

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.