No—an Excel slicer can filter for more than one item at a time. In Excel for Microsoft 365 on Windows, click the slicer’s Multi-Select button, or hold Ctrl while clicking items; if a click keeps replacing the previous choice, check whether multi-selection is turned on and whether the slicer is filtering the report you expect.
How slicer selection works
A slicer is a set of clickable buttons that filters an Excel table or PivotTable by the values in one field. For example, a slicer for Region might show East, North, South, and West. Clicking East filters the connected data to that region. Clicking another item normally replaces the current selection unless you use a multi-selection method.
When multiple items are selected, Excel includes records matching any of those items within that slicer. Selecting East and West therefore shows rows from either region, not only rows that meet both conditions. If you also use a separate slicer for Year, the filters work together: the report shows rows matching East or West and the selected year or years.
That distinction helps explain what slicers do. Multiple buttons in one slicer usually mean an OR condition; selections across different slicers usually narrow the report together, like AND conditions. Other filters, such as a PivotTable field filter, can also affect what remains visible.
Turn on multi-selection in Excel for Windows
Click the slicer you want to use. If its header is visible, look near the upper-right corner for the Multi-Select button, usually shown as a small selection or check-mark icon. Click it, then click each item to include. Click an already selected item to remove it. Click the Multi-Select button again when you want ordinary single-item clicks.
You can also hold Ctrl and click each desired item. This is useful for a quick selection without changing the button’s mode. In either method, the selected items are highlighted, and the table or PivotTable updates to reflect the filter. To remove the slicer’s filter entirely, click its Clear Filter button, usually shown as a funnel with an X.
- Select the slicer and locate its Multi-Select button.
- Turn on Multi-Select, or hold Ctrl while clicking items.
- Click the values to include, checking the highlighted buttons as you go.
- Use Clear Filter to return that slicer to an unfiltered state.
If the slicer header is hidden, its header buttons may not be available. Select the slicer and open the Slicer tab on the ribbon; in the slicer options, enable the header if the control is offered in your Excel build. You can still try Ctrl-clicking items. On a Mac, the Multi-Select button is the most dependable approach if the Windows Ctrl-click instruction does not match your keyboard behavior; modifier keys differ between operating systems and Excel versions.
Check what kind of data the slicer filters
Slicers can be used with Excel tables and PivotTables, but the way you add one depends on the object. To add a slicer to a standard Excel table, click inside the table and choose Table Design > Insert Slicer, then select one or more column names. To add one to a PivotTable, click inside the PivotTable and choose PivotTable Analyze > Insert Slicer, then choose the fields to filter.
After insertion, the slicer’s buttons represent values from its selected column or PivotTable field. A Category slicer might contain Furniture, Office Supplies, and Technology. Selecting two categories filters the report to records in either category. A slicer does not create new categories or change the underlying data; it changes which matching records or summary results are displayed.
Excel for Mac has slicers too, although ribbon labels and layouts can vary by release. Look for the table or PivotTable design or analysis controls after selecting the relevant object. Excel for the web can display and interact with many existing slicers, but authoring and editing capabilities can differ from the desktop app. If a command is missing, open the workbook in desktop Excel and check that the selected object is a supported table or PivotTable.
When multiple selections are useful
Multi-selection is useful whenever a report needs a group of values rather than one value. A sales dashboard might show two regions side by side in the same summary, or a project report might include several departments. It can also make comparisons easier: select three product lines, then compare their combined totals without changing the source data or rebuilding the PivotTable.
For instance, suppose a table has columns for Month, Region, and Salesperson. A Region slicer can include East and West, while a Month slicer includes January and February. The resulting view contains records for those two regions during either of those two months. If you want to compare each region’s results separately, selecting both at once may hide that distinction in a combined total. In that case, use one region at a time, or arrange the PivotTable so Region appears as a row or column field.
Use multiple selections when the question is “show me these values together.” Use separate PivotTable rows, columns, or charts when the question is “show me how these values differ.” A slicer filters; it does not automatically split a combined selection into separate comparison groups.
Why it may look like only one item is allowed
The most common cause is simply that you are clicking items in ordinary single-selection mode. In that mode, each new click replaces the previous filter. Turn on Multi-Select or hold Ctrl while clicking to add items. If the mode is already enabled but only one item appears selected, click another visible button and check whether the report updates.
Other causes can make the behavior confusing:
- The slicer is filtered already. Its Clear Filter button may help you reset the current selection before trying again.
- Some values are unavailable in the current context. Another slicer, a PivotTable filter, or the data itself may leave only a few relevant items. A disabled-looking item may have no matching data under the other active filters.
- The slicer is connected to a different object. The buttons may change, but the PivotTable or table you are watching may not be connected to that slicer.
- The field has different values than expected. Extra spaces, spelling differences, or inconsistent source entries can create separate slicer items, while blanks may appear as their own item.
Also distinguish a slicer from a drop-down filter in a table header. Both can filter data, but they have different controls and appearances. If you are using a table’s header filter rather than a slicer, its selection list has its own checkboxes and selection behavior; the slicer’s Multi-Select button will not apply to that menu.
Troubleshoot slicers that do not update as expected
Start with the visible filter state. Click the slicer’s Clear Filter button, then make a fresh multi-selection. If the display still does not change, check that the slicer is connected to the object you expect. For PivotTables, select the slicer and look for Slicer > Report Connections (the command may be labeled PivotTable Connections in some versions). The list shows which compatible PivotTables the slicer can control. Select the intended report and confirm.
Report Connections are especially useful when a dashboard contains several PivotTables. A slicer can control multiple PivotTables when they share a compatible data source or PivotTable cache. If one PivotTable is built from a different source or cache, it may not appear as an available connection. In that case, the issue is not the number of slicer selections; the reports are not set up to share that slicer.
If the item list seems incomplete, clear other filters and inspect the source column for the values you expect. For a PivotTable, refresh it after changing the source data: right-click the PivotTable and choose Refresh, or use Data > Refresh All to update workbook connections. Refreshing can bring new source values into a PivotTable slicer, but it will not correct inconsistent labels in the source. For an Excel table, check that the table range includes the rows you expect and that the slicer is based on the correct column.
You can also select the slicer and review its settings. Depending on the object and Excel version, settings may include whether items with no data are shown. Hiding items with no data can make values disappear or appear unavailable when another filter is active. That setting affects the displayed list; it is not a restriction to one selection. If needed, clear the other filters or adjust the slicer’s display settings to make the context easier to understand.
Slicers compared with other filtering options
A slicer is designed for visible, interactive filtering, especially on dashboards. It makes the current choices easy to see and can be more approachable than opening a field’s filter menu. A standard table filter is compact and works well when users need detailed text, number, or date criteria. PivotTable field filters can also support more detailed filtering, but their state is less prominent on a report page.
Multi-selection is not the same as selecting multiple cells in the worksheet, and it does not alter or delete rows. It only changes what the connected object displays. A slicer also does not replace a formula-based analysis: if a workbook needs a calculated result based on user inputs, formulas or other tools may be more appropriate. For a dashboard that needs simple, visible choices, however, slicers are often a practical option.
Frequently Asked Questions
How do I select multiple items in an Excel slicer?
Click the slicer’s Multi-Select button and choose each item, or hold Ctrl while clicking items in Excel for Windows. Click Clear Filter to remove the slicer’s filter.
Can I select multiple items in a slicer on a Mac?
Yes. Use the slicer’s Multi-Select button. Keyboard modifier behavior can differ from Windows, so the button is a straightforward option when Ctrl-click does not work as expected.
Why does clicking a second slicer item deselect the first?
The slicer is likely in single-selection mode. Turn on Multi-Select before clicking the next item, or use the appropriate modifier key for your platform.
Can one slicer control more than one PivotTable?
Often, yes, if the PivotTables share a compatible data source or cache. Use the slicer’s Report Connections or PivotTable Connections command to connect it to the other available PivotTables.
Why are some slicer items greyed out or missing?
Other active filters may leave those items with no matching data, or the slicer may be configured not to show items with no data. Check other filters, the slicer settings, and the source values.
Does multi-select mean Excel shows records that match every selected item?
Usually not within one slicer. Selecting several values in one field includes records matching any selected value. Filters from separate slicers then narrow the results together.
Related
- Excel Protect Cells in a Sheet: Setup, Limits, and Tips
- Excel Print a Certain Area: Set a Print Area
- Excel Printer Not Responding? Troubleshoot the Problem
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- How to Repair an Excel File That Won’t Open SafelyIf an Excel file will not open, first make a copy of it, then use Excel for Microsoft…
- Unable to Create Rules in Outlook? Find the Right FixIf Outlook won’t let you create a rule, first check that you’re using the right rule settings for…
- Excel UNIQUE Formula Not Working? Fix Common CausesIf Excel’s UNIQUE formula is not working, check that you are using Microsoft 365 or Excel 2021 or…
- Excel Import CSV with Decimal Point: Fix Number ParsingTo import a CSV with decimal points correctly in Excel for Microsoft 365 on Windows, use Data >…
- SUMIFS Not Working With Multiple Criteria? Common FixesWhen SUMIFS is not working with multiple criteria, first check that its arguments are in the right order…
- Excel Conditional Formatting for Errors: Fix & HideTo highlight or hide errors in Excel, use Conditional Formatting with the ISERROR function (or ISNA for #N/A…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.