Excel Slicer Multiple Columns: What Works and What Doesn’t

How-to basics · Updated November 21, 2026

Can one Excel slicer filter multiple columns? Not directly: a slicer is attached to one field at a time. You can add separate slicers for separate fields, or arrange the buttons inside one slicer into several visual columns; those are different features.

What multiple columns can mean in Excel

The phrase can describe two different requests. You might want one control that filters more than one data field, such as Region and Product. Or you might want the choices inside a slicer to appear in a compact grid rather than as one long vertical list. Excel supports the second layout, but a standard slicer does not combine several fields into one control.

A slicer for Region contains Region values, such as East, West, and Central. A separate Product slicer contains product names. Setting the Region slicer to display three button columns changes only how its Region buttons are arranged. It does not add Product choices to that slicer or make the slicer search across both fields.

This distinction matters when planning a report. If the goal is to filter on several criteria, use several slicers and place them together. If the goal is to save screen space, change the button-column layout of each slicer. You can do both at once.

Filter more than one field with separate slicers

For a PivotTable in Excel for Microsoft 365 on Windows, select the PivotTable and choose PivotTable Analyze > Insert Slicer. In the field list, select each field you want to filter, such as Region, Product, and Year, then select OK. Excel creates one slicer for each selected field. You can move and resize the slicers independently.

For a formatted Excel table, select a cell in the table and choose Table Design > Insert Slicer. Select the fields to create separate slicers for them. A table slicer filters rows in that table; it is not the same as a PivotTable slicer, and it does not offer the same report-connection controls.

Separate slicers work together. For example, choosing West in a Region slicer and Accessories in a Product slicer shows records that satisfy both selections. Within a single slicer, selecting more than one value generally includes records matching any selected value in that field. In other words, the selections across different fields narrow the results together, while multiple values in one field broaden that field’s selection.

To select multiple items in a slicer, use its multi-select button if shown, or hold Ctrl while selecting items. On Windows, Ctrl-click toggles individual selections; on a Mac, use Command-click where the Excel interface calls for the equivalent modifier. The exact controls can vary slightly by release. The clear-filter icon in the slicer’s upper-right corner removes that slicer’s current selection without clearing the others.

Put slicer buttons into multiple visual columns

If the request is about the shape of a slicer, Excel has a Columns setting. Select the slicer so its contextual ribbon tab appears, then choose Slicer > Buttons > Columns and enter the number of columns you want. The slicer rearranges the buttons for that one field into a grid. For example, a Region slicer with six choices can be shown in two columns instead of six rows in a single column.

The setting changes the arrangement, not the data or filtering logic. If you set Columns to 3, Excel does not create three fields, nor does it make the slicer filter three columns in the source data. It simply lays out the available buttons across three columns, subject to the slicer’s width and button dimensions.

After choosing a column count, adjust the slicer’s overall size so labels fit. You can drag its edges, and the Slicer tab provides controls for button sizing in desktop Excel. A narrow slicer with several columns may truncate long labels or make buttons cramped. A wider slicer often improves readability. For a long list of categories, a search box may also be available in the slicer; it helps locate a value but does not turn the slicer into a multi-field search.

On Mac, the contextual ribbon and setting names may be positioned differently by Excel release, but the same distinction applies: the button-column option changes the slicer’s visual layout. Excel for the web can display and interact with many slicers, but available editing controls can differ from the Windows desktop application. If you cannot find the layout setting in the web interface, open the workbook in desktop Excel.

Use one slicer with multiple PivotTables

A different meaning of multiple columns is wanting one slicer to control several reports. A PivotTable slicer can control multiple PivotTables when those PivotTables share a compatible PivotTable cache or use the same Data Model. Select the slicer and choose Slicer > Report Connections; in some Excel versions the command is labeled PivotTable Connections. Check the PivotTables that should respond, then confirm.

This connects one field’s filter to multiple PivotTables; it still does not make the slicer control multiple fields. For example, one Region slicer can filter a sales-by-month PivotTable and a sales-by-product PivotTable at the same time, provided the reports have compatible underlying connections. You would still need separate slicers for Product, Year, or other fields.

If a PivotTable is missing from the connection list, the reports may not share a cache or Data Model. Having the same-looking source range is not always enough. Depending on how the reports were created, you may need to build them from a common source or model, or create the reports by copying a PivotTable that already uses the desired cache. Check the workbook’s data setup before rebuilding reports, especially if they use external connections or the Data Model.

Do not confuse these report connections with the visual columns setting. Report Connections controls which PivotTables respond. Buttons > Columns controls how choices are arranged on screen. They solve separate problems and can both be used on the same slicer.

PivotTable slicers and table slicers are not interchangeable

Both kinds of slicer let readers filter data by clicking labeled buttons, but their connections differ. A PivotTable slicer is tied to a PivotTable field and can often be shared with compatible PivotTables through Report Connections. A table slicer filters the rows of its Excel table. It does not use the PivotTable Report Connections command to filter unrelated tables or PivotTables.

Choose based on the report you are building. If your summary is a PivotTable and you need a slicer to control several summaries, use PivotTable slicers and plan the reports around a shared cache or Data Model. If you want a simple filter directly on a flat list, a table slicer may be sufficient. Multiple table slicers can filter different columns of the same table together, but each remains a separate field-specific control.

For instance, a table of orders with Order Date, Region, and Status can have separate slicers for Region and Status. Applying both filters shows orders that meet both conditions. It does not produce one combined Region-and-Status slicer, and a slicer on that table does not automatically filter a separate PivotTable built from another source.

Common problems and practical fixes

  • The slicer shows one long list: Select it and increase the Columns value on the Slicer tab. Then widen the slicer if labels are crowded.
  • Only one PivotTable appears in Report Connections: Check whether the missing report shares the slicer’s cache or Data Model. Similar source data does not guarantee a shared connection.
  • A slicer filters one report but not another: Open Report Connections and confirm the intended PivotTables are checked. Also verify that the slicer is a PivotTable slicer, not a table slicer.
  • Selections seem to combine unexpectedly: Separate field slicers apply together, so a Region choice and a Product choice narrow the results to their intersection. Clear one slicer to see whether it is excluding the records you expect.
  • Some buttons disappear after filtering: The slicer may hide items with no data under the current report context. Review the slicer settings and the PivotTable’s source data if those values should remain visible.

Before distributing a workbook, test a few combinations and clear each slicer. This helps confirm the report responds as expected and makes the initial filter state clear to the next person using the file.

When another control is a better fit

If you need one compact control that represents combinations of fields, a slicer may not be the right interface. Separate slicers are usually the clearest choice because users can see and change each criterion independently. A report filter or a carefully designed input area can be more suitable when space is extremely limited, but those alternatives may be less discoverable than labeled slicer buttons.

For a hierarchical choice, such as Category followed by Product, use two slicers and let the first selection narrow the available results for the second where the PivotTable supports that behavior. A single slicer cannot show a true two-level field hierarchy merely by adding visual columns. If users need a combined label such as West — Accessories, that would require a combined field in the source data or a different report design; it is not created by the slicer-column setting.

Frequently Asked Questions

Can one Excel slicer filter two columns?

No. One slicer filters one field. Add a separate slicer for the second field, then make selections in both to filter the report by both criteria.

How do I make an Excel slicer show two columns of buttons?

Select the slicer, then choose Slicer > Buttons > Columns and set the value to 2. This changes the button layout only; it does not add another field.

Can one slicer control multiple PivotTables?

Yes, if the PivotTables share a compatible cache or Data Model. Select the slicer, open Slicer > Report Connections (sometimes called PivotTable Connections), and select the reports to connect.

Can I combine two fields inside one slicer?

Not with the standard slicer control. Use separate slicers, or redesign the source or report if users specifically need a combined field. Separate controls are generally easier to understand and maintain.

Why is a PivotTable missing from Report Connections?

It probably does not share the slicer’s PivotTable cache or Data Model. Confirm how both reports were created and whether they use the same underlying connection; matching field names or source ranges alone may not be sufficient.

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.