Excel Filter Not Working? Fix Common Problems

If Excel’s Filter option is not working, first select a cell in the full data range and choose Data > Filter; then check for blank rows or columns, existing filters, and sheet protection. In Microsoft 365 for Windows, Ctrl+Shift+L also toggles filter arrows, but the cause is often the shape or contents of the data rather than a broken Excel feature.

How Excel filters work

An Excel filter temporarily hides rows that do not match the conditions you choose. It does not delete those rows or change the underlying values. For example, filtering a sales list to show only the West region leaves the other regions in the workbook; clearing the filter makes them visible again. This distinction matters when totals or row counts appear to change: a normal SUM calculation may still include filtered-out rows, depending on the function used.

Filters apply to a contiguous list or table with a header row. Each header’s drop-down menu lets you select values or set conditions, such as dates after a particular day or numbers greater than a threshold. When you filter more than one column, the conditions generally work together: a row must meet the filter in each filtered column to remain visible.

The ordinary Data > Filter command is separate from Excel’s FILTER worksheet function. The command adds drop-down arrows to a range. The FILTER function returns matching values in a formula result, and requires Microsoft 365 or Excel 2021 or later. A missing or inactive drop-down arrow is therefore not fixed by typing the FILTER function; first diagnose the range or worksheet.

Start with the quickest checks

Try these checks in order. They fix many cases without changing the data:

Click inside the list, then choose Data > Filter. If arrows appear, the filter was simply not enabled for that range.
If arrows are already visible, open a drop-down and look for an active selection or condition. Choose Clear Filter From [column name] to remove that column’s condition.
To clear filter criteria across the active range, choose Data > Clear. This clears the criteria but keeps the filter arrows available.
Check whether rows are hidden manually or by another filter. Clearing filter criteria does not necessarily unhide rows hidden with the Hide command.
Confirm that the worksheet is not protected and that the workbook is not in a state that prevents editing.

To switch filter arrows off and on for the selected range, use Data > Filter or Ctrl+Shift+L on Windows. On a Mac, use Data > Filter from the ribbon; keyboard shortcuts can differ with the keyboard layout and Excel settings. If the arrows vanish after toggling, click in the data and turn them on again. Turning filtering off can clear criteria, so note any selections you need to reproduce.

Check the data range and headers

A filter may seem incomplete when Excel has detected only part of the list. A fully blank row or column can divide one data set into separate regions. If the active cell is in one region, Excel may add arrows to that region only, leaving records below the gap outside the filter. Blank cells within a column are usually acceptable; a completely empty separator row is the more common boundary problem.

Look for these range issues:

A blank row between the headers and later records, or between sections that are meant to be one list.
A blank column that separates fields, such as a gap between Customer and Region.
Headers that are missing, duplicated, or split across multiple rows.
Extra notes or totals directly below the records that Excel has included as if they were data.

For a plain range, remove unintended gaps and select the whole list, including its header row, before choosing Data > Filter. If the data grows regularly, consider converting it to an Excel table with Insert > Table, or Ctrl+T on Windows. Confirm that My table has headers is selected when appropriate. Tables expand more reliably as records are added and include filter arrows in their header row. Avoid merged cells in the header or data area; a simple one-row header is easier for Excel to interpret.

When the filter arrows are missing or unavailable

If you cannot see arrows, first determine whether you are in the intended worksheet and whether a cell in the list is selected. Then check whether the sheet is protected. A protected worksheet can restrict filter use. In Excel for Microsoft 365 on Windows, a workbook owner can review the settings through Review > Protect Sheet. To let users change filters on a protected sheet, AutoFilter must be allowed when protection is configured, and the filter should be set up before protection. If you do not own the workbook, ask its owner to adjust the protection rather than trying to bypass it.

Also check whether you selected multiple worksheet tabs at once. When sheets are grouped, some commands may be unavailable or behave differently. Right-click a selected sheet tab and choose Ungroup Sheets, then try the filter on one worksheet. If the command is still unavailable, make sure you are not editing a cell: press Enter or Esc to finish editing, then select a cell in the list.

In Excel for the web, use the Data tab’s Filter command and check the same range and protection issues. Some workbook features or permissions can behave differently in a browser than in the desktop application. If a shared workbook has editing restrictions, confirm that you have permission to change its filters. On Mac, the ribbon labels are similar, though layout and shortcuts may vary.

Why some expected records do not appear

When arrows are visible but the results look wrong, examine the values in the column being filtered. Cells that look alike may not be stored alike. For example, a quantity entered as the number 25 and one stored as text may appear differently in filter menus or respond differently to number conditions. Dates can also be stored as text, especially after copying data from a website or importing a CSV file. A text date may not sort or filter as a true Excel date.

Check a few affected cells by selecting them and looking at the formula bar and number format. For imported data, use a consistent conversion method and verify the result before filtering again. Do not convert an entire column blindly: identifiers such as postal codes can contain leading zeroes and should often remain text. Similarly, values with extra spaces or inconsistent spelling—such as North, north, and North followed by a space—can make a value list appear to contain unexpected categories.

Other common explanations include:

A filter is active in a second column, so a row that passes the current condition is still excluded by another condition.
The menu’s Search box or selected checkboxes leave only some values selected.
Blank entries are grouped under a blank option, while cells containing spaces are not truly blank.
Rows were hidden manually before filtering and remain hidden after the criteria are cleared.
The list includes formulas whose displayed results differ from what you expect, or values have not recalculated yet.

Open each column’s drop-down menu and review its active criteria. In the menu, select all values if you want to reset that column, or use Data > Clear to clear the range’s filtering criteria. Then apply one condition at a time. This makes it easier to identify which field is excluding the records.

Filter menus, text, dates, and numbers

Excel presents filter options based partly on the content of the column. Text columns offer text filters, numeric columns offer number filters, and date columns offer date filters. If a column mixes types, the menu may show a mixture of values or offer options that do not match your expectation. Standardize the contents when practical, but preserve meaningful distinctions such as text-based product codes.

For a text condition, open the header arrow and choose Text Filters. For values such as prices, choose Number Filters; for recognized dates, choose Date Filters. Exact menu choices depend on the data type and Excel version. If the menu shows a list of individual values, use its search box for a long list, and verify that the relevant checkboxes remain selected. A search narrows the visible choices in the menu; it is not necessarily a permanent filter criterion until you apply the selection.

Wildcards can help with text conditions: an asterisk represents any number of characters, and a question mark represents one character. For instance, a text condition beginning with a pattern such as North can match entries that start with that word. If you need to find a literal asterisk or question mark rather than use it as a wildcard, Excel uses a tilde before the character. Check the actual cell contents when a condition returns too few or too many rows.

Tables, ordinary filters, and formula results

Converting a list to a table is often useful when the data is an ongoing record set. Select a cell in the range and choose Insert > Table, then check the header setting. Table headers include filter buttons, and new rows added directly below a table are generally incorporated into it. A table does not correct inconsistent data or remove protection, but it reduces the chance that newly added records will sit outside the filter range.

An ordinary range filter is appropriate for a one-off list or a layout that should not be converted to a table. In either case, filters hide rows in the source area; they do not create a separate extract. If you need a separate, formula-driven result that updates from criteria, the FILTER function may be suitable in Microsoft 365 or Excel 2021 and later. It is a different feature, and its result spills into nearby cells, so those cells need to be clear. Do not confuse a worksheet function problem with the Data tab’s filter controls.

When to use another approach

If the source has multiple header rows, subtotals mixed into the records, or several unrelated blocks, first reorganize it into one rectangular list: one header row, one record per row, and one field per column. This structure is easier to filter, sort, summarize, and import into other tools. Keep explanatory notes and grand totals outside the filtered list.

For a small list, Find may be quicker than applying a filter: use Home > Find & Select > Find, or Ctrl+F on Windows. Find locates matching content but does not hide nonmatching rows. For summaries by category, a PivotTable may be more useful than manually filtering and counting. Choose Insert > PivotTable, then organize fields into the report layout; it summarizes data rather than repairing a broken filter. If you only need to see rows matching one condition, the standard filter remains the simplest option.

Frequently Asked Questions

Why does Excel filter only part of my data?
Excel may have identified a range that ends at a blank row or column. Remove unintended separators, select the complete list with its headers, and apply Data > Filter again. Converting a regularly updated list into a table can help include future rows.

How do I remove a filter without deleting rows?
Choose Data > Clear to remove filter criteria while leaving the data intact. To remove the filter arrows themselves, select a cell in the range and choose Data > Filter. Filtered-out rows are hidden, not deleted.

Why is the Filter button greyed out in Excel?
Check whether the worksheet is protected, multiple sheets are grouped, or you are still editing a cell. Protection settings may prevent changing filters. Ungroup sheets, finish editing, or ask the workbook owner to allow AutoFilter use.

Why does filtering a date column show unexpected results?
Some apparent dates may be stored as text, or the column may mix dates and text. Check representative cells and convert imported values carefully. Preserve identifiers and other values as text when their formatting is meaningful.

Does clearing a filter unhide manually hidden rows?
Not always. Data > Clear removes filter criteria, but rows hidden manually may remain hidden. Select the affected row range, right-click a row heading, and choose Unhide to reveal manually hidden rows.

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.