Excel Filter Not Working? Fix the Most Common Causes

If an Excel filter is missing rows, showing unexpected results, or not responding, first check that the filter covers the entire data range and that each column has a clear, single-row header. In Microsoft 365 for Windows, select a cell in the data and choose Data > Filter; if the range is wrong, select the full range including headers and turn the filter on again.

Start by identifying what is going wrong

“Not working” can describe several different filter problems, and each has a different fix. The arrows may be absent, some rows may not be included, a filter may return no matches, or records may remain hidden after you think you cleared the filter. Identify which symptom you see before changing the data.

No arrows: The filter may be off, the selected range may not include the headers, or the sheet may be protected.
Some records are missing from the filter range: A blank row or column may have divided the data into separate regions.
The expected result is missing: Another column may still have an active filter, or the values may be stored in inconsistent formats.
Rows remain hidden after clearing: They may have been hidden manually rather than by the filter.
Only part of the data changes: The filtered range may not include newly added rows or columns.

Look at the header arrows as well as the visible rows. A funnel symbol on an arrow generally indicates that column has an active filter. More than one column can be filtered at once, so clearing only one condition might not restore every record.

Check that the filter covers the whole data set

Excel can infer a data region from the cell you select. Completely blank rows or columns can interrupt that region, causing records beyond the gap to be left outside the filter. For example, a blank row between a sales table and a group of newer sales can make those newer entries appear unaffected when you filter the older block.

For a straightforward range, select every cell from the header row through the last data row and last data column, then choose Data > Filter. On Windows, Ctrl+Shift+L toggles AutoFilter on or off. If the arrows already exist on a smaller range, turn the filter off, select the complete range, and turn it on again. Avoid selecting unrelated notes or totals beside the data, because those cells can become part of the filtered range too.

For data that grows over time, an Excel table is often easier to maintain. Select a cell in the data and choose Insert > Table, confirm the range, and check My table has headers if the first row contains field names. A table normally expands when you enter a new record directly in the row below it, and its filter controls stay attached to the table. If the table still has the wrong boundaries, click inside it and choose Table Design > Resize Table, then set the correct range.

Make the header row unambiguous

AutoFilter expects one header row, with a distinct label for each column. A title row above the actual field names can confuse range selection if it is included as the header. Blank header cells, merged header cells, and repeated labels can also make the dropdowns difficult to identify or create an awkward layout. Use a plain row such as Order date, Region, Product, and Amount, with no merged cells.

Check that each field belongs in its own column and that records are arranged in rows. A blank cell within a data column is usually allowed; a completely blank row separating records is more likely to split the region. If your file has a decorative title, notes, or subtotals, keep them outside the table or range you want to filter. A clean structure makes filtering more predictable and also helps sorting, PivotTables, and formulas.

Clear old criteria and apply the intended conditions

A filter can look broken simply because another condition is still active. Open each column dropdown and check for the funnel icon or selected criteria. To remove one column’s condition, open that column’s dropdown and choose Clear Filter From followed by the column name. To clear all filter criteria while leaving the arrows available, use Data > Sort & Filter > Clear. The exact ribbon layout can vary slightly with window width, but the Clear command is on the Data tab in the Sort & Filter group.

When filtering by text or numbers, distinguish between selecting listed values and setting a rule. For example, selecting North in a Region dropdown shows only records whose Region value matches North. Text Filters can instead find entries that contain, begin with, or meet another text condition; Number Filters offer numeric comparisons. If the desired field is not listed, use the dropdown search box where available, and confirm the search term is not more specific than the stored value.

Conditions in different columns are combined: choosing Region = North and Status = Open shows rows that meet both conditions. This is an AND relationship, not a choice between the two. Within a column’s checklist, selecting multiple values generally shows rows matching any of those selected values. That distinction explains many apparently incomplete results.

Check for inconsistent data and hidden characters

Values that look identical on screen may not be identical to Excel. A category might contain both North and North followed by a space, or an imported number might be stored as text in some rows and as a number in others. Dates can also be true Excel dates in one row and date-looking text in another. Inconsistent types can make dropdown lists, sorting, and number or date criteria behave unexpectedly.

Inspect a few affected cells in the formula bar, and compare their formatting and alignment with nearby entries. A quick diagnostic is to use Find (Ctrl+F on Windows) for the exact text you expect, then inspect the matching cells rather than assuming that visual appearance proves the values are the same. For spaces, a helper column using TRIM can reveal or remove ordinary leading and trailing spaces, but imported nonbreaking spaces may need separate cleanup. Keep a copy of the original data before doing a bulk replacement or conversion.

For date filters, verify that the cells contain real dates rather than text. Changing the number format alone does not convert text into date values. Re-importing with the correct data type, or converting a controlled copy of the column, may be necessary. Be especially careful with dates such as 03/04/2026, whose interpretation can depend on regional date settings. Confirm the intended month and day before applying date ranges.

Look for rows hidden for another reason

Filters hide rows that do not meet the criteria, but Excel also lets users hide rows manually. Clearing a filter does not necessarily unhide rows hidden by a separate action. Select the row numbers around the gap, right-click, and choose Unhide, or select the whole worksheet using the corner button above row 1 and left of column A, then use Home > Format > Hide & Unhide > Unhide Rows. Check for grouped rows as well: outline controls can collapse sections independently of filtering.

Worksheet protection is another possible obstacle. A protected sheet may restrict changes to filter settings, depending on how protection was applied. If you have permission, use Review > Unprotect Sheet and provide the password if Excel requests it. If protection must remain, the person who protects the worksheet can allow use of AutoFilter in the protection options. Do not try to bypass a password; ask the workbook owner to adjust the permissions.

A practical troubleshooting sequence

Use this sequence to diagnose the issue without changing more than necessary:

Save a copy of the workbook, especially if the data was imported or has manual formatting.
Check the header arrows and identify any funnel icons. Use Data > Sort & Filter > Clear to remove existing criteria.
Check whether hidden rows or collapsed groups remain visible as gaps after clearing.
Confirm there is one header row, no merged header cells, and no blank row or column dividing the records.
Select the intended full range and choose Data > Filter, or convert the range to a table with Insert > Table.
Test a simple criterion on a column with an obvious value, then inspect several rows that should match.
If expected entries are absent, compare their underlying values for spaces, text-versus-number differences, or text-formatted dates.

This order helps separate a range problem from a data-quality problem. If the filter works on a clean copy of the same rows, the original sheet may include hidden rows, merged cells, protection, or formatting and structure that complicate the results.

Excel for Mac and Excel for the web

The main filter controls are also available in Excel for Mac and Excel for the web, though ribbon placement and keyboard shortcuts can differ by platform and version. If a Windows shortcut does not work on a Mac, use the ribbon route: select the range and choose Data > Filter. In the web app, check that you are editing the correct worksheet and that you have permission to change the workbook. A workbook opened in a browser can also behave differently from the desktop app if a feature or editing permission is limited, so try opening it in the desktop version when the controls are unavailable.

When collaborating, another person’s filter view or changes can affect what you see, depending on the workbook and app. If records seem to disappear only in a shared file, ask whether a filter is active and check the workbook’s current view before deleting or moving rows. A filtered-out record is still in the sheet; it is hidden from the current display, not removed from the file.

Frequently Asked Questions

Why does Excel filter only part of my data?

The filter range may stop at a blank row or column, or it may have been applied before newer records were added. Turn the filter off, select the complete range including headers, and turn it on again. Converting the data to a table can help the range expand when you add records.

Why is the Filter button greyed out in Excel?

Check whether the worksheet is protected, whether you are in a mode that prevents editing, and whether the workbook is read-only or opened with limited permissions. If the sheet is protected, ask its owner to permit AutoFilter use or provide authorized access to unprotect it.

Why does Excel say no records match when they should?

Another column may have an active criterion, or the values may differ because of spaces, data types, or date interpretation. Clear all criteria first, then test the expected value in one column and inspect the underlying cells that should match.

How do I remove a filter without deleting any rows?

Choose Data > Sort & Filter > Clear to remove the current criteria while keeping the data. To remove the dropdown arrows as well, choose Data > Filter to toggle filtering off. Neither action deletes records.

Why are rows still hidden after I clear the filter?

Those rows may have been hidden manually or collapsed in an outline group. Select the row numbers around the missing area and use Unhide, or expand the outline. Clearing a filter only removes filter-based hiding; it does not undo every other way a row can be concealed.

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.