To format an Excel slicer in Microsoft 365 for Windows, select it, open the contextual Slicer tab, and choose a built-in style or create one with Slicer Styles > More > New Slicer Style. You can also adjust its button dimensions, number of columns, overall size, and header settings to make it fit your report and remain easy to use.
What slicer formatting changes
A slicer is a clickable filter control for an Excel Table or PivotTable. It displays the available items in a field as buttons, such as regions, product categories, or years. Clicking a button filters the associated data, while the slicer’s appearance helps readers recognize the control and see which items are selected.
Formatting changes how the slicer looks and how its buttons are arranged; it does not change the underlying data, calculation, or filter logic. A style can define colors, borders, and other visual treatments for states such as a selected item or an item that is not selected. Layout settings control practical details, including button size, columns, and the slicer’s overall footprint.
Slicer formatting is separate from the formatting of the cells in a PivotTable or Table. Changing a PivotTable style will not necessarily change its slicers, and applying a slicer style will not recolor the report itself. Treat the slicer as its own report object, with its own style and size.
Apply a built-in slicer style
Built-in styles are the quickest way to match a slicer to a workbook’s theme or create a clear contrast between the filter and the data. To apply one in Excel for Microsoft 365 on Windows:
- Click the slicer. The contextual Slicer tab appears on the ribbon.
- In Slicer Styles, review the styles shown in the gallery. Select a style to apply it to the selected slicer.
- To see more choices, open the gallery’s More button and browse the available styles.
- Click outside the slicer to review it alongside the report, then adjust its size or position if needed.
Look at the selected and unselected buttons, not just the gallery thumbnail. A style that appears attractive in a small preview may make the selected state hard to distinguish on a monitor or when printed. For example, a sales report with a dark blue background may work well with a light blue selection color and dark text, provided both states remain visibly different.
Built-in styles are convenient when several people maintain a workbook or when a consistent, theme-based look matters more than exact brand colors. If the workbook theme changes, some theme-based colors may also appear different. Recheck the slicer after changing a theme rather than assuming its contrast has stayed the same.
Create a custom slicer style
If the built-in gallery does not provide the needed colors or emphasis, create a custom style. Select a slicer, open the Slicer tab, expand Slicer Styles with More, and choose New Slicer Style. In the dialog, give the style a recognizable name and choose a slicer element to format. Use the formatting controls offered in the dialog, then confirm your changes. The custom style appears in the gallery for the workbook.
A custom style is made from individual elements rather than one single fill color. Depending on the elements available in the dialog, you can set separate treatments for parts of the slicer and for button states. This makes it possible, for instance, to keep the overall control neutral while giving selected items a strong accent color. Preview the result with several items selected and with no items selected; a style should communicate both states clearly.
- Use restrained colors: Reserve a saturated accent for selection or a small number of key states.
- Check text contrast: Text should remain legible against both selected and unselected button fills.
- Keep borders purposeful: Borders can separate buttons, but heavy outlines around every item can make a long list visually busy.
- Name the style clearly: A name such as Report Blue is easier to find later than a generic label.
Custom styles are saved with the workbook, not automatically added to every workbook on the computer. If another workbook needs the same look, you may need to recreate or transfer the style using Excel’s workbook features. Keep a master copy or a short style specification if your team uses the same design repeatedly.
Set button size, columns, and overall dimensions
Style is only part of formatting. A slicer with too many narrow columns can be harder to scan than a simple vertical list, even if its colors are attractive. Select the slicer and use the controls on the Slicer tab to set the number of columns and the button height and width. The Size controls let you set the slicer’s overall height and width. You can also drag the sizing handles around the object for a quick visual adjustment.
Choose the layout based on the field’s values and the space available:
- Long category names: Use one column or a small number of columns, and make the buttons wide enough to show the labels without awkward clipping.
- A few short choices: Two or more columns can reduce wasted vertical space. A slicer for four regions, for example, may fit neatly in two columns.
- Many items: A taller, single-column slicer can make scanning easier, but it may require scrolling. If the list is unwieldy, consider whether users need a different field or report design.
- Dashboard controls: Align slicer edges and use consistent dimensions for controls that serve a similar purpose.
Changing button dimensions may change how many items are visible at once. It does not remove items from the field; the slicer provides scrolling when the full list does not fit. Test the control at the size readers will actually use, especially if the dashboard is displayed at a reduced zoom level or on a smaller screen.
Control the header and slicer settings
A slicer header normally identifies the field being filtered, such as Region or Category. To manage the header and other display options, right-click the slicer and choose Slicer Settings, or use the Slicer tab’s settings command when available. The dialog includes a Display header option. Turning the header off can save space, but only do so if the field remains obvious from a nearby label or the report context.
The settings dialog also helps with how items are presented. Depending on the field and Excel version, options can include sorting items, hiding items with no data, or changing how items without data are shown. These choices affect the visible list, not the underlying source records. For a report where users need to understand why an option is unavailable, hiding items with no data may be less helpful than leaving them visible in a clearly distinct state.
Use a separate text label when a hidden header would otherwise make the control ambiguous. For example, a slicer showing January through December should be labeled Year or Month as appropriate; the item names alone may not tell the reader what dimension they filter.
Keep multiple slicers consistent and connected
A dashboard often has several slicers. Consistent formatting makes them easier to recognize as a group, but visual similarity does not mean they filter the same reports. To check which PivotTables respond to a slicer, select it and use Slicer tab > Report Connections (the command may be labeled PivotTable Connections in some Excel versions). Select or clear the relevant PivotTables in the dialog.
Connections depend on the PivotTables sharing a compatible data source or PivotCache. If a PivotTable is missing from the connections list, changing slicer colors will not solve the problem; the PivotTables may not share the required cache or source structure. Check the PivotTable setup before rebuilding the dashboard’s visual formatting.
For a tidy layout, use the same style, header treatment, and button dimensions for slicers that play similar roles. Align them with Excel’s object alignment controls or position them carefully against the worksheet grid. Leave enough room for the longest field label and for scrolling. Avoid placing a slicer over cells readers need to edit or values they need to see.
Common formatting problems and fixes
- The Slicer tab is missing: Click the slicer object itself. Clicking a worksheet cell or the PivotTable beside it will not show the slicer-specific ribbon tab.
- A custom style is not in another file: Custom slicer styles belong to the workbook where they were created. Create the style in the other workbook or use a workbook copy that already contains it.
- Some items are not visible: Increase the slicer’s height, reduce button size, or adjust the number of columns. Check whether scrolling is available before concluding that values have disappeared.
- Selected and unselected items look alike: Edit the style to increase contrast between the states, or choose a built-in style with clearer selection cues.
- A slicer does not filter one report: Check Report Connections or PivotTable Connections. The report may not be connected or may use an incompatible PivotCache.
- Labels are cut off: Increase button width or use fewer columns. Also consider shortening the source labels if that is appropriate for the data, rather than shrinking text until it is difficult to read.
A frequent misconception is that formatting a slicer changes the filtered results. It does not: clicking a button changes the filter, while changing the style changes only the control’s appearance. Similarly, resizing a slicer changes how much of its item list is visible, not which values exist in the source field.
Windows, Mac, and Excel for the web
The instructions above target Excel for Microsoft 365 on Windows. On Excel for Mac, select the slicer to reveal its contextual ribbon tab; the tab name and available commands can differ slightly by release. Slicer creation, styling, and connection options are not always identical across platforms, so use the commands shown in your installed version. If a setting described here is not available, open the workbook in desktop Excel for Windows or consult the support information for your specific Excel build.
Excel for the web can work with many workbook features, but the options available for creating or customizing slicers may differ from desktop Excel. If you need to build a custom style or perform detailed layout work and the relevant controls are absent in the browser, open the file in the desktop app. When sharing a formatted workbook, check how it appears in the environment your readers will use.
Frequently Asked Questions
Can I change the color of one slicer without changing the others?
Yes. Select the specific slicer and apply a style to it. Applying a style to one selected slicer does not automatically recolor every other slicer in the workbook, though you can apply the same style to other controls when you want a consistent design.
Can I change the font or button colors in a slicer?
You can use built-in styles or create a custom slicer style to control supported visual elements, including button-state formatting. The available formatting choices depend on the selected element and Excel version. Review the custom-style dialog for the options it offers.
How do I make slicer buttons bigger?
Select the slicer and adjust Button Height or Button Width on the Slicer tab. If the entire slicer also needs more room, change its overall height or width. Larger buttons can mean fewer visible items, so check the resulting scroll behavior.
Can I hide a slicer header?
Usually, yes. Open Slicer Settings and clear Display header. Add a nearby worksheet label if readers might not otherwise know which field the slicer filters.
Why does my slicer not control every PivotTable?
Check the slicer’s report or PivotTable connections. A slicer can control only compatible PivotTables that are connected to it; PivotTables built from different caches or sources may not appear as available connections.
Related
- Excel Protect Sheet Edit Scenarios Explained
- Excel Protect Sheet: How to Change a Password
- Excel Protect Sheet: How to Edit Protected Cells Easily
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Google Sheets COUNTIF With Multiple Ranges: How It WorksGoogle Sheets’ COUNTIF function accepts one range at a time, so to count matching values across separate ranges,…
- Power Query Editor: What It Is, How It Works, and WhyPower Query Editor is the data-preparation window in Microsoft Excel where you connect to data, clean and reshape…
- Can You Make a Poster in PowerPoint? A Practical GuideYes, you can make a poster in PowerPoint by setting a slide to the poster’s intended dimensions, designing…
- Excel Solver Not Responding? Fixes and CausesIf Excel Solver is not responding, first give it a moment: Solver may be calculating a difficult model…
- How to Flip a Table Upside Down in Excel by Reversing RowsTo flip a table upside down in Excel, reverse the order of its data rows while keeping each…
- Wrap Text in Excel and Google Sheets: Step-by-StepTo wrap text, select the cell or range, then turn on wrapping: in Excel for Microsoft 365 on…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.