Excel Value Filter Not Working? Fix the Common Causes

If an Excel value filter is not working, first clear the current filter and check that the column contains consistent data and that the filter covers the full list. In Microsoft 365 for Windows, use the column’s filter arrow to choose the values you want; if the results still look wrong, the cause is often mixed text and numbers, a stale filter range, or another active filter.

What an Excel value filter does

A value filter hides rows that do not meet the selections or conditions you make in a column’s drop-down menu. It does not delete data. For example, if a Sales column contains 120, 250, and 400, selecting 250 leaves the matching row visible and hides the other two until you clear or change the filter.

Excel’s menu may show individual values under a checklist, or offer conditions such as Number Filters, Text Filters, or Date Filters. Which options appear depends on how Excel interprets the column. A filter works across the rows in its range or table, so the header row and each record need to be arranged consistently for the results to make sense.

To turn filtering on for a selected data range, choose Data > Filter. In a structured Excel table, filter arrows usually appear in the header row automatically. On Mac and Excel for the web, use the Data tab and its Filter control; ribbon layout can vary slightly. Filtering is a view of the data, not a replacement for sorting or changing the underlying values.

Start with the filter state and visible rows

The quickest fix is to remove all active criteria and apply the filter again. A column can have a filter even when its arrow looks ordinary, and criteria in a different column can also explain why an expected row is missing. Check every header for a filter indicator or a funnel icon, then inspect the selected criteria in the relevant drop-downs.

Open the affected column’s filter arrow and choose Clear Filter From [column name], if that option is available.
To clear criteria across the current range, choose Data > Sort & Filter > Clear on Windows.
To reapply the existing filter after data changes, choose Data > Sort & Filter > Reapply.
Check whether rows are hidden manually. Clearing a filter does not necessarily unhide rows hidden with the Hide command.

Do not assume that a missing row has been deleted. A filtered worksheet can contain hidden matching or nonmatching records, and manually hidden rows can make the visible result confusing. After clearing criteria, scroll through the range or use the row numbers to see whether rows remain hidden. If the sheet is protected, some filtering actions may also be unavailable unless the protection settings allow them.

Check for numbers stored as text

A frequent cause is a column that looks uniform but contains both real numbers and text representations of numbers. For example, one row might contain the number 25 while another contains the text value 25, perhaps imported from a text file. They can look identical on the screen, yet Excel may list them separately or offer different filter behavior. A green error indicator or left alignment can be a clue, but neither is a definitive test because formatting and alignment can be changed.

To investigate, inspect a few cells individually and compare their values and number formats. A value that begins with an apostrophe, contains an unexpected space, or came from a CSV import may be text. If the column is meant to hold quantities, convert the text entries to numbers consistently, then reapply the filter. Data > Text to Columns can sometimes convert numeric text as part of a deliberate conversion, but check the preview and test a copy first.

Be careful with identifiers such as product codes, postal codes, or account numbers. They may contain digits but are intentionally stored as text; converting them to numbers can remove leading zeros. In that case, standardize the text instead of forcing numeric conversion. Also watch for ordinary spaces and nonbreaking spaces copied from web pages. Those make apparently identical text values different, so trimming or cleaning the source data may be necessary before filtering.

Look for blanks, spaces, and inconsistent labels

Text filters match the cell contents, not just what seems visually similar. A list might contain North, North followed by a space, and north. Depending on the condition, capitalization is usually not what separates ordinary Excel text matches, but trailing spaces and other invisible characters can. If a checklist shows duplicate-looking entries, compare the source cells rather than selecting one entry and assuming it covers all variants.

Blank cells can also affect what you see. The filter menu may include a separate (Blanks) choice, and a formula that displays an empty string is not necessarily the same as a genuinely empty cell. If a filter for a category seems to omit records, inspect cells that look blank and check whether they contain formulas, spaces, or imported characters. Decide whether those records should be treated as blank or corrected to a consistent category.

For categories such as status or region, a useful repair is to standardize the source values first: choose one spelling, remove extra spaces, and fill missing categories only when the correct value is known. Then clear and reapply the filter. This avoids building a filter around accidental variations and helps future sorting, summaries, and PivotTables produce cleaner results.

Verify the data range or table boundaries

A filter can only return rows inside the range it covers. If new records were added beneath a manually filtered list, they may sit outside the filter and remain visible regardless of the selected value. A blank row or blank column inside a dataset can also make it harder for Excel to identify the intended contiguous range when filtering is first applied.

Click inside the data and inspect which rows have filter arrows and respond to the filter. If the data is an Excel table, click in it and check the table boundaries; on Windows, Table Design > Resize Table lets you adjust the range. For a normal range, select the complete header-and-data block and choose Data > Filter again. Avoid including unrelated notes or totals in the same range, since those rows may then be treated as records.

Tables are often a better choice for lists that grow over time because they provide consistent headers and generally extend when data is entered immediately below them. Still, verify the table includes pasted or imported rows rather than assuming every operation expanded it. Keep one header row, avoid merged cells in the data area, and do not leave completely blank rows between records. These habits make filters more predictable.

Consider dates and mixed data types

Dates can be especially confusing because the displayed format does not determine whether a cell contains a real Excel date. A true date is stored as a number and displayed using a date format; a text string such as 03/04/2026 may only look like a date. The string can also be interpreted differently depending on regional date settings. If the filter menu groups real dates by year or month but lists other entries individually, the column may contain mixed types.

Check a suspicious cell’s formula bar and number format, and compare it with a known valid date. When importing data, use the correct regional interpretation before converting text to dates. Do not change the display format alone and expect text to become a date; formatting changes how a value appears, not what type of value it is. After correcting the source, clear and reapply the filter so the menu reflects the data.

Similar issues occur when a column mixes numbers, text, and errors. Excel may display different filtering choices for different types, and a condition such as greater than may not behave as expected on text. Keep each column to one kind of information where possible: dates in date columns, numeric measurements in number columns, and labels in text columns.

Refresh formula results and imported data

If the filtered column contains formulas, its displayed result may change after the filter criteria were chosen. Recalculate the workbook if calculation is set to Manual: choose Formulas > Calculation Options > Automatic, then calculate as needed. On Windows, F9 recalculates; Shift+F9 recalculates the active sheet. The filter itself does not repair an incorrect or outdated formula result, so inspect the cell’s formula and its inputs if the result is unexpected.

When formulas or source values change, choose Data > Sort & Filter > Reapply to refresh the existing filter against the current values. This can also help when records have been edited or pasted into the filtered range. If the data comes from Power Query or another external connection, refresh that source first using Data > Refresh All, then reapply the filter if the visible results have not updated.

A regular worksheet filter is not the same as a PivotTable filter. If the data is summarized in a PivotTable, refresh the PivotTable with PivotTable Analyze > Refresh, or use Data > Refresh All for connected data. A normal worksheet filter does not update a PivotTable’s cache, and refreshing a PivotTable does not necessarily change criteria on an unrelated worksheet range.

A reliable troubleshooting sequence

When the cause is unclear, use a controlled sequence rather than repeatedly clicking values in the checklist. This helps distinguish a filter problem from a data-quality or range problem.

Save a copy if you are about to make broad changes to imported or inconsistent data.
Clear criteria from every column, and check for manually hidden rows.
Confirm the filter range includes all headers and records, with no accidental blank separators.
Inspect the affected column for mixed numbers and text, date strings, extra spaces, and formula results that look blank.
Correct the underlying data while preserving identifiers and other values that must remain text.
Apply the filter again, select one known value, and verify that matching rows appear throughout the range.
Add other criteria one at a time. If the expected rows disappear after a particular selection, that criterion or its source values need closer inspection.

Testing one value against a small, known example is more informative than selecting many entries at once. For instance, if a Status column should contain Open and Closed, check a few source cells for spaces or alternate spellings, filter for Open, and compare the visible rows with the source records. Once the result is correct, add other column criteria and confirm that the combined conditions produce the intended subset.

Frequently Asked Questions

Why does Excel show a value in the filter list but no matching rows?
There may be no matching value inside the current filter range, even if the value appears elsewhere on the sheet. Another column’s filter may also hide the row. Clear all filters, verify the range boundaries, and check the source cell for spaces or a different data type.

Why does my filter show duplicate values that look the same?
The entries may differ by a trailing space, a nonbreaking space, or another invisible character. Compare the underlying cells and standardize the text. Also confirm whether one entry is genuinely blank and another contains a formula that displays an empty result.

Why does Excel filter only some of my new rows?
The new records may be outside the filtered range or table. Check the table boundary with Table Design > Resize Table, or select the complete range and apply Data > Filter again. Blank separator rows can make an intended list look like separate blocks.

Does changing a cell’s number format fix a value filter?
Not by itself. Number formatting changes the way a value is displayed; it does not convert text into a number or text into a real date. Convert the underlying data correctly, then reapply the filter.

Why does the filter work differently in a PivotTable?
A PivotTable has its own field filters and cached source data. Refresh the PivotTable after its source changes, then check its field selections. A normal worksheet AutoFilter and a PivotTable filter are separate controls.

Can I filter by values and by a condition?
Yes. The drop-down can let you select individual checklist values or apply a condition such as greater than, contains, or a date range, depending on the data type. To remove a condition, clear that column’s filter and set the desired criteria again.

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.