Excel Filter Not Working? Common Causes and Fixes Guide

If a filter in Excel is not working, first check that it covers the entire data range, that the column contains values matching your criteria, and that no blank row or column has split the range. Select a cell in the data and choose Data > Filter to reset the filter controls; then clear the column filters and try again.

How Excel filters work

An AutoFilter displays only the rows that meet the conditions selected in one or more column dropdowns. It hides the other rows; it does not delete them. A filter applies to a range of related data, usually with one header row and a consistent set of columns. If you filter two columns, Excel shows rows that meet both columns’ conditions, not rows that match either one.

For example, a sales list with Region and Status columns can be filtered to show Region = West and Status = Open. A West row marked Closed will be hidden, as will an Open row from another region. This intersection is a common reason people think Excel ignored a filter when it actually applied all active conditions.

Excel can filter a normal range or an Excel Table. Tables are often easier to maintain because they have built-in filter buttons and usually expand when you add adjacent rows or columns. A PivotTable has its own field filters, which work differently from the ordinary Data > Filter controls.

Start with a clean filter

Resetting the controls is a useful first check, especially in a workbook someone else prepared. In Excel for Microsoft 365 on Windows, click inside the data and choose Data > Filter. This toggles AutoFilter, so if the arrows are already on, it may turn them off; choose it again to turn them back on. The Windows shortcut Ctrl+Shift+L also toggles AutoFilter. On Mac or Excel for the web, use Data > Filter if the shortcut differs or is unavailable.

Click a cell in the dataset, not a cell in an unrelated area.
Choose Data > Filter to turn the current filter controls off, then choose it again to apply them to the detected range.
Open each column dropdown and choose Clear Filter From [column name], or use Data > Clear to remove active criteria.
Apply one simple condition, such as selecting a single value, and check whether the expected rows appear.

Clearing a filter removes its conditions; it does not necessarily reveal rows hidden manually with the Hide command. If expected rows remain absent after clearing, select the surrounding row numbers, right-click, and choose Unhide. Also check for hidden columns if the issue is that a field or dropdown seems to be missing.

Check whether the full data range is included

A filter can appear to work while leaving new records untouched if those records sit outside the filtered range. This commonly happens when data is pasted below a blank row, placed beyond an empty column, or added far from the original list. Excel may treat the separated sections as distinct blocks rather than one dataset.

Look for blank rows or columns inside the list, and make sure every record has values under the same headers. Remove genuinely unnecessary blank separators, then select a cell in the data and reapply Data > Filter. If the filter arrows stop before the last column or row, the range was probably incomplete. When you need to set a range precisely, select the full header-to-last-record area before choosing Data > Filter.

For a list that grows regularly, consider converting it to a Table. Select a cell in the data and choose Insert > Table, confirm the range, and check My table has headers if it does. A table provides filter dropdowns in its header row and is designed to include adjoining new data as the table expands. Check the selected range carefully before creating one: a stray cell can make Excel include unwanted blank areas.

Inspect headers, blanks, and merged cells

Each column should have one clear header in the first row of the filtered range. A blank header or a title row above the real headings can cause Excel to interpret the wrong row as the header. Tables require headers; when duplicate header labels are used, Excel may alter them to make the names distinct. Give every field a meaningful, nonblank label, then reapply the filter.

Merged cells are another source of trouble. A merged heading across several columns is useful for presentation but does not form a straightforward field-by-field data header. Keep decorative titles above the dataset, use one unmerged label per column, and avoid merging cells within the records. If the first row contains a report title, start the filter at the actual column-heading row instead.

Blank cells within a column are allowed, but they can affect what you see in the dropdown and which records match a condition. A filter for a particular value will not include blank cells. If blank entries should mean something, fill them consistently or filter for blanks explicitly rather than assuming they will be included with other values.

Look for mismatched values and data types

Filters match the actual cell contents, not merely what a value looks like on screen. A column may contain numbers stored as text alongside real numbers, dates stored as text alongside date values, or category names with trailing spaces. Such entries can appear identical while being treated as distinct items in a filter list. Imported CSV files and copied data are frequent sources of mixed types.

Open the dropdown and inspect the available values. If a value expected to appear is missing, check the cell directly: look for leading or trailing spaces, inconsistent spelling, punctuation, or a different data type. For instance, North and North followed by a space can show as separate categories. Correct the source data consistently before filtering again. Avoid applying a broad conversion without checking first, because conversion can change identifiers such as postal codes or product codes that begin with zero.

Date filters also depend on Excel recognizing entries as dates. A text string that looks like 11/02/2026 may not behave like a date value, and date formats can be ambiguous across regional settings. Confirm a suspect cell is stored as a date and use a consistent date format. If you are unsure, test a few cells and compare them with a known valid date rather than changing the entire column blindly.

Understand why rows may still be missing

When multiple filters are active, one restrictive condition can hide a row that passes another condition. Inspect every column with a filter icon or an active dropdown condition, and clear all criteria before troubleshooting one field at a time. Also check whether the selected condition is an exact text match, a date range, a number comparison, or a search selection that excludes other entries.

Rows can also be hidden independently of filtering. Clearing the filter should restore rows hidden by AutoFilter, but manually hidden rows may stay hidden. Grouped or outlined rows can be collapsed as well. If the row numbers skip, use the row headings to unhide rows or expand the outline; do not assume the filter is still responsible.

In a shared workbook, another person may have changed the filter view or the criteria. If the workbook is protected, the protection settings may restrict changing filter controls. Ask the workbook owner whether filtering is allowed, or whether a separate view is intended. In Excel for the web, check whether you are using a personal sheet view or changing a shared view, since collaboration options can affect what other users see.

When the filter belongs to a Table or PivotTable

Table filters look like ordinary AutoFilter arrows, but the table defines its own boundaries. If a new record is outside the table, its values will not be included in that table’s filter list. Click in the table and check whether the new row is part of it; typing directly in the row immediately below often expands a table, but pasted data separated by a blank row may not. You can resize the table from Table Design > Resize Table in Excel for Windows.

A PivotTable is different: its filters summarize source data and may need a refresh after the source changes. Click inside the PivotTable and use the PivotTable controls to clear its field filters or refresh it; the ordinary Data > Filter command is not the right way to manage its field buttons. If the source list itself is filtered, clear that filter separately. This distinction matters when a row exists in the source but does not appear in a PivotTable result.

For external or connected data, the displayed results may also depend on a refresh or on the connection’s settings. A worksheet filter only narrows the rows currently available in the sheet; it does not necessarily update the original database or query. If expected records are absent from the source list altogether, confirm the data was refreshed and that the source range or connection includes them.

A reliable troubleshooting sequence

Use this sequence when the cause is not obvious. It moves from simple display issues to range and data problems without changing the underlying records unnecessarily.

Save a copy if the workbook contains important or complex data.
Clear all active filter criteria and check whether missing rows return.
Unhide rows that remain missing, and expand any collapsed outline groups.
Confirm the header row and the first and last rows and columns covered by the filter.
Check for blank separators, merged cells, or records placed outside the range.
Inspect the dropdown values for the affected field and verify spelling, spaces, and data types.
Test a simple filter on one column. If it works, add other conditions one at a time.
Identify whether the data is a Table, PivotTable, protected sheet, or connected dataset and use the relevant controls.

If the arrows are missing, clicking inside the intended dataset and choosing Data > Filter usually restores them. If the arrows are present but the result is wrong, focus first on the range, active criteria, and the contents of the affected cells. Those checks distinguish a display problem from a data problem.

Frequently Asked Questions

Why is Excel showing no results when I apply a filter?
One or more active criteria may exclude every row, or the values may differ from the selected item because of spaces, spelling, or data type. Clear all filters, inspect the dropdown values, then test one condition at a time.

Why are the filter arrows missing in Excel?
AutoFilter may be switched off, the selected cell may be outside the data, or the range may not have been detected correctly. Click inside the list and choose Data > Filter. Check that the dataset has a clear header row and is not separated by blank rows or columns.

Why does my Excel filter skip new rows?
The new rows may be outside the filtered range or outside the boundaries of a Table. Check whether they follow the last record without a blank separator, then reapply the filter or expand the table to include them.

Why does clearing a filter not make every row visible?
Some rows may have been hidden manually or collapsed in an outline. Select the affected row headings and choose Unhide, or expand the outline. Clearing AutoFilter criteria does not necessarily reverse separate hide or grouping actions.

Why does Excel treat similar dates or numbers as different filter values?
The cells may contain a mixture of true numeric or date values and text that only looks numeric or date-like. Check the stored values and standardize the column carefully; regional date formats and spaces can also make entries appear inconsistent.

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.