Excel Filter Not Equal to Text? How to Exclude Values

Formulas & functions · Updated November 19, 2026

To filter out a particular text value in Excel for Microsoft 365 on Windows, select a cell in your data, choose Data > Filter, open the arrow in the column you want to filter, then choose Text Filters > Does Not Equal. Enter the text to exclude and select OK. Excel keeps rows whose cell in that column does not match the specified value.

What “Does Not Equal” Means in Excel

The filter compares the contents of each cell in one column with the text you specify. If the cell matches, Excel hides that row; if it does not match, Excel leaves the row visible. For example, if a Status column contains Open, Closed, and Pending, a Does Not Equal filter for Closed leaves the Open and Pending rows visible.

This is an exact-value filter, not a general search for a word inside a longer phrase. Excluding East removes cells whose value is East; it does not necessarily remove East Region or Northeast. For a partial-text condition, use Text Filters > Does Not Contain instead. These options are useful for keeping a working view of a list without deleting or changing any source data.

Excel text filters are generally case-insensitive, so a filter for East also matches EAST. They apply to one column at a time, although you can filter several columns to narrow the visible rows further. When filters are combined across columns, a row must meet the active conditions in each filtered column to remain visible.

Apply the Filter Step by Step

  1. Check that each column has a header and that the data forms a continuous range. Avoid blank rows or columns inside the list, since they can make Excel identify only part of the data.
  2. Click a cell in the list. Choose Data > Filter. Filter arrows appear beside the headers. If the data is an Excel table, the arrows may already be present.
  3. Open the arrow for the column containing the text you want to exclude.
  4. Point to Text Filters, then choose Does Not Equal.
  5. In the custom filter box, enter the value exactly as it appears in the cells and select OK.

For a simple list, you can also open the column arrow and clear the checkbox beside the value you want to hide. That is convenient when choosing among a few distinct values. The custom Does Not Equal option is clearer when you know the text to exclude or the column has many different entries.

To turn off the filter for one column, open its arrow and choose Clear Filter From [column name]. To remove filter arrows from the range, choose Data > Filter again. Clearing a filter restores hidden rows; it does not delete them. The Windows shortcut for toggling filters is Ctrl+Shift+L. In Excel for Mac, use Command+Shift+F; ribbon labels can vary slightly by release.

Exclude More Than One Text Value

A single Does Not Equal condition excludes one specified value. To exclude several known values, use the column’s checklist: open its filter arrow, clear Select All, and select the values that should remain visible. For example, to keep Open and Pending but hide Closed and Cancelled, select Open and Pending. This approach is often easier to verify than building a chain of custom conditions.

You can also make more complex criteria in the custom filter dialog. For instance, a text filter can use two conditions joined with And or Or. The choice matters: “not equal to Closed” AND “not equal to Cancelled” excludes both values, while joining those two conditions with OR would allow almost any text value through because a value that is Closed is still not Cancelled. When the aim is to exclude multiple categories, the checkbox list is usually the less error-prone option.

If the criteria involve several columns, apply a filter to each relevant column. For example, to show orders that are not marked Cancelled and are not assigned to the East region, set one Does Not Equal condition in the Status column and another in the Region column. Excel displays rows that satisfy both filters.

Exact Text, Partial Text, and Wildcards

Choose the filter condition that matches the question you are asking. Does Not Equal excludes a complete cell value. Does Not Contain excludes any cell containing a phrase anywhere in its text. Does Not Begin With and Does Not End With are useful when the unwanted values share a prefix or suffix.

For example, if a column contains East, East Region, and Northeast, Does Not Equal East targets the exact East value. Does Not Contain East is the appropriate choice if all three should be removed. This distinction is a frequent source of unexpected results: a filter can be working correctly while still not matching the reader’s idea of “not equal.”

Excel custom text filters can also interpret wildcard characters. An asterisk represents a sequence of characters, and a question mark represents one character. If you need to search for a literal asterisk or question mark rather than use it as a wildcard, precede it with a tilde. When you are unsure how a wildcard criterion will behave, use the visible Does Not Contain, Begins With, or Ends With options, or test the result on a copy of the data.

How Blanks and Different Data Types Behave

Blank cells are not the same as a text value such as “None,” a space, or the number zero. If you need a result that explicitly includes or excludes blanks, inspect the (Blanks) option in the filter checklist and select it as needed. A custom text comparison can produce a result that surprises you when blank cells are present, so do not assume that “not equal to this word” is equivalent to “not blank.”

Also check whether the cells contain text or another data type. A number formatted to look like text, a date displayed in a particular format, or a formula returning an empty string may not behave like a literal text entry. The filter menu offers different categories depending on the values in the column. If the column mixes text, numbers, and dates, use the checklist to see which values Excel recognizes, and consider standardizing the column before relying on a single text condition.

For an explicit, visible selection, clear the checklist and choose only the categories you want to keep. If you want all nonblank values except one particular word, select the appropriate nonblank values and verify the result rather than relying on an assumed blank-cell rule.

Troubleshoot When the Filter Looks Wrong

If a value you expected to disappear remains visible, or a row you wanted disappears, check the underlying data before changing the filter repeatedly. These are common causes:

  • Leading or trailing spaces: “Closed” and “Closed ” can look alike on screen but contain different characters. Compare the cell contents or clean inconsistent entries.
  • Hidden characters: Copied data may contain nonprinting characters or nonbreaking spaces. These can prevent a cell from matching the text you typed.
  • Partial versus exact matching: Switch to Does Not Contain if the unwanted word appears within longer entries.
  • Incomplete filter range: If new rows were added outside the original range, they may not be included. Convert the range to a table or reset the filter range.
  • Another active filter: A second column may be hiding rows independently. Clear other column filters temporarily to isolate the cause.
  • Formula results: A cell displaying a word may be a formula result. Check the formula bar and confirm the returned text does not include extra spaces or characters.

To check for ordinary extra spaces, you can inspect a value in the formula bar or use a helper column to clean a copy of the data. The TRIM function removes leading and trailing ordinary spaces and reduces repeated spaces between words, but it does not remove every kind of invisible character. For imported data, cleaning and reviewing the source column can be more reliable than trying to compensate with a complicated filter.

Use a Formula for a Separate Filtered Result

A standard column filter hides rows in place. If you want a separate, automatically updating list instead, Excel for Microsoft 365 includes the FILTER function. This can be useful for a report or summary that should leave the original table untouched. It returns matching rows in a new area of the sheet, so make sure there is room for the results to spill.

With records in A2:C5, the text to check in B2:B5, and the excluded value in E1, enter this formula in an empty cell:

=FILTER(A2:C5,(B2:B5<>E1),"No matching rows")

If B2:B5 contains North, South, West, and South, and E1 contains South, the result contains the two rows whose category is North and West. The formula compares each cell in column B with E1 and returns the corresponding full rows from A:C. It does not alter the source data. FILTER is available in Microsoft 365 and Excel 2021 or later; older versions may not support it. If the formula returns an error, check that the input ranges have matching row counts and that the spill area is empty.

Filter Versus Find and Replace

A filter is for viewing a subset of rows, not removing or rewriting data. If you only need to hide a category temporarily, Does Not Equal is appropriate. If you need to permanently change entries, use a deliberate editing method such as Find and Replace, after confirming the scope. If you need a reusable output list, a formula such as FILTER may be more suitable.

Do not confuse an Excel filter with the not-equal operator in a worksheet formula. In formulas, the operator is written as <>, as in a comparison between a cell and a value. In the AutoFilter dialog, you choose the named condition Does Not Equal and type the value; you do not type the operator into the filter menu. Keeping those two methods distinct helps prevent criteria from being entered in the wrong place.

Frequently Asked Questions

Does Excel’s Does Not Equal filter match case?
Text filters are generally case-insensitive. A filter for “east” also excludes “East” and “EAST.” If capitalization matters, use a formula-based method designed for case-sensitive comparisons rather than relying on the standard text filter.

How do I exclude text that appears anywhere in a cell?
Open the column arrow and select Text Filters > Does Not Contain, then enter the phrase. Does Not Equal is for excluding a complete cell value, not every longer value that includes the same text.

Can I filter out two words at once?
Yes. In the filter checklist, select only the values you want to keep. Alternatively, set two Does Not Equal conditions joined with And in the custom filter dialog. The checklist is often easier to check visually.

Does filtering delete rows from my worksheet?
No. A filter hides rows that do not meet the condition. Clear the filter to show them again. Copying only visible cells to another location is a separate action and does not change the original data.

Why is a cell with the same text still showing?
Look for spaces, hidden characters, or a partial-text mismatch, and confirm the cell is inside the filtered range. A displayed value can look identical while containing extra characters. Testing the comparison on a cleaned copy can help identify the cause.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

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

Spotted an error in this guide? Let us know.