Yes. In Excel for Microsoft 365 on Windows, you can select several items in one slicer by clicking its Multi-Select button and then choosing each item, or by holding Ctrl while you click items. The slicer filters its connected table or PivotTable to show records matching any of the selected items.
What multiple selection means in Excel
A slicer is a visual filter made of buttons, usually one button for each distinct value in a field such as Region, Product, or Year. Selecting a single button filters the connected data to that value. Selecting multiple buttons in the same slicer includes records matching any of those choices. For example, selecting North and West in a Region slicer shows rows from either region; it does not require a row to belong to both.
Selections in different slicers work together. If you select North and West in Region, then select Laptop in Product, the result must satisfy both filters: the region is North or West, and the product is Laptop. This is a practical way to combine alternatives within a field with conditions across fields.
A selected slicer item is not necessarily a permanent change to the source data. It changes what the connected table or PivotTable displays. The underlying records remain in the workbook, and clearing the filter restores the broader view.
How to select several slicer items
Use these steps in the Excel desktop app for Windows:
- Click any item in the slicer to select it, if nothing is currently selected.
- Click the Multi-Select button in the slicer header. It is usually shown as a small checklist-style icon near the clear-filter control.
- Click each additional item you want included. Click a selected item again to remove it from the selection.
- When finished, leave Multi-Select enabled if you expect to make more multi-item changes, or turn it off to return to ordinary single-item clicking.
You can also hold Ctrl and click multiple slicer items. This is useful for a quick selection without changing the Multi-Select setting. The button method is often easier to discover and less prone to accidentally replacing the current selection. On a Mac, use the slicer’s Multi-Select button when available; keyboard modifiers can differ by version and input device.
To remove the slicer filter, click the clear-filter icon in the slicer header, commonly shown as a funnel with a red mark. This clears that slicer’s selection; it does not necessarily clear filters from other slicers or worksheet filters.
Insert a slicer for a table or PivotTable
A slicer must be connected to a supported Excel table or PivotTable. For a regular table, first click a cell in the table, then choose Table Design > Insert Slicer. Choose one or more table columns, such as Region and Product, and select OK. Excel creates one slicer for each chosen column.
For a PivotTable, click inside the PivotTable and choose PivotTable Analyze > Insert Slicer. Select the fields you want to filter and confirm. The slicer buttons reflect the available items in the selected field. If the command is unavailable, check that the active cell is inside a supported table or PivotTable rather than a normal range, chart, or blank area.
For instance, a sales table might contain Date, Region, Product, and Revenue columns. Adding Region and Product slicers lets a reader select several regions and one or more products without opening filter menus. A date slicer or timeline can be useful for date ranges, while a regular slicer is best suited to choosing distinct field values.
How slicer connections affect multiple reports
A slicer can sometimes control more than one PivotTable, which is helpful for dashboards containing several views of the same data. Select the slicer and look for Slicer > Report Connections (the command may be labeled PivotTable Connections in some Excel versions). Select the PivotTables the slicer should control, then confirm.
Not every PivotTable in a workbook can share a slicer. The reports generally need to use the same underlying PivotTable data source or compatible data model. If a PivotTable is missing from the connections list, it may have been created from a different source or cache. Creating the reports from the same table or data model can make sharing filters easier.
A slicer inserted for a regular Excel table filters that table. Do not assume it will also control a separate table or an unrelated PivotTable. Check the available connection options rather than relying on similar column names. If a dashboard has multiple reports, test each slicer with a distinctive selection and confirm that every intended report changes.
Reading selections and combining filters
Selected buttons are visually highlighted, while unselected values appear in a different style. The exact colors depend on the workbook’s slicer style and theme. If the slicer is narrow, long labels may be cut off; resize it or adjust the number of columns so the selected values are easier to inspect.
When multiple slicers are present, a value can appear unavailable because another filter leaves no matching records. For example, choosing a product that is not sold in the selected region may leave that product unavailable or produce an empty result, depending on the source and slicer settings. That does not automatically mean the workbook is damaged.
Use specific selections to answer a clear question. If a report is meant to compare two regions, select both regions in the same slicer. If the aim is to show one region and several products, select one region in Region and multiple items in Product. These choices are easier for other readers to interpret than applying several hidden filter conditions.
Common problems and how to fix them
- Only one item stays selected: Turn on Multi-Select before clicking additional items, or hold Ctrl while clicking. A normal click with multi-select off replaces the previous choice.
- The slicer does not change a report: Confirm that the slicer is connected to that table or PivotTable. For PivotTables, inspect Report Connections and verify the report uses a compatible source.
- Some items are greyed out or missing: Other filters may have removed matching records, or the slicer may be configured not to display items with no data. Check other slicers, report filters, and source data.
- The filter seems stuck: Use the clear-filter icon on the relevant slicer. Also check for worksheet AutoFilters, PivotTable filters, or other slicers that may still restrict the results.
- The selection is hard to understand: Widen the slicer, use a clearer slicer style, and give it a descriptive heading. A slicer title such as Region makes its purpose more obvious than a bare list of buttons.
It can also help to check whether the source data contains unexpected blanks, extra spaces, or inconsistent labels. Values such as West and West followed by a space may be treated as separate items. Correcting inconsistent source entries can make the slicer list more predictable.
Useful examples and selection habits
Imagine a PivotTable summarizing monthly sales by product and region. To compare two territories, select East and Central in the Region slicer. To narrow the comparison to two product lines, select those products in the Product slicer as well. The PivotTable then reflects both conditions, and the selected buttons make the active choices visible.
For a yearly review, selecting multiple years in a Year slicer can show an inclusive set of separate years, but it does not necessarily create a continuous date range. If the goal is to filter from one date through another, a timeline or date filter may be more appropriate. Slicers are designed around discrete field items, so the right control depends on whether the task is choosing categories or defining a range.
Before sharing a workbook, consider whether the current selections should remain active. A saved workbook can reopen with filters still applied, which may surprise a reader who expects to see all records. Clear the slicers before saving if an unfiltered starting view is important, or label the dashboard so its active filters are apparent.
Excel for Mac and Excel for the web
Slicer creation and layout commands can differ between Windows, Mac, and Excel for the web, and available options depend on the Excel version and workbook features. In desktop Excel for Mac, use the slicer controls shown for the selected table or PivotTable; the Multi-Select button is a useful alternative when a keyboard modifier is unclear. Ribbon names and contextual tabs may not match Windows exactly.
Excel for the web can support interacting with slicers in compatible workbooks, but desktop Excel may be needed for some creation, connection, or formatting tasks. If a command described here is missing, open the workbook in the current desktop version of Excel and check the contextual Table Design, PivotTable Analyze, or Slicer controls. Avoid assuming that a workbook’s behavior is identical across all platforms, especially when it uses a data model or advanced PivotTable features.
When another filter may be better
Slicers are useful when people need visible, clickable choices, especially on dashboards. They take up worksheet space, however, and can become unwieldy when a field contains hundreds or thousands of distinct values. For a large list, a table’s column filter or a PivotTable field filter may be more compact. For date ranges, a timeline or date filter can be clearer than selecting many individual dates.
Use slicers when the audience benefits from seeing the available categories and current selections. Use standard filters when space is limited or users need detailed search and sorting controls. Neither option changes the source data; both control which records are displayed in the relevant view.
Frequently Asked Questions
Can I select multiple items in an Excel slicer?
Yes. Turn on the Multi-Select button in the slicer header and click the items you want, or hold Ctrl while clicking them on Windows. The slicer includes records matching any selected item.
How do I select multiple slicer items without holding Ctrl?
Click the Multi-Select button in the slicer header, then click each desired item. Click a selected item again to remove it from the selection.
Can one slicer control two PivotTables?
Often, if the PivotTables use the same compatible source or data model. Select the slicer and use Slicer > Report Connections to choose the PivotTables it should control.
How do I clear a slicer selection?
Click the clear-filter icon in the slicer header. This clears that slicer’s filter, but other slicers or worksheet filters can continue to affect the displayed results.
Why does selecting a slicer item show no data?
Another filter may be excluding matching records, or the chosen value may have no matching rows in the source. Check the other active filters and confirm that the source labels and data are correct.
Related
- Excel Power Query Wildcards: What Works and What Doesn’t
- Excel Power Query Value Transformation: Types and Steps
- Excel Power Query Training: Skills, Courses, and Practice
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Create a Distribution List in OutlookTo create a personal distribution list in Outlook, open People, choose New contact list in new Outlook or…
- Excel Not Letting You Copy and Paste? Fixes That WorkIf Excel will not copy and paste, first press Esc, select one ordinary cell, copy it with Ctrl+C,…
- Remove Formatting Marks in Word: Hide the ¶ SymbolsTo remove formatting marks from view in Word, go to Home > Paragraph > Show/Hide ¶ and click…
- Excel Format Numbers in Thousands (K)To show Excel values in thousands with a K suffix without changing the underlying numbers, select the cells,…
- How to Shade a Cell in Excel With Two ColorsExcel does not have a built-in cell-fill option that divides one cell into two solid-color halves. For a…
- How to Insert an Image in an Excel CellIn Excel for Microsoft 365 on Windows, select a cell and choose Insert > Pictures > Place in…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.