Excel Filter Not Working? Fix the Most Common Causes

If an Excel filter is not working properly, first check that it covers the entire data range and that each column has a clear, unmerged header; then clear existing filters and apply one again using Data > Filter. Many apparent filter failures come from blank rows splitting the data, a filter applied to only part of the list, or criteria that exclude the rows you expect.

What an Excel filter does—and what it does not do

Excel’s AutoFilter hides rows that do not meet the selected criteria; it does not delete those rows or change their values. When a filter is active, the row numbers may skip, and a filter-arrow icon may show that a column has a criterion applied. Clear the criterion to display the hidden records again.

Filters work on a rectangular range with a header row. Excel uses each header to label a column’s filter menu, so a heading such as Region or Order Date is more useful than a blank cell or a merged heading spanning several columns. A filter can sort as well as narrow the visible rows, but sorting and filtering are different operations: clearing a filter restores visibility, not necessarily the original row order.

On Excel for Microsoft 365 for Windows, select a cell in the data and choose Data > Filter. You can also toggle filters with Ctrl+Shift+L. On a Mac, use Data > Filter on the ribbon; keyboard shortcuts can vary with keyboard settings and Excel version. In Excel for the web, use Data > Filter or the filter controls on the table or range.

Check the filter’s range and header row

A filter arrow can appear to work while missing records if its range does not include all the data. This often happens when rows were added below a filtered range, when the filter was applied after selecting only a few columns, or when an empty row separates older records from newer ones. Inspect the top and bottom edges of the range, not just the visible arrows.

Click inside the list and choose Data > Filter to turn the current filter off, then click inside the complete dataset and choose Data > Filter again.
Check that the header row is included and that every column has a header. Use one row of distinct labels, rather than blank, merged, or repeated headings.
Look for fully blank rows or columns inside the records. A blank row can make Excel treat the entries below it as a separate block.
If you need a dependable range that grows as records are added, select the data and choose Insert > Table. Confirm that My table has headers is selected when appropriate. Table filter arrows apply to the table’s columns.

When converting a range to a table, check that the selected range includes every intended record and field. A table is not a cure for inconsistent data, but it makes the boundaries explicit and normally includes new rows added directly beneath it.

Clear old criteria before diagnosing a problem

A filter may be functioning correctly but still hide the records you are looking for because a criterion remains active in another column. For example, filtering City to Seattle and then filtering Status to Open shows only rows matching both conditions. A matching city row with a Closed status will remain hidden.

To clear one column’s criterion, open that column’s dropdown and choose Clear Filter From followed by the column name. To remove filtering criteria across the current range, choose Data > Sort & Filter > Clear. The Clear command removes filter criteria but leaves the filter arrows in place; choose Data > Filter to turn the arrows off. If Clear is unavailable, check whether the active cell is inside the filtered range and whether a filter is currently applied.

Also check the menu’s search box and selections. A typed search term or a partially checked list can narrow results unexpectedly. For date and number filters, inspect the selected comparison and boundaries. A condition such as greater than 100 will not include 100, while greater than or equal to 100 will. Custom filters can combine two conditions with AND or OR, producing different results.

Blank cells, mixed data types, and inconsistent values

Values that look alike may not be alike to Excel. A column containing the number 25 in some rows and the text value 25 in others can behave unexpectedly in sorting and filtering. Numbers stored as text may be left-aligned by default or show a warning indicator, but formatting alone is not conclusive. Check how the values were imported and whether they are genuinely numeric.

Dates are a common source of confusion. Excel stores recognized dates as serial numbers and displays them using date formats. Text that merely looks like a date may not be grouped or compared in the same way. If a date filter does not show the expected month or year, verify that the cells contain real dates, not text, and check for entries with different formats or extra spaces.

Blank-looking cells can also contain spaces or formulas that return an empty string. Such cells may not behave like truly empty cells in the filter menu. Conversely, choosing a blank-related option can include records that appear empty but contain invisible characters. Inspect suspicious cells in the formula bar, remove unintended spaces, and standardize the column before filtering.

For categories, inconsistent spelling creates separate filter choices: North, north, and North with a trailing space may appear as distinct entries. Standardize the source values when they are intended to mean the same thing. Avoid replacing data blindly; first confirm which differences are errors and which represent meaningful categories.

When filter arrows are missing or unavailable

If the arrows have disappeared, the filter may have been toggled off, the selected range may not include the headers, or the data may be inside a table whose filter buttons were hidden. Click in the data and choose Data > Filter. For a table, click inside it and check the Table Design tab for the Filter Button option. The tab appears when a table is selected.

Filters can also be unavailable because of workbook or sheet restrictions. A protected sheet may prevent users from changing filter settings unless filtering is allowed in the protection options. In Excel for Windows, check Review > Protect Sheet and the permissions selected for the sheet; changing protection may require the password set by the workbook owner. If the file is read-only or you lack editing permission, ask the owner for access rather than trying to bypass the restriction.

Hidden rows can make results confusing too. A manually hidden row stays hidden independently of the filter, so clearing the filter may not reveal it. Select the surrounding row numbers, right-click, and choose Unhide, if you are authorized to change the sheet. Grouped or outline-hidden rows may also need to be expanded separately.

Use tables and structured data for recurring lists

For a list that changes regularly, an Excel table is often easier to maintain than a manually managed range. Select the records, choose Insert > Table, and confirm the header setting. Tables add filter controls to their header row and generally expand when adjacent records are entered directly below them. They also provide structured formatting and references, though those features are not required to filter.

Keep each record on one row and each type of information in its own column. Avoid inserting subtotal rows, blank separator rows, or multiple header rows inside the dataset. Those layouts may look attractive for printing but make filtering less predictable. If a report needs section headings or totals, consider keeping the source records in a clean table and building a separate presentation or summary view.

Do not confuse a table filter with a worksheet filter applied to a selected range. Both hide nonmatching rows, but a table defines its own boundaries and has table-specific controls. If results seem incomplete, click a cell inside the table and verify the table range from Table Design rather than assuming every nearby row belongs to it.

A practical troubleshooting sequence

Use this order to isolate the cause without changing the underlying records unnecessarily:

Save a copy if the workbook is important, especially before cleaning or restructuring imported data.
Clear the existing criteria with Data > Sort & Filter > Clear, then confirm whether the missing rows return.
Turn the filter off and inspect the full dataset for blank separator rows, missing headers, merged cells, or records outside the selected range.
Reapply the filter to the complete range, or convert a well-formed range to a table using Insert > Table.
Test one column with a simple selection, then add other criteria one at a time. This identifies which column is excluding the expected records.
Check suspicious values for text-versus-number differences, dates stored as text, extra spaces, and manually hidden rows.
If controls remain unavailable, check sheet protection, file permissions, and whether you are working in a view or copy that permits editing.

Testing one condition at a time is particularly useful with a large dataset. Suppose a sales list should show every order from April but returns none. First clear all criteria, then filter only the Order Date column for April. If the month appears after clearing a different column, the issue was a combined criterion; if it does not, inspect the dates and range boundaries.

Differences across Excel versions

The basic AutoFilter controls are available in current desktop Excel and Excel for the web, but ribbon layout and some table controls can differ. On Windows, the path used here is Data > Filter. On Mac and in the browser, use the Data tab’s Filter command if the Windows keyboard shortcut is not available or behaves differently. Menu labels can also vary slightly by release.

Some newer Excel features, such as the FILTER worksheet function, are separate from the dropdown filters described above. The FILTER function returns a formula-driven result from a range based on criteria; AutoFilter hides rows in the original list. If dropdown arrows or visible rows are the problem, changing a FILTER formula is usually not the right first step. Dynamic-array functions such as FILTER are available in Microsoft 365 and Excel 2021 or later, while older versions may not support them.

Frequently Asked Questions

Why is Excel not showing all rows after I clear the filter?
Some rows may be hidden manually, grouped, or outside the filtered range. Check row numbers for gaps, unhide rows if appropriate, expand outlines, and verify that the filter range includes every record.

Why does my filter not include new rows?
The rows may have been added outside the filtered range, especially if a blank row separates them from the original data. Reapply the filter to the complete range or use an Excel table and add records directly beneath it.

Why does the filter dropdown show different versions of the same value?
Values may differ by capitalization, spaces, punctuation, or data type. Inspect the cells and standardize only entries that truly represent the same category.

Why can I not click Filter in Excel?
The worksheet may be protected, the file may be read-only, or the active selection may not be in the intended data range. Check editing permissions and protection settings, then select a cell in the dataset.

Does clearing a filter delete hidden rows?
No. Clearing a filter makes rows that fail the criteria visible again; it does not delete them. Deleting rows is a separate action, so check the command before confirming any deletion.

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.