Excel Filter Not Working? How to Find and Fix the Cause

If your Excel filter is not working, first check that the filter covers the entire data range, that the first row contains distinct column headers, and that no filter criteria are hiding the rows you expect to see. In Excel for Microsoft 365 on Windows, click inside the data and choose Data > Filter; then inspect each column’s filter menu and clear any unwanted criteria.

How Excel filters rows

An AutoFilter adds a drop-down arrow to each column heading in a selected range. Choosing a value or condition hides rows that do not match; it does not delete them. A filtered worksheet can therefore appear to have missing records even though the records are still present and can reappear when you clear the filter.

Excel filters by column, and the criteria in different columns normally work together. For example, filtering Department to Sales and Region to West shows records that meet both conditions. Within a column, selecting multiple values generally shows rows matching any selected value. This distinction helps explain why a row may disappear after applying a second filter even though it matched the first.

A filter can only act on the range Excel recognizes as a list or table. If the range is incomplete, some rows will not have working drop-downs and may not respond to the criteria. The first checks should therefore be the filter range and the layout of the data, not the records themselves.

Check the filter range first

Click a cell in the data and look for filter arrows across the header row. If there are no arrows, choose Data > Filter. If arrows appear only over some columns, or new rows are unaffected, Excel may have applied the filter to only part of the dataset.

This commonly happens when a completely blank row or column separates the main data from later records. Excel often uses the contiguous block around the active cell when you turn on a filter. A title, note, or total placed immediately beside the data can also make it harder to select the intended range.

Click a cell in the middle of the records and check whether the filter arrows span every intended column.
If the range is wrong, turn off the current filter with Data > Filter, select the complete rectangular range including the headers, and choose Data > Filter again.
For data that will keep growing, consider converting the range to a table: select a cell in the data and choose Insert > Table. Confirm that the selected range is correct and that My table has headers is checked when appropriate.

Excel tables are useful because they carry formatting and structure into added rows, and their column headers include filter controls. They do not repair missing or inconsistent data, however. Confirm the table range and header setting when creating it, and check that newly pasted records are actually part of the table.

Make sure the headers and rows form one clean list

Each column should have one clear heading in the top row, and each record should occupy one row. Avoid a title above the headers inside the selected range, merged cells in the data block, and blank rows dividing one continuous list. These structures can cause Excel to interpret the range in unexpected ways or make sorting and filtering confusing.

Headers should be distinct. If two columns are both called Status, rename them to something specific, such as Order Status and Payment Status. Excel may alter duplicate table headers to make them unique, which can make the displayed names differ from the labels you expected.

Also check whether the filter is on the correct header row. A report may have a large title row, then a second row of actual column names. If you select the title row as the header, the filter menus will not offer the expected fields. Turn off the filter, select the real header row and records, and apply it again.

Merged cells are particularly troublesome in a sortable, filterable list because the same value is not independently stored in every row. Unmerge cells in the data area and, where needed, fill the value into each relevant row. Keep decorative report headings outside the list rather than merging them into its headers.

Clear criteria that are hiding the expected records

Look for a filter indicator on the column arrows. An ordinary arrow indicates a filter control; a funnel or other changed indicator signals that a filter is active. Open each column menu and review its selected values, search box, and any text, number, date, or color conditions. A criterion in a different column may be excluding the records you are looking for.

To remove all active filters while keeping the filter controls, use Data > Clear. To remove a criterion from one field only, open that field’s drop-down and choose the option to clear the filter from that column. The wording includes the column name. If filter arrows themselves are no longer needed, choose Data > Filter to turn AutoFilter off.

Be careful with search inside a filter menu. A search term narrows the list of available values, and selecting only the visible results can leave other values unchecked. Likewise, a number condition such as Greater Than is different from selecting a particular number. Reopen the menu to see which type of condition is active.

Date filters can be confusing when dates are grouped by year, quarter, or month. Expand the relevant group and verify the actual dates selected. If an entry that looks like a date is missing from the grouped list, it may be stored as text rather than as an Excel date value; formatting a text value to look like a date does not necessarily convert it.

Investigate blanks, data types, and inconsistent values

Excel treats many values as distinct even when they look similar. For example, Sales, sales, and Sales followed by a space may not appear as the same entry in a filter list. A pasted value can also contain nonprinting characters. If a filter misses a particular category, inspect the source cells directly and compare suspicious entries rather than assuming the filter has lost them.

Numbers stored as text can behave differently from numeric values in sorting and filtering. A column might contain the number 125 in one row and the text value 125 in another. Check for inconsistent alignment or warning indicators, and use a conversion method appropriate to the data before relying on numerical conditions. Do not convert identifiers such as postal codes or product codes blindly: leading zeros may be meaningful.

Empty-looking cells deserve a separate check. Some are truly empty; others contain a space, an apostrophe, or a formula that displays an empty string. These can behave differently in menus and conditions. Select the cell and inspect the formula bar, or check the source data, to find out whether it actually contains a value.

For a practical example, suppose a filter for East does not show a particular sales row. The row may have East followed by a space, may use a different spelling, or may already be excluded by a date filter in another column. Clear other criteria, inspect the exact cell contents, and then retry the filter.

Check hidden rows, protection, and worksheet state

Filtering is not the only way rows become invisible. Someone may have hidden rows manually, grouped them with an outline, or collapsed a group. Clearing a filter does not necessarily unhide rows hidden by those other methods. If expected records remain absent after clearing filters, select the surrounding row numbers, right-click, and choose Unhide, or expand any worksheet outline controls.

A protected worksheet may restrict changes to filter settings. If a drop-down is unavailable or Excel will not let you change the filter, check Review > Unprotect Sheet. You may need the password set by the workbook’s owner. Do not assume protection is the cause if the menus still work; first check the range and criteria.

Also verify that you are on the intended worksheet and viewing the intended workbook. In a shared file, a sheet view or another user’s changes can make the displayed rows differ from what you expect. Excel for Microsoft 365 supports Sheet Views for working with personal sort and filter views in shared workbooks; check the View tab for the active view and switch to the view you intend to use. Availability and behavior can depend on how the workbook is stored and shared.

Refresh the list after adding or changing records

When records are added below a filtered range, they may not be included if the original filter range stopped above them. Extend the range or convert the list to a table so new rows can be incorporated more reliably. If a new category does not appear in a filter menu, first confirm that the row is inside the filtered range and that its value is actually entered in the expected column.

If the data comes from an external connection or a query, changing the worksheet’s filter is different from refreshing the source data. Use Data > Refresh All when the workbook’s connected data needs an update, then check the filter range and criteria again. Refreshing may update the records, but it does not guarantee that a separate AutoFilter includes rows outside its range.

When the workbook contains formulas, a displayed result can differ from the underlying value or update only after recalculation. If a formula-driven field appears stale, check its formula and the workbook’s calculation settings rather than repeatedly clicking filter options. Filtering controls which rows are shown; it is not a substitute for refreshing a connection or fixing a formula.

A quick troubleshooting sequence

Use this order to isolate the cause without rebuilding the worksheet unnecessarily:

Open each column menu and clear unexpected criteria. If the data should show every record, use Data > Clear.
Check for manually hidden or grouped rows if records remain absent after clearing filters.
Confirm that the filter arrows span all the intended columns and rows. Reapply the filter to the full range if needed.
Inspect the header row for duplicate or misplaced labels, blank separators, and merged cells.
Compare missing values with visible ones for spaces, spelling differences, text-versus-number differences, and dates stored as text.
If the records are connected to an external source, refresh the connection and then verify the range once more.

On Windows, Ctrl+Shift+L toggles AutoFilter for a selected data range. On Mac, keyboard shortcuts can vary with the keyboard and Excel version, so Data > Filter is the dependable menu route. In Excel for the web, use the Data tab’s Filter command and inspect the same criteria and range issues; controls can look different from the Windows desktop ribbon.

Prevent filter problems in future workbooks

Keep raw records in a rectangular list: one header row, one record per row, and one type of information per column. Put notes, report titles, and subtotals outside that list. Use consistent spellings and data types, and avoid inserting blank separator rows between records.

For lists that regularly grow, use an Excel table rather than repeatedly selecting a fixed range. Before sharing a workbook, clear temporary criteria if other people need to see all records, or tell them which filters are active. A filter hides rows from the current view; it does not remove those rows from the workbook or change the source values.

Frequently Asked Questions

Why does my Excel filter show only some of my rows? One or more criteria may be active, or the filter may cover only part of the list. Choose Data > Clear, then check that the arrows span the full intended range.

How do I reset an Excel filter without removing the arrows? Choose Data > Clear to remove active filter criteria while leaving AutoFilter controls in place. Use Data > Filter only when you want to turn those controls off or on.

Why are new rows not included in my filter? The new records may be below the range to which the filter was applied. Extend the range or convert the records to a table, and verify that the new rows are included.

Why does Excel treat two values that look the same differently? They may contain extra spaces or hidden characters, use different spellings, or be stored as different data types, such as a number and text that looks like a number. Inspect the underlying cells and standardize the values where appropriate.

Does filtering delete or change rows? No. AutoFilter hides rows that do not meet the criteria; it does not delete them. Clear the filter to show matching and nonmatching records again, unless rows were separately deleted or hidden manually.

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.