Excel Text Filter Not Working? Common Fixes

If an Excel text filter is not working, first check that the filter covers the entire data range, then clear and reapply it from Data > Filter. If the range is correct, look for blank rows, inconsistent text or spaces, an unexpected filter criterion, and edits that have not yet been included in the filter.

How Excel text filters work

An AutoFilter adds drop-down arrows to the header row so you can display records that meet selected conditions. In a text column, the menu can show existing values to select, or let you choose a rule such as Contains, Begins With, Ends With, Equals, or Does Not Contain. The filter hides rows that do not match; it does not delete them or change the underlying data.

There are two ways to filter text that can look similar but behave differently. Selecting or searching for a listed value works with the distinct values Excel recognizes in that column. Choosing a rule under Text Filters applies a condition to the cell contents. For example, selecting the value “West” finds cells whose full value is West. Choosing Text Filters > Contains and entering West also finds values such as “West Coast” and “Northwest.”

To open the rule menu in Excel for Microsoft 365 on Windows, select the arrow in the column header, point to Text Filters, and choose a condition. Choose Custom Filter if you need two conditions, such as containing “West” or beginning with “North.” The exact options can vary with the kind of data Excel detects in the column.

Check that the filter covers the full data range

A filter can appear to ignore rows when it was applied to only part of the data. This can happen if you selected a few columns or rows before choosing Data > Filter, or if a blank row or blank column divided the data into separate blocks. Excel may treat the block around the selected cell as the current data region, leaving records outside that block untouched.

Clear the current filter using Data > Clear. This removes the active filtering criteria but keeps the filter arrows.
Check that the data has one header row, that each column has a header, and that there are no completely blank rows or columns inside the records.
Select a cell inside the data, then choose Data > Filter. Inspect the header row and confirm that every intended column has a drop-down arrow.
Open a column’s menu and check whether values from the last rows of the dataset appear in its list. If they do not, the filter range may still be incomplete.

For a list that grows regularly, converting the range to an Excel table can make the boundary easier to manage. Select a cell in the data and choose Insert > Table, or press Ctrl+T on Windows. Confirm that My table has headers is selected if the first row contains column names. Tables normally extend when you type directly beneath them, and their header menus include filter controls. On Mac, use Insert > Table; keyboard shortcuts can differ by keyboard and Excel settings.

Clear stale criteria and reapply the filter

Sometimes the range is right but an old condition is still active. A column may have a funnel-shaped filter indicator, or the status bar may show that fewer records are displayed than expected. A prior rule such as “Does Not Contain,” a selected subset of values, or a second condition can exclude rows without making the cause obvious.

Open the relevant header menu and check which values are selected and whether a Text Filters condition is active. To remove only that column’s criteria, choose Clear Filter From [column name] in its menu. To clear conditions across the filtered range, use Data > Clear. Then open the menu again and apply the desired condition. Data > Filter toggles the arrows on or off; it is not the same as clearing the criteria, so turning the arrows off and on is not always the clearest reset.

If you edited cells after filtering, reapply the filter. Choose Data > Reapply when that command is available, or clear and set the condition again. For an ordinary range, new rows typed outside the existing filter boundary may not be included automatically. A table is usually more convenient when records are added often, but check that a new row is actually part of the table before expecting its header filter to include it.

Look for spaces and invisible characters

Two cells can look identical on screen but contain different characters. A leading space makes “North” different from “ North”; a trailing space can prevent an exact match; and copied data may contain a nonbreaking space or other nonprinting character. This is common with text pasted from websites, exported reports, and other systems. A filter for Equals “North” will not match a cell whose stored contents include an extra character.

Check a suspicious cell by selecting it and looking at the formula bar. You can also compare a copied value with one typed directly into a blank cell, or use Find and Replace to search for an ordinary space. Be careful with a broad replacement: removing every space could damage legitimate values such as “New York” or product descriptions. If only a few entries are affected, correcting those cells directly may be safer than changing the whole column.

For a larger cleanup, use a helper column. With the original text in A2:A100, enter the following in B2 and fill it down; if A2 contains leading and trailing spaces plus a nonbreaking space around “North,” the result is North. The formula removes ordinary extra spaces, common nonprinting ASCII characters, and nonbreaking spaces, but it does not remove every possible Unicode spacing character.

=TRIM(CLEAN(SUBSTITUTE(A2,CHAR(160)," ")))

Filter the cleaned helper column rather than the original one, or copy the cleaned results and paste them as values if you intend to replace the source data. Keep a copy of the original column until you have checked that the cleanup preserved meaningful punctuation and spacing.

Check whether the column contains mixed data

Excel chooses filter options based partly on the contents and type of data in a column. A column that looks like text may include numbers stored as numbers, numbers stored as text, dates stored as text, or genuine blank cells mixed with formulas that return an empty string. That mixture can make the menu show categories or values that do not match what you expected. It can also make a text condition unsuitable when the information is actually numeric or date data.

For example, the entries 25 and “25” may display the same way but have different underlying types. If you need a numeric comparison, such as greater than 20, use the Number Filters menu when Excel offers it. If the values are labels that merely contain digits, use Text Filters instead. Similarly, a date displayed as 3/4/2026 might be a real Excel date or text that only looks like one; use Date Filters for actual dates and inspect or convert text dates before relying on date conditions.

To diagnose mixed data, inspect several cells in the column, including the ones that fail to appear. Check the formula bar and, where helpful, change the cell format temporarily to General. Formatting alone does not convert text to numbers or numbers to text. If consistency matters, convert the source data deliberately and verify the results before filtering.

Use the right condition and understand wildcards

A filter can be functioning correctly while the chosen condition is broader or narrower than intended. Contains matches a phrase anywhere in the cell; Begins With and Ends With check a particular position; Equals checks the full value. “Contains art,” for instance, can match “carton” as well as “art supplies.” If you want a whole-cell match, use Equals rather than Contains.

Excel text comparisons in AutoFilter are generally not case-sensitive, so a condition for “north” will normally match “North.” If capitalization is meaningful in your data, a standard text filter is not a reliable way to distinguish case. You may need a separate helper column or another data-cleaning approach designed for case-sensitive comparison.

Custom AutoFilter criteria can use wildcard characters: an asterisk (*) represents any number of characters, and a question mark (?) represents one character. A tilde (~) is used to treat a wildcard character as a literal character. For instance, searching for a literal question mark requires escaping it with a tilde. If your criterion includes an asterisk or question mark and the results look unexpectedly broad, check whether Excel is interpreting it as a wildcard.

Check hidden rows, protection, and display issues

Filtered-out rows are hidden, not removed. Manually hidden rows can also make the visible result look incomplete, and a filter does not necessarily make every hidden row visible again when you clear a criterion. After clearing filters, select the affected row numbers, right-click, and choose Unhide if rows still appear to be missing. Also check for grouped or collapsed rows, which can hide detail independently of AutoFilter.

On a protected worksheet, filtering may be unavailable unless the sheet’s protection settings allow users to use AutoFilter. If the filter arrows are visible but the menus cannot be used as expected, ask the workbook owner to review the protection options or provide an editable copy. Do not remove protection unless you have permission and understand how it affects the workbook.

If a column has no arrow, confirm that filters are turned on and that you are looking at the header row, not a title row above it. If the arrows exist but are difficult to use, increase the column width or check whether a dialog is open behind the workbook window. In Excel for the web, filtering is available, but the ribbon and menu layout may differ from the Windows desktop version. On Mac, use the Data tab’s Filter controls; labels or placements can vary slightly by release.

When sorting, tables, or advanced tools are better

Filtering and sorting solve different problems. A filter displays only records that match conditions, while sorting changes their order. If every row remains visible but the entries are merely in an unexpected order, use the sort controls rather than troubleshooting a text filter. To keep related columns together, sort from a cell in the dataset and follow Excel’s prompt if it asks whether to expand the selection.

For recurring lists, a table offers structured headers and a range that can expand with new records. For a one-time inspection, AutoFilter on a normal range may be enough. If the task involves combining several conditions across different columns, or repeatedly importing and cleaning data, consider Excel’s Advanced Filter or Power Query instead. These tools have different setup and refresh behavior, so they are not necessary just to fix a simple Contains or Equals filter.

Before sharing a workbook, consider whether the recipient should see a filtered view or the complete dataset. A filter can leave records hidden, which may be mistaken for missing information. Use Data > Clear to show all filtered records before distributing a copy when a full view is intended, and check for manually hidden rows as well.

Frequently Asked Questions

Why does Excel say no results when the text is visibly in the cell?
Check for leading or trailing spaces, nonbreaking spaces, hidden characters, and a condition that is too specific. Confirm whether you used Equals when you meant Contains, and verify that the affected row is inside the filter range.

Why does my Excel filter not include new rows?
The new records may be outside the range to which AutoFilter was applied. Clear and reapply the filter to the full dataset, or use an Excel table and confirm that the new row is inside the table.

How do I remove a text filter without deleting data?
Open the filtered column’s drop-down and choose Clear Filter From that column, or use Data > Clear to clear criteria across the range. Filtering hides rows; it does not delete them.

Are Excel text filters case-sensitive?
Standard AutoFilter text conditions are generally case-insensitive. They are not the right tool when a difference in capitalization must determine whether a record matches.

Why are some values missing from the filter drop-down?
The filter may cover only part of the list, a criterion may already be active, or the column may contain mixed types. Clear the criteria, inspect the filter range, and check whether the missing values are stored differently from the others.

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

More in Errors & fixes

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

Spotted an error in this guide? Let us know.