Excel Pivot Table Filters: How to Exclude Matching Items

Charts & pivot tables · Updated November 19, 2026

To exclude PivotTable items containing particular text, open the dropdown for a row or column field, choose Label Filters > Does Not Contain, enter the text, and select OK. This hides matching labels and their associated records from the PivotTable; it does not delete or change the source data.

What Does Not Contain means in a PivotTable

Does Not Contain is a text label filter. It checks the displayed items in a PivotTable field and excludes any item whose label includes the text you enter. For example, if a Product field has the items Desk, Desk Lamp, and Chair, filtering the field to not contain Desk removes both Desk and Desk Lamp. Chair remains.

The distinction between a label and the underlying source rows matters. A PivotTable groups source records by field values. When you exclude a label, Excel filters out records in the matching group from that PivotTable’s results. The source records remain in the worksheet or data model, and another PivotTable based on the same source is not automatically given the same filter.

This is useful when you want to exclude a category by a shared text fragment, such as product names containing a discontinued model code, departments containing the word Temporary, or locations containing a regional prefix. It is not a general search across the whole source table: the filter applies only to the field whose dropdown you use.

Apply the filter in Excel for Microsoft 365

In Excel for Microsoft 365 on Windows, place the field you want to filter in the PivotTable’s Rows or Columns area. Then apply the label filter from that field’s dropdown:

  1. Click a cell in the PivotTable. Confirm that the text you want to test is in a row or column field, rather than only in the source data or a Values calculation.
  2. Open the dropdown beside the field name. Depending on the report layout, the heading may say Row Labels, Column Labels, or the field’s actual name.
  3. Point to Label Filters, then select Does Not Contain.
  4. In the filter dialog, enter the text to exclude and select OK. Check that the remaining item labels and totals match what you intended.

The filter is attached to that PivotTable field. You can reopen the same dropdown to edit or clear it. To remove the condition, use the field’s filter menu and choose Clear Filter From followed by the field name, if that command is available in the menu. Clearing a filter restores the items; it does not alter the source table.

If you cannot find Label Filters, check that the field is a text label in Rows or Columns and that you opened its field dropdown, not the dropdown for a Values field. Excel’s exact layout can look different when the PivotTable uses a compact, outline, or tabular report layout, but the filter belongs to the field heading.

What the filter includes and excludes

Does Not Contain tests for a substring, not just a complete match. If you enter North, labels such as North, Northeast, and North Office are all excluded because each contains those letters in that order. Matching is generally not case-sensitive in Excel’s standard text filtering, so entering north also excludes labels such as North Office.

If you need to exclude only one complete label, use Label Filters > Does Not Equal instead. For example, Does Not Equal North excludes the item North but keeps Northeast and North Office. Choosing the right condition avoids an easy-to-miss mistake: a broad substring filter can remove more categories than an exact-label filter.

The filter evaluates the displayed field value. If a source value has leading or trailing spaces, inconsistent spelling, or other characters, the label may not behave as expected. A value that looks like North may actually include a space or a different character. Inspect the source data if the results seem inconsistent.

Label filters versus value filters

Label Filters and Value Filters answer different questions. A label filter tests the text or date label in a row or column field. A value filter tests a summarized measure, such as Sum of Sales or Count of Orders. For example, Does Not Contain North is a label condition; a condition such as Sum of Sales greater than 5,000 is a value condition.

Use a value filter when the requirement is about the result of an aggregation rather than the wording of a category. Open the dropdown for the row or column field, point to Value Filters, and choose the appropriate comparison. The available comparisons depend on the kind of value and PivotTable. A value filter does not search the text in a source field for a phrase.

Likewise, a text field placed in the Values area is usually summarized as a count, not treated as a label list. To exclude names by their contents, put that text field in Rows or Columns and apply a label filter there. If the goal is to exclude individual source records based on a different text column, a PivotTable field filter may not express the rule clearly; a helper column or a filtered source query may be more suitable.

Use more than one condition

Sometimes one phrase is not enough. For example, a report might need to exclude labels containing either Draft or Test. In the filter dialog, look for the option to add a second condition and choose whether the conditions are joined by AND or OR. To keep labels that contain neither phrase, the logic is Does Not Contain Draft AND Does Not Contain Test. If the conditions are joined by OR, an item may pass when it meets either condition, which can produce a different result.

For two exclusion conditions, verify the logic with a few example labels before relying on the totals. A label such as Draft Test contains both words; a label such as Draft Final contains only one. Checking these cases makes it easier to see whether the selected AND or OR behavior fits the rule. The exact dialog presentation can vary slightly by Excel build and field type.

You can also filter more than one PivotTable field. For example, filter Product to exclude labels containing Sample, then filter Region to exclude labels containing Internal. These are separate field conditions, and the resulting report reflects both filters. If the result is unexpectedly empty, clear one condition at a time to find which combination removes all available items.

Common problems and how to fix them

  • Label Filters is missing: Open the dropdown for a row or column field. If the text field is only in Values, move it to Rows or Columns first.
  • More items disappear than expected: Does Not Contain excludes partial matches. Use Does Not Equal for a whole-label match, or choose a narrower text fragment.
  • The text appears to match but stays visible: Confirm that you entered the relevant text, and inspect the source value for spelling differences, extra spaces, or a different label than the one shown in the report.
  • The totals look wrong: Check the field dropdowns for other active filters, including manual checkbox selections, and confirm which measure the PivotTable is summarizing.
  • The filter option is unavailable or behaves differently: Verify that you are filtering a text label field. Date fields may offer date-specific filters, while numeric fields can offer number or value conditions.

Also distinguish a filter from hiding an item manually. Selecting or clearing individual checkboxes in a dropdown creates a list of included items. A label condition such as Does Not Contain expresses a rule based on text. The first can be tedious when many categories exist; the second is easier to maintain when the exclusion rule is consistent.

Refreshes, source changes, and other Excel versions

A PivotTable displays a cached or model-based summary of its source. If the source data changes, refresh the PivotTable using PivotTable Analyze > Refresh, or right-click inside it and choose Refresh. If new source rows are not included, check that the PivotTable’s source range or table includes them; refreshing cannot add records that are outside the defined source.

A label condition is different from selecting a fixed list of visible items: it describes which labels to exclude. After a refresh, review the report, especially if the source values or field structure have changed. If the condition was intended to remove individual records based on a field that is not represented as a PivotTable label, refresh alone will not make the filter test that other field.

Excel for Mac and Excel for the web may arrange the PivotTable menus differently from Excel for Windows. In current desktop versions, look for the field dropdown and its label-filter options; the exact menu presentation can depend on the version and layout. If a particular command is missing in the web interface, open the workbook in desktop Excel for the fuller set of PivotTable controls.

When a helper column or Power Query is a better choice

A PivotTable label filter is a good fit when you want to hide matching categories in one report. Use another approach when the requirement is to mark or remove source records, apply the rule to several reports consistently, or test text in a source column that is not a PivotTable label.

A helper column in the source table can classify rows as Include or Exclude according to your organization’s rule. Add that field to the PivotTable and filter it, which makes the rule visible and reusable in the report. For recurring data-cleaning steps, Power Query can filter source rows before loading them to a worksheet or data model. Those approaches affect which records feed a resulting report, so keep the original data or query steps clear and review the result before sharing it.

Do not treat a PivotTable filter as data deletion or as a permanent cleanup operation. It changes what that PivotTable displays, not the contents of the original range. If other people need to understand why a category is absent, a clearly named helper field or a note describing the filter can make the report easier to audit.

Frequently Asked Questions

Can I filter a PivotTable to show items that do not contain a word?
Yes. Open the dropdown for the relevant row or column field, choose Label Filters > Does Not Contain, enter the word or text fragment, and apply the filter.

Does Does Not Contain exclude an exact item only?
No. It excludes any label containing the text fragment. To exclude one complete label while keeping longer labels that include the same word, use Label Filters > Does Not Equal.

Can I use Does Not Contain on a value such as Sum of Sales?
No. It is a label condition for text items, not a test of a numeric summary. Use a Value Filter for a condition on a summarized measure.

Will filtering a PivotTable delete matching rows from my data?
No. It hides matching items and their associated records in that PivotTable’s results. The original source data remains unchanged.

Why can’t I see Label Filters?
You may have opened the wrong dropdown, or the field may be in the Values area instead of Rows or Columns. Open the label field’s dropdown; if necessary, move the text field into Rows or Columns first.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.