Pivot Table Issues

How to Select Multiple Options in an Excel Slicer

Nimra Malik Oct 10, 2026 868 views

Question details

The user needs to know how to properly select multiple specific items within an Excel slicer without inadvertently deselecting them.

How to Select Multiple Options in an Excel Slicer

Product: Excel
Device & OS: not provided
Scenario: Filtering data in a Pivot Table using a Slicer where multiple specific data points need to be displayed.
Observed behavior: When the slicer's multi-select feature is enabled and all items are initially selected, clicking a new item deselects it instead of adding it to a multiple-item selection.

Before you start

Ensure your Pivot Table is correctly set up, a Slicer has been inserted for your desired data field, and all slicer filters are currently cleared.

Solution 1Recommended

Use the Multi-Select Toggle Button

Reset the slicer by turning off multi-select first, choosing your primary item, and then re-enabling multi-select to add additional items.

The multi-select feature in slicers acts like a toggle. If all items are selected by default, pressing an item will turn it off (deselect it) rather than isolate it. To select a specific group of items, you must first clear the default selection state.

Turn off Multi-Select

Click the 'Multi-Select' icon (which looks like a checklist with three checkmarks) in the Slicer header to disable it, or press Alt+S on your keyboard.

Select the first item

Click on the first specific item you want to filter by. Because multi-select is off, this action will immediately isolate that single item and deselect all others.

Turn Multi-Select back on

Click the 'Multi-Select' icon again to re-enable it. The toggle is now active for adding items rather than removing them from a full list.

Select additional items

Click on the other items you wish to include in your filter. Excel will now add them to your existing selection without requiring you to hold the Ctrl key.

Alternative Keyboard Method: If you prefer using keyboard shortcuts, you can simply hold down the 'Ctrl' key while clicking multiple items in the slicer to add them to your selection, bypassing the multi-select button entirely.

Filter Data Efficiently with WPS Spreadsheet

Easily Manage Pivot Tables and Slicers in WPS Office

WPS Spreadsheet provides powerful Pivot Table and Slicer functionalities perfectly compatible with Microsoft Excel. Easily filter, analyze, and visualize your complex data sets for free with an intuitive interface.

1. Open your file in WPS Spreadsheet: Launch WPS Office and open your workbook containing the data and Pivot Table.
2. Insert a Slicer: Click anywhere inside your Pivot Table, navigate to the Analyze tab on the ribbon, and select 'Insert Slicer'.
3. Filter multiple items: Click the Multi-Select icon in the Slicer header, or hold the Ctrl key, to easily choose multiple options for your data analysis.

Fully compatible with Microsoft Excel (.xlsx) formats and Pivot Table structures.Intuitive Slicer interface for quick and accurate data filtering.Familiar layout ensures zero learning curve for users switching from Microsoft Office.Lightweight architecture ensures smooth performance even with large datasets.

microsoft office alternative - wps office

Frequently Asked Questions

Why does clicking an item in my slicer deselect it instead of selecting it?

If all items are currently active and multi-select is enabled, clicking an item acts as a toggle to deselect it. To fix this, turn off multi-select, click one item to clear the rest, then turn multi-select back on to start adding specific items.

Can I select a continuous range of items in an Excel slicer?

Yes. To select adjacent items, click the first item you want, hold down the Shift key on your keyboard, and then click the last item in the sequence. All items in between will be selected simultaneously.

How do I clear all selections in a slicer to show all data again?

You can remove all active filters by clicking the 'Clear Filter' button (the funnel icon with a red X) located in the top right corner of the slicer. Alternatively, you can press Alt+C on your keyboard while the slicer is selected.

Excel & Data Problems