Excel Slicer Formatting: Styles, Size, Layout, and Use

How-to basics · Updated November 21, 2026

In Excel for Microsoft 365 on Windows, select a slicer to open its contextual Slicer tab, then use Slicer Styles to change its appearance and the button and size controls to adjust its layout. You can also change the slicer’s caption, sorting, and item display in Slicer Settings; the exact options depend on whether the slicer filters a table or a PivotTable.

What a slicer formats—and what it does not

A slicer is a visible set of filter buttons for an Excel table or PivotTable. Clicking a button filters the connected data, while the slicer’s formatting controls determine how that filter is presented. You can change its color scheme, button dimensions, number of columns, overall size, and some display settings without changing the underlying values or calculations.

Formatting is separate from the format of the source data. For example, a slicer for a Sales Region field might show buttons such as East, West, and Central. Changing the slicer style does not recolor the matching cells in the worksheet, and changing a cell’s number format does not change the slicer’s buttons. If you want filtered rows or PivotTable values to receive their own formatting, use cell formatting or conditional formatting as well.

Slicers can filter Excel tables and PivotTables, but they are not the same as ordinary AutoFilter dropdowns. Their large, always-visible buttons make a filter easier to discover and use in a report or dashboard. That visibility is also why size and style matter: a slicer should be clear without taking over the worksheet.

Insert a slicer before styling it

To create a slicer, first select a cell in the table or PivotTable you want it to filter. The relevant ribbon tab appears when the selection is inside that object. Then use the appropriate path:

  • Excel table: Select a cell in the table, choose Table Design > Insert Slicer, select one or more column names, and choose OK.
  • PivotTable: Select a cell in the PivotTable, choose PivotTable Analyze > Insert Slicer, select one or more fields, and choose OK.

After insertion, click the slicer itself. Excel displays the contextual Slicer tab, where the style gallery and layout controls are available. If that tab is missing, check that the slicer—not a worksheet cell—is selected. Depending on the current ribbon layout or Excel update, some commands may appear in a compact group or behind a dropdown.

Choose a slicer style and customize its colors

The fastest way to change a slicer’s appearance is to select a preset in the Slicer Styles gallery on the Slicer tab. The gallery includes light, medium, and darker designs. Choose one that has enough contrast between selected and unselected buttons, and that fits the workbook’s existing colors. Hovering over a style can show a preview before you click it.

For more control, open the gallery’s More menu and choose New Slicer Style. Excel opens a dialog where you can define formatting for slicer elements, such as the header and the different button states. This is useful when a preset is close to the desired look but does not distinguish selected items clearly enough. A custom style can be saved with the workbook and reused there.

Keep the visual meaning consistent. A selected button should look unmistakably different from an unselected button; otherwise, readers may not know which filter is active. Avoid using color as the only signal when possible. Strong contrast, readable text, and a clear header also help people who have difficulty distinguishing colors or who view the sheet on a low-quality display.

Changing the style does not change which items are selected. It is a visual setting, not a filter command. Conversely, clicking a button changes the active filter but does not permanently change the style. This distinction is helpful when troubleshooting a slicer that looks right but shows unexpected results.

Adjust button size, columns, and overall dimensions

When the slicer is selected, use the button and size controls on the Slicer tab to fit it to the worksheet. The Columns setting controls how many buttons appear across each row. Button height and width control the dimensions of individual buttons, while the overall Height and Width settings control the slicer object itself.

  • Use one column for a long list of names or categories when users need to scan items vertically.
  • Use multiple columns for short labels such as quarters or regions when horizontal space is available.
  • Increase button height if labels are hard to read or the slicer will be used on a touchscreen.
  • Widen the slicer if longer labels are cut off or wrap in an unattractive way.

For instance, a slicer with four quarter buttons can often use four columns in a short, wide dashboard panel. A slicer with 30 product names is usually easier to navigate in one or two columns, with enough height to show several choices and room to scroll. Increasing the number of columns does not reduce the number of items; it rearranges them within the available space.

If the controls are unavailable or appear to have no effect, make sure the slicer is selected and that the worksheet is not protected in a way that prevents editing. Resizing the overall object can also change how many buttons are visible, but it does not remove items from the source field.

Set the caption, sorting, and item display

Open Slicer Settings on the contextual Slicer tab to adjust options for the slicer’s field and visible labels. Depending on the slicer and Excel build, settings include changing the displayed caption, sorting items, and controlling whether items with no data appear. The caption is a heading for the slicer; changing it does not rename the source column in the table or PivotTable.

Sorting deserves attention when the field contains labels that look numeric or represent time. Text values may sort alphabetically, so labels such as Month 1, Month 2, and Month 10 might not appear in the intended sequence. If the order matters, use a field with an appropriate underlying sort order or arrange the source data and PivotTable field accordingly. A slicer setting cannot turn arbitrary text into a true date or numeric sequence.

Items with no data can be useful in a consistent dashboard layout, but they may confuse readers if they select a category that produces a blank result. Hiding unavailable items can make the choices clearer, while showing them may help users understand the full range of categories. The best choice depends on whether a stable list or only currently relevant choices is more useful.

Connect slicers and arrange a dashboard

A slicer does not automatically filter every PivotTable in a workbook. To connect one slicer to additional compatible PivotTables, select it and choose Slicer > Report Connections (the command may be labeled PivotTable Connections in some Excel versions). Select the PivotTables that should respond. This works when the PivotTables share the appropriate data source or PivotCache; unrelated PivotTables may not be available in the list.

For table slicers, connections work differently: a slicer belongs to its table rather than serving as a general controller for unrelated tables. If several reports need to respond together, consider building them from a shared PivotTable data model or a compatible shared source, then connect the PivotTable slicer where supported.

On a dashboard, keep related slicers near the report they control and align their edges. You can move or resize a selected slicer by dragging its border or using the size controls. Leave room for long labels and for the scroll bar when a field contains many items. If multiple slicers share a row, consistent widths and button heights make the interface easier to scan.

Common formatting problems and practical fixes

  • The style gallery is missing: Click the slicer frame. Clicking a worksheet cell or a filtered table row selects a different object and hides the contextual tab.
  • Selected items are difficult to identify: Choose a style with stronger contrast or create a custom style that makes selected and unselected buttons visibly different.
  • Labels are clipped: Widen the slicer or its buttons, reduce the number of columns, or shorten the source labels if doing so will not make them ambiguous.
  • Some items appear unavailable: Check whether the slicer is set to show items with no data and whether another connected filter is limiting the results.
  • Another report does not respond: Use Report Connections for compatible PivotTables and confirm that both reports share a usable source. A slicer for one Excel table does not automatically filter a separate table.
  • Formatting seems to change after refresh: Refreshing updates the available data items, not necessarily the intended design. Review the slicer’s selections and display settings after a source-data change.

A frequent misconception is that deleting a slicer deletes its source data. It does not: deleting the slicer removes that filter control, while the table or PivotTable remains. Likewise, clearing a slicer filter is not the same as deleting the slicer. Use the clear-filter icon in the slicer when you want to return to showing all items without removing the control.

Excel for Mac and Excel for the web

Excel for Mac supports slicers, but ribbon organization and the wording or location of some commands can differ from Excel for Windows. Select the slicer and look for its contextual slicer controls; if a Windows path is not visible in the same place, use the ribbon search box to find commands such as Insert Slicer or Slicer Settings. The exact availability can depend on the Excel version and update channel.

Excel for the web can display and interact with slicers in supported workbooks, but its authoring and formatting controls may not match the desktop application. If you need to create a custom slicer style or cannot find a layout control, open the workbook in the desktop version of Excel. A slicer created in desktop Excel may still be useful to people viewing the workbook in a browser, though editing capabilities can differ.

Frequently Asked Questions

How do I change the color of a slicer in Excel?
Select the slicer, open the Slicer tab, and choose a design from Slicer Styles. For more control, open the gallery’s More menu and create a new slicer style.

Can I make slicer buttons larger?
Yes. Select the slicer and adjust its button height or width on the Slicer tab. You can also resize the overall slicer object to provide more room for buttons.

How do I show slicer items in multiple columns?
Select the slicer and change its Columns setting on the Slicer tab. More columns arrange buttons across the slicer; they do not change the filter choices.

Can one slicer control multiple PivotTables?
Often, yes. Select the slicer and use Report Connections or PivotTable Connections to select compatible PivotTables. They generally need to share a suitable data source or PivotCache.

Why can’t I see the Slicer tab?
The contextual tab appears when a slicer is selected. Click the slicer itself rather than a cell, and confirm that the workbook is open in a version of Excel that supports the relevant slicer editing command.

Does changing a slicer style change the filter?
No. A style changes the slicer’s appearance. Clicking a slicer button changes the filter, and clearing the filter returns the connected data view to its unfiltered state.

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.