Excel Filter Not Working? Causes and Fixes That Help

If a filter in Excel is not working, first check that the filter covers the full data range, then clear existing criteria and apply it again with Data > Filter (or press Ctrl+Shift+L on Windows). Blank rows, inconsistent headers, hidden rows, or values stored in different formats are common reasons a filter seems broken.

Start with the quickest filter reset

Before changing the worksheet, make sure you are looking at the expected sheet and that the data is not simply hidden by an existing filter. In Excel for Microsoft 365 on Windows, click inside the data and choose Data > Clear to remove active filter criteria. Then choose Data > Filter to switch the filter arrows off and on again, or use Ctrl+Shift+L to toggle them.

Turning filtering off and back on does not delete rows or values. It removes the filter controls and restores rows hidden by AutoFilter criteria. However, rows hidden manually with the row commands may remain hidden, so check for gaps in the row numbers if some records are still missing. On a Mac, use the Data tab’s Filter and Clear commands; keyboard shortcuts can differ by keyboard layout and Excel version.

Click a visible filter arrow and choose Clear Filter From the relevant column if only one column is affected.
Use Data > Clear if you want to remove criteria across the filtered range.
Check the row numbers on the left: a jump, such as 12 to 18, indicates hidden rows, though it does not by itself show whether a filter or manual hiding caused them.

Check that the filter includes all your data

A filter applies to a particular contiguous range or Excel table. If a completely blank row or column separates part of the dataset, Excel may treat the data on either side as separate regions. When you start filtering from one region, records beyond the gap may not receive filter arrows and will not be included in the results. This often happens when someone adds new records below a blank separator.

Click in the dataset and inspect the range outlined after selecting Data > Filter. Confirm that the first header row and the last data row are included. If the arrows appear only on some columns, turn filtering off, remove unintended blank separators if appropriate, select the entire intended range, and turn filtering on again. Do not include a title or notes above the actual column headers unless those rows are meant to be part of the data structure.

New entries added beneath a normal filtered range may sit outside it. Excel tables are generally more reliable for growing lists because they expand as you add records directly below the table. To make one, select the data, choose Insert > Table, and confirm that My table has headers is selected when the first row contains column names. Check the range in the dialog before confirming so that unrelated cells are not included.

Make sure the header row is usable

Each column should have one clear, nonblank header cell. Duplicate names can make a list harder to interpret, and blank or merged header cells can cause Excel to treat the range unexpectedly. Use distinct labels such as “Order date” and “Ship date,” rather than merging a heading across several columns. A decorative title row above the headings is fine, but it should not be mistaken for the header row.

If the range is an Excel table, click inside it and check the Table Design > Header Row option. When the header row is not displayed, table filter buttons may not be visible. For a regular range, make sure the selected data begins with the actual column-name row before enabling the filter. Avoid merged cells in the filtered range; unmerge them and put one value in each record cell where possible.

Look for existing criteria and hidden records

Filters can be active in more than one column at once. For example, a “Region” filter may show only East while a “Status” filter shows only Open. The second filter can make it appear that records are missing even when each individual filter is behaving correctly. Filter arrows often show a funnel icon when a criterion is active. Open each relevant arrow and review the selected values, or use Data > Clear to remove all criteria and start from the full list.

Also distinguish filtered-out rows from manually hidden rows. A filter hides rows that do not meet its conditions, while hiding a row through the row header is a separate action. Clearing the filter may restore the first group but not the manually hidden rows. To reveal manually hidden rows, select the row headers on either side of the gap, right-click, and choose Unhide. If many rows are hidden, select the whole sheet using the top-left corner button and use Home > Format > Hide & Unhide > Unhide Rows.

Check how the values are stored

Two cells that look alike may not contain the same kind of value. A date stored as a real Excel date can behave differently from a date entered as text. Likewise, the number 25 and text “25” can be grouped or matched differently in filtering. Imported data, copy-and-paste from websites, and inconsistent entry habits are common sources of mixed types.

When a value you expect is absent from the filter list, inspect a few cells in that column. Look for leading apostrophes, unexpected spaces, inconsistent date formats, or numbers aligned and treated as text. The filter menu’s search box can help locate a value, but it cannot make mismatched underlying values identical. Clean the source column consistently before filtering; for example, standardize dates and remove unwanted spaces using suitable worksheet tools, then check that the converted values are correct. Keep a copy of imported data before applying bulk cleanup.

Date filters may offer year, month, or day groupings when Excel recognizes the entries as dates. If dates appear as individual text strings instead, those date-specific options may be unavailable or results may not match expectations. Similarly, number filters such as “Greater Than” depend on Excel recognizing the column as numeric. If the menu offers text-style choices where you expect numeric ones, review the cell contents and formatting rather than assuming the filter itself is defective.

Choose the right kind of filter

AutoFilter is useful for temporarily showing rows that meet criteria in existing columns. The dropdown can offer text, number, or date options based on the column’s contents, as well as choices such as filtering by cell color when applicable. Choosing a criterion hides nonmatching rows; it does not remove them from the workbook. This is important when copying results or interpreting totals, because hidden records may still exist in the sheet.

If the ordinary dropdown cannot express the condition you need, consider the workbook’s structure and the task. A table makes routine filtering and sorting easier as records grow. For complex conditions involving multiple fields or criteria, Excel also has an Advanced Filter feature on the Data tab, but it requires a correctly arranged criteria range and is not necessary for ordinary one-column filtering. Avoid switching tools before confirming that the original range and values are sound; a more complex filter will not fix a range that excludes rows.

When filter commands are unavailable

If Data > Filter is dimmed or you cannot change the filter, check whether the worksheet is protected. A protected sheet may allow users to operate an existing AutoFilter only when the sheet’s protection settings permit Use AutoFilter. The filter must already be in place before protection is applied. If you are authorized to change the sheet, review Review > Unprotect Sheet or ask the workbook owner to adjust protection; do not try to bypass someone else’s access controls.

Workbook structure or the current selection can also make a command appear unavailable. Click an ordinary cell in the data range, check that you are not editing a cell, and confirm that the correct worksheet is active. In Excel for the web, the ribbon is more compact, but the Data tab still provides sorting and filtering controls. If a command is hard to find, use Excel’s search box to locate the command by name; the exact presentation can vary with window size and updates.

Prevent the same problem next time

A consistent data layout prevents most filtering surprises. Keep one header row, one record per row, and one field per column. Avoid blank separator rows inside the list, merged cells, and totals mixed into the records. Use consistent data types in each column and add new records directly below the existing data or within the table.

Convert a growing list to an Excel table with Insert > Table.
Use specific, unique column names and keep notes outside the data range.
After importing data, check dates, numbers, spaces, and unusual blanks before relying on filter results.
When results look incomplete, clear criteria first and confirm the selected range before editing or deleting records.

These habits also make sorting, charts, and formulas easier to maintain. Filtering is a view of the records, not a replacement for a clean source list. If coworkers use the workbook, agree on how new rows and values should be entered so that the table remains consistent.

Frequently Asked Questions

Why does Excel filter only part of my data?
There may be a blank row or column separating the records, or the filter range may not include newly added rows. Turn the filter off, select the full intended range, and apply it again. Consider converting the range to a table so it can expand with new records.

Why are some rows still hidden after I clear the filter?
Those rows may have been hidden manually, or another display condition may still be active. Check for gaps in row numbers and use Home > Format > Hide & Unhide > Unhide Rows if appropriate. Clearing an AutoFilter criterion does not necessarily undo manual hiding.

Why can’t I find a value in the filter dropdown?
The value may be outside the filtered range, may be hidden by another column’s active criterion, or may be stored differently from similar-looking values. Clear all criteria, confirm the range, and inspect the source cells for text-versus-number differences, spaces, or inconsistent dates.

Does filtering delete the rows that do not match?
No. AutoFilter hides nonmatching rows from view; it does not delete their contents. Clear the filter to show them again. Be careful when selecting visible cells or copying results, and verify what is selected before deleting anything.

Why is the Filter button greyed out in Excel?
A protected worksheet is one possible cause, especially if the sheet’s settings do not permit use of an existing AutoFilter. Click inside the data and check that you are not editing a cell. If protection is intentional, ask the workbook owner to enable the needed permission rather than attempting to bypass it.

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.