Yes. In Excel for Microsoft 365 on Windows, open the PivotTable field’s filter dropdown, turn on Select Multiple Items when it appears, check the items you want, and choose OK. For fields in the Rows or Columns area, you can usually check several entries directly in the dropdown; a slicer is another convenient way to display and select multiple items.
What selecting multiple PivotTable items does
A PivotTable filter decides which source records contribute to the displayed summary. Selecting several items in one field means the PivotTable includes records matching any of those selected items. For example, if a Sales table has a Region field and you select East and West, the PivotTable summarizes records for East or West, while leaving other regions out of the visible result.
This is different from filtering two separate fields. If you select East and West in Region, then choose 2025 in Year, the PivotTable shows records matching East or West and 2025. In other words, choices within one field generally work as alternatives, while filters on different fields narrow the result together. A filter changes what the PivotTable displays; it does not delete rows from the source data.
There are several places to apply a filter. A field placed in the Filters area appears as a report filter above the PivotTable. A field in Rows or Columns has a dropdown attached to its labels. A slicer presents the same kind of filtering as clickable buttons. The best option depends on where you want the controls and how easy they should be for another person to use.
Show multiple items in a report filter
Use this method when the field is in the PivotTable Fields pane’s Filters area and its dropdown is displayed above the table. In the current Windows desktop version of Excel, the usual steps are:
- Click a cell in the PivotTable so that the PivotTable tabs appear on the ribbon.
- Open the dropdown beside the report filter field, such as Region.
- Select the Select Multiple Items checkbox in the menu.
- Check each item to include. For example, check East and West, and leave North and South unchecked.
- Choose OK to apply the selection.
If you do not see Select Multiple Items, check that you opened a report filter dropdown rather than a dropdown on a row or column label. The controls differ by filter location. You can also move the field into the Filters area in the PivotTable Fields pane if a report-filter control is what you need: drag the field from the field list to Filters. Moving it changes the PivotTable layout, so consider whether the field is more useful as a row or column label.
Once multiple selection is active, a report filter may display (Multiple Items) instead of listing every selected value in the cell. The checked items in the dropdown show what is included. Open the dropdown again to change the selection; do not assume that the summary includes every item just because the cell does not name them individually.
Filter several row or column labels
For a field in the Rows or Columns area, open the dropdown next to its label in the PivotTable. The menu normally includes a checklist of field items. Check the entries you want to keep and choose OK. For example, if Product is a row field, selecting Laptop and Monitor leaves those product categories visible and excludes the unchecked categories.
In a long list, use the search box in the dropdown to find an item, then check it. Search helps locate entries; it does not necessarily replace the existing selection. If you want to include results from multiple searches, take care not to clear earlier checks while changing the search text. Verify the final checklist before applying it.
Row and column dropdowns can also contain Label Filters and Value Filters. These are rule-based filters rather than simple lists of chosen items. A label filter can match text such as entries that begin with a particular word; a value filter can keep categories whose summarized values meet a condition. Use the checklist for specific named items, and use those filter menus when the rule itself is what matters.
Use a slicer for visible, clickable choices
A slicer is often the clearest option when people need to change a PivotTable filter repeatedly. Click inside the PivotTable, then choose PivotTable Analyze > Insert Slicer, select the field, and choose OK. Excel adds a box of buttons for that field. Click one item to filter; use the slicer’s multiple-selection control, or the supported modifier-key selection, to choose more than one. The slicer header also has a clear-filter control that removes the slicer’s current selection.
Slicers make the active choices easier to see than a report filter that says only (Multiple Items). You can resize and position a slicer, and use the Slicer tab to adjust its appearance and settings. If a workbook has more than one PivotTable built from the same source or PivotTable cache, a slicer may be connected to additional compatible PivotTables through Slicer > Report Connections (the tab name or options can vary slightly with the Excel build). Check the connections rather than assuming a slicer controls every PivotTable on the sheet.
Slicers are useful for dashboards, but they take up worksheet space and can expose a long list of choices. For occasional filtering or a compact report, a dropdown may be a better fit. In Excel for the web, PivotTable and slicer editing capabilities can differ from the Windows desktop app and may depend on the workbook and current web version; if a control is unavailable, open the workbook in desktop Excel.
Understand selection, sorting, and filter logic
A checked item is included; an unchecked item is excluded. Many dropdowns have a Select All option. When all values are included, Excel is effectively showing the unfiltered field, even if the menu still gives you a checklist. To exclude just a few categories from a large list, it can be quicker to clear the all-items selection and check the desired values, or to uncheck only the unwanted values when the full list is manageable.
Filters can coexist with sorting and grouping. Sorting changes the order of visible labels, not which records qualify. Grouping dates into months or numbers into ranges changes how the PivotTable organizes a field; it does not mean that multiple filter items have been selected. If the question is whether a particular category is included, inspect the field’s filter menu or slicer rather than relying on its position in the sorted PivotTable.
Be aware that value filters evaluate summarized results, not necessarily individual source rows. For instance, a value filter that keeps products with total sales above a threshold is not the same as selecting several product names. If the expected result is a chosen set of categories, use item selection; if the expected result is based on totals, use a value filter and check which value field the rule uses.
Why items may be missing or results look wrong
When an expected value does not appear in the checklist, first check the source data. The value may be absent, spelled differently, stored as a different type, or hidden by another active filter. For example, North and north may be treated as the same text for many PivotTable purposes, but a trailing space can create a separate item. A blank source cell may appear as (blank), depending on the field and PivotTable layout.
- Check other filters: A report filter, another row or column filter, or a slicer connected to the PivotTable may be restricting the visible records.
- Refresh the PivotTable: After changing the source, click inside the PivotTable and choose PivotTable Analyze > Refresh. If the source range itself has grown, confirm that the PivotTable’s data source includes the new rows.
- Review the selected items: Reopen the relevant dropdown or inspect the slicer. A remaining old selection can make new source values seem absent.
- Look for layout effects: Collapsed groups, subtotals, and report layout settings can make labels less obvious without removing the underlying source records.
Refresh updates the PivotTable from its source, but it does not correct an incomplete source range automatically in every workbook setup. Converting the source range to an Excel table before creating a PivotTable can make later added rows easier to include when the PivotTable is refreshed. If the source has been replaced or substantially changed, inspect PivotTable Analyze > Change Data Source and confirm the range or table name.
To return to an unfiltered view, open the field’s dropdown and choose Clear Filter From followed by the field name, when that command is available. For a slicer, use its clear-filter icon. Clearing one field’s filter does not necessarily clear filters on other fields, so check each control if the PivotTable still shows only part of the data.
Choose the right filtering method
Use a report filter when you want a compact control above the PivotTable and need to filter one field without adding another row or column of labels. Use a row or column dropdown when the field is already part of the summary’s structure and you need to choose specific labels. Use a slicer when the filter should be obvious, clickable, and easy to change in a presentation or dashboard.
For complicated rules, use Label Filters or Value Filters rather than manually checking a changing list. If you need a separate output table that updates based on several criteria, a PivotTable is not the only option: Excel’s table filters, formulas such as FILTER in Microsoft 365 or Excel 2021 and later, or Power Query may suit that task better. Those alternatives have different behavior and setup; they do not change how a PivotTable’s own item checklist works.
Frequently Asked Questions
How do I select multiple items in an Excel PivotTable filter?
Open the field dropdown. In a report filter, turn on Select Multiple Items, check the values to include, and choose OK. In a row or column field, select multiple values from its checklist.
Why does my PivotTable filter say (Multiple Items)?
That label indicates that more than one item is selected in the report filter. Open its dropdown to see the checked values. It does not mean that all items are selected.
Can I select multiple items in a PivotTable slicer?
Yes. Use the slicer’s multiple-selection control or the supported modifier-key method to select several buttons. The exact control appearance can vary by Excel version; the slicer’s clear-filter icon removes its selection.
How do I show all items again?
Open the filter dropdown and choose Clear Filter From for that field, or select all values in its checklist. For a slicer, click the clear-filter icon. Other field filters may still be active.
Why is a new source item not available in the filter list?
Refresh the PivotTable and confirm its source includes the new row. Also check for another active filter and confirm the new value is spelled and stored consistently with the existing items.
Does filtering a PivotTable delete or change source data?
No. A PivotTable filter changes which records are included in the displayed summary; it does not delete the source rows. To change the underlying records, edit the source data separately.
Related
- Excel Keyboard Shortcuts: Essential Keys and Tips Guide
- Excel MAX Between Dates: Find the Highest Value in a Range
- Excel MAX Between Two Dates: Find the Highest Value
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Pivot Table Sort by Hidden Field?Yes, you can sort a pivot table by a hidden field, but the method depends on what you…
- Excel Logarithmic Trendline: How to Add and InterpretAn Excel logarithmic trendline is a curve that models how a value changes as the predictor grows by…
- Excel Horizontal Bullet Chart: Build One Step by StepTo make a horizontal bullet chart in Excel for Microsoft 365 on Windows, create a stacked bar chart…
- Excel Pivot Tables: Display Data in Separate ColumnsTo display a PivotTable’s row fields in separate columns in Excel for Microsoft 365 on Windows, select the…
- Excel Pivot Chart Axis: Switch Rows and Columns EasilyTo switch what an Excel PivotChart shows across its category axis and in its legend, select the chart,…
- Excel Pivot Table Date Range: How to FilterTo filter an Excel PivotTable to a date range, open the drop-down for the date field in the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.