Why Is My Excel Filter Not Working? Causes and Fixes

An Excel filter usually fails because the selected range is incomplete, the data has blank or merged headers, or the values are stored in inconsistent formats. Select the complete data range, choose Data > Filter, and check that the header row and every row you want included are inside the filtered range; then clear and reapply the filters.

How Excel filters work

AutoFilter adds drop-down arrows to a header row so you can show only records that match selected values or conditions. When you filter a column, Excel hides rows that do not match; it does not delete them. Filtering another column narrows the visible results further, so criteria on different columns normally work together as an AND condition. For example, filtering Region to East and Status to Open shows records that are both in the East and open.

Filters operate on a range or an Excel table, not on a general idea of what you consider to be the whole dataset. Excel uses the range boundaries and the values it recognizes in the cells. That is why a filter can appear to work while excluding recently added rows, treating dates unexpectedly, or omitting records below a blank line.

Check that the full data range is included

A frequent cause is that the filter was applied to only part of the list. This can happen if you selected a few columns or rows before turning on Filter, or if a blank row or column divided the data and Excel detected only one contiguous block. The arrows may look normal even though some records are outside the filtered range.

Click a cell in the data and inspect where the filter arrows appear. Confirm they cover every column that belongs to the list.
Choose Data > Filter to turn the current filter off.
Select the entire range, including its header row and all records, then choose Data > Filter again.
Open a filter drop-down and check whether a value known to appear in the omitted rows is available.

For a list that grows over time, consider converting it to a table: select a cell in the data and choose Insert > Table, or press Ctrl+T in Windows. Confirm that My table has headers is selected if the first row contains field names. Tables make the data boundary more explicit and generally include records added directly below the table, but check the table boundary after pasting or importing data rather than assuming it expanded.

Inspect headers, blank rows, and merged cells

AutoFilter expects one header row followed by records arranged in consistent columns. Each column should have a clear heading, and the header row should not contain a merged cell spanning multiple columns. Merged cells in the data area can also interfere with sorting and filtering because one displayed value may occupy multiple rows or columns.

Look for a completely blank row or column inside the dataset. Excel may treat it as the end of one contiguous block, leaving the records after it outside the filter. Remove the separator if it is not needed, or select the full range manually before enabling the filter. Also check that headers are in one row rather than split across a title row and a second row of labels.

If the worksheet has a decorative title above the data, do not include it as part of the filter header. Select the actual field-name row and the records below it. If a blank header cell is intentional, give that column a meaningful heading so the structure is easier to recognize and maintain.

Clear, reapply, or remove existing criteria

Sometimes the filter is working, but an old criterion is hiding the rows you expect to see. A funnel symbol on a header arrow indicates that a filter is active for that column. Open the arrow and choose Clear Filter From [column name], or use Data > Clear to clear filter criteria across the current range. Clearing criteria makes the hidden matching records visible again; it does not remove the filter arrows.

If the source values changed after a filter was applied, choose Data > Reapply. This tells Excel to evaluate the current criteria against the updated values. To remove AutoFilter itself, choose Data > Filter. On Windows, Ctrl+Shift+L toggles filters for a selected range; on Mac, use the Data tab’s Filter command because keyboard shortcuts can differ by keyboard and Excel version.

Before assuming rows have disappeared, look at the row numbers along the left edge. A jump in numbering usually means rows are hidden, which may be due to a filter or manual hiding. To reveal rows hidden manually, select the surrounding row numbers, right-click, and choose Unhide. Clearing a filter does not necessarily undo rows hidden separately through the row commands.

Check for inconsistent values and data types

Excel can display entries that look alike but are not stored alike. For example, a column may contain the number 42 as a number in some rows and as text in others. A date column may combine real Excel dates with date-looking text. In these cases, filter menus and number or date criteria may not behave as expected, and entries can appear in separate groups.

Inspect a few cells that should match. Check for leading or trailing spaces, apostrophes used to force text, inconsistent date formats, and values copied from another system. A text value such as East followed by a space is not identical to East, even if the difference is hard to see in the cell. Filtering for an exact value may therefore leave out records that appear equivalent.

For a small list, edit the inconsistent cells so they use the same underlying type and spelling. For larger imports, use an appropriate conversion method, such as Text to Columns for text-formatted values, and verify the results before relying on the filter. Avoid converting an entire mixed column without checking it: identifiers such as product codes may need to remain text even when they contain only digits.

Understand search and multiple filter conditions

The checklist in a filter menu shows distinct values Excel recognizes in the filtered column. If the list is long, use the search box in that menu to look for a value. A value that is not currently visible in the checklist might still be present in the data, especially if the menu is showing only part of a long list. Remove the search text and check the selection boxes if the results do not make sense.

Different filters can narrow results more than expected. Selecting East in Region and Open in Status means both conditions must be true. Within one column, selecting more than one listed value generally shows rows matching either selected value. Text Filters, Number Filters, and Date Filters also let you define conditions such as begins with, greater than, or a date period. Review each active column if the visible result is unexpectedly small or empty.

Another common misconception is that a filter changes the underlying records. It only changes which rows are displayed. If a total or chart seems to have changed, check how that calculation or chart handles hidden rows; different Excel features can treat filtered-out rows differently. Do not copy visible results over the original list unless you intend to replace or restructure the data.

When filter arrows are missing or disabled

If no arrows appear, first click inside the data and choose Data > Filter. If the command does not add arrows, check whether the worksheet is protected. Protection can restrict AutoFilter use unless the sheet was protected with permission to use AutoFilter. The sheet owner can review this through Review > Unprotect Sheet, if permitted, or protect it again with the appropriate options; a password may be required to change protection.

Also check whether the selected range has a suitable header row and whether merged cells or an unusual layout are involved. A filter may be available on a table even when you are not looking at the expected range, so click inside the table and inspect its header. If the workbook is open in Excel for the web, the Data tab provides filtering commands, though the exact interface and available options can differ from the Windows desktop app.

In a shared workbook, another person’s filter view or changes can affect what you see. Excel’s Sheet View feature in Microsoft 365 can let people sort and filter a worksheet independently, when available for that workbook. Look at the View tab and the current sheet-view controls before concluding that records are missing from the file.

A quick troubleshooting sequence

When the cause is unclear, use this order so you can isolate the problem without changing the data unnecessarily:

Clear all active filter criteria with Data > Clear, then see whether the expected rows return.
Check for manually hidden rows and confirm the records are still present in their cells.
Turn Filter off, select the complete data including headers, and turn it back on.
Inspect blank rows, blank columns, merged cells, and duplicate or empty header labels.
Compare a value that should match with one that does match, checking spaces, spelling, and whether each is text, a number, or a date.
If the data has changed since filtering, choose Data > Reapply.
For a list that will grow, use an Excel table and verify that new records are inside its boundary.

Save a copy before making broad cleanup changes, particularly when converting imported data or altering a shared workbook. This preserves the original if a conversion changes codes, dates, or leading zeros in a way you did not intend.

Frequently Asked Questions

Why does Excel filter only some of my rows?
Most often, the filter range stops before those rows, commonly because of a blank separator or because the range was selected incompletely. Turn the filter off, select the full dataset including headers, and apply it again.

Why is a value missing from the filter drop-down?
Check whether the value is outside the filtered range, hidden by another active filter, or different from the expected value because of spaces, spelling, or data type. Clear other criteria and search the drop-down list.

Why does my Excel filter show no results?
An active criterion may be too restrictive, or the values may not match exactly. Clear the filters, inspect the source values for extra spaces or inconsistent formats, and reapply only the condition you need.

How do I reset a filter without removing the arrows?
Choose Data > Clear to remove the current criteria while keeping AutoFilter available. You can also open an individual column’s drop-down and choose Clear Filter From that column.

Why do new rows not appear in my filter?
The rows may have been added outside the range to which AutoFilter applies. Extend the range or convert the list to a table, then verify the new records are included and choose Data > Reapply if needed.

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.