Microsoft Excel Filter Not Working? Fix Common Causes

If a Microsoft Excel filter is not working, first select a cell in the data and choose Data > Filter, or press Ctrl+Shift+L on Windows to turn the filter buttons off and back on. Then check that the data is one continuous range with a single, clearly labeled header row; most missing or unfilterable records come from range boundaries, blank rows, or inconsistent values.

Start by identifying what is going wrong

“Filter not working” can describe several different problems, and the right fix depends on the symptom. The arrows may be missing, a filter menu may omit values you can see in the worksheet, choosing a criterion may return no rows, or new records may not respond to the existing filter. A filter can also be working correctly while rows are hidden for another reason, such as manual hiding or a separate filter on a different table.

Before changing the data, note which rows are visible and whether any filter icon appears different from the others. A funnel on a column button generally indicates that a condition is active; a plain drop-down arrow usually means the column has no active criterion. If the status bar reports that only some records are visible, that can confirm a filter is excluding rows, but it does not identify which condition is responsible.

If there are no arrows, check whether Filter is switched on and whether the sheet is protected.
If an expected value is absent from the menu, inspect the selected range and the actual cell contents.
If the menu accepts a condition but shows no records, clear the condition and check for text-versus-number or date inconsistencies.
If added rows are ignored, expand the source range or convert the data to an Excel table.

Turn the filter on for the right range

In Excel for Microsoft 365 on Windows, click inside the data and choose Data > Filter. The Windows shortcut Ctrl+Shift+L toggles AutoFilter. On a Mac, use Data > Filter; keyboard shortcuts can differ with the keyboard layout and macOS settings, so the ribbon command is the dependable option. Excel for the web also provides Filter on the Data tab.

Excel uses the nearby data region to decide which cells belong to the filter. If the active cell is outside that region, or the region is split by a completely blank row or column, Excel may apply buttons to only part of the information. To set the range deliberately:

Click a cell inside the records and inspect where the contiguous block begins and ends. Remove accidental blank rows or columns that split the records, if appropriate.
If Excel selects only part of the data, select the full rectangular range, including its header row, before choosing Data > Filter.
Check that every column in the range has a header and that there is only one header row.
Open a filter menu and verify that values from the first and last records are represented where appropriate.

A filter on a plain range applies to one contiguous block, not a collection of separate selections. If a worksheet has unrelated lists, filter each list as a separate Excel table rather than trying to treat distant blocks as one range. The outline of the selected range matters: a row just beyond it will not appear in that filter’s results even if it looks like part of the same report.

Check headers, blank rows, and merged cells

AutoFilter expects the first row of its range to contain column labels and the remaining rows to contain records. A title, subtitle, or second header row included above the labels can make Excel treat the wrong row as the headers. Move decorative titles outside the filter range, or select the range starting at the actual field names. Use distinct, nonblank labels such as Date, Region, and Amount so each menu is easy to identify.

A completely empty row or column can divide a list into separate regions, which is a common reason the filter stops before the newest records. A blank cell within a column is different: it is a value that can be included or excluded using the menu’s blank-value option. Avoid inserting decorative blank lines between records when the range needs to behave as one dataset.

Merged cells are another poor fit for a sortable, filterable table. A merged heading across several columns may be useful for presentation, but merged cells inside the records can interfere with selecting, sorting, and filtering a rectangular range. Unmerge cells in the data area and put one value in each appropriate cell. If a merged title must remain, keep it above and outside the filtered range.

Why the filter menu may omit values

The filter menu lists values found in the range it is filtering, not every value visible anywhere on the worksheet. If a record is outside the range, its value will not appear. If the range is correct, look for small differences that are easy to overlook: an extra space, different punctuation, a spelling variation, or a value stored as a different data type.

For example, a Region column might contain North, North followed by a space, and NORTH. They can look nearly identical in the grid but are distinct text entries. Likewise, a column that appears to contain numbers can mix numeric values with numbers stored as text. A numeric filter such as Greater Than may not treat the text entries as numbers, and text filters may not behave as expected on numeric cells. Dates imported from another system can also be text rather than Excel date values.

Check a suspicious cell by selecting it and looking at the formula bar and number format. A format change alone does not always convert text into a number or date. Use a consistent import or conversion method, and confirm the results before applying a condition. For text, clean up unwanted leading or trailing spaces in the source where necessary; do not remove spaces indiscriminately if they are meaningful in the data.

Also distinguish filtering from sorting. A filter hides rows that do not meet a condition; it does not delete them. Sorting changes row order. If the expected records are still present but appear elsewhere in the list, clear or review the sort order rather than assuming the filter removed data.

Clear, reapply, or reset filter criteria

A condition from an earlier task can remain active even when the visible rows make the sheet seem incomplete. Open each column’s menu and check its selected values or criteria. In Excel for Microsoft 365 on Windows, use Data > Clear in the Sort & Filter group to clear the active filter criteria for the range without deleting the records. You can also open a specific column’s menu and choose the option to clear its filter. The wording identifies the column, such as Clear Filter From Region.

Clearing conditions is not the same as turning off the filter buttons. Data > Filter, or Ctrl+Shift+L on Windows, toggles the buttons. Turning them off removes the drop-down arrows but does not delete or change the underlying data; check the visible rows after toggling because the sheet’s display state can be confusing. On Mac, use the Data tab’s Filter command and check the resulting rows rather than relying on a Windows shortcut.

After changing source values, use Data > Reapply when the current results do not reflect the updated data. Reapply runs the existing criteria against the range again; it does not expand a range that excludes new rows. If a row was added below the filtered range, first expand the range or use a table, then reapply the condition.

Make sure rows are not hidden for another reason

Clearing a filter may not reveal every missing row. Rows hidden manually through the row headings can remain hidden after filter criteria are removed. Select the row headings around the gap, right-click, and choose Unhide, or use Home > Format > Hide & Unhide > Unhide Rows. If the row numbers skip—for example, the worksheet goes from 12 to 18—some rows may be hidden manually or by a filter.

Grouped or outlined rows can also be collapsed, and a worksheet view may make records appear absent. Check for outline controls beside the row numbers and expand the relevant group. If the data is in a separate Excel table, make sure you are opening the filter button for that table rather than another list on the same sheet. These checks help distinguish a filter condition from a display or layout issue.

Check sheet protection and table settings

When Filter is unavailable or filter menus cannot be changed, check whether the worksheet is protected. On Windows, Review > Unprotect Sheet removes protection if you have permission and the required password. If you are setting up protection, Review > Protect Sheet includes permissions that control what users can do. Filtering must be allowed for users to use existing AutoFilter controls on a protected sheet; sorting and editing are separate permissions. A protected workbook may also restrict structural changes.

For frequently updated lists, convert the range to an Excel table with Insert > Table or Ctrl+T on Windows. Confirm that the selected range includes the headers and that My table has headers is checked when appropriate. Tables provide filter buttons and usually expand when records are added directly in the row below them. They also make it clearer which cells belong to a dataset.

Tables are useful, but they do not repair inconsistent data or include records placed far away from the table. If an added record is not part of the table, place it directly below the last table row or resize the table. On Mac, use Insert > Table or the Table command available on the ribbon; the dialog and shortcut may vary by version. A plain filtered range may be preferable for a one-off list, while a table is often easier to maintain as a report grows.

A reliable troubleshooting order

When a filter still behaves unexpectedly, work through these checks in order so you do not make unnecessary changes to the data:

Save a copy if the workbook is important, especially before restructuring imported data.
Clear active criteria and confirm whether the missing rows return.
Check for manually hidden or grouped rows.
Verify the filter range includes every intended row and column, with one header row and no separating blank row or column.
Inspect suspicious entries for spaces, mixed data types, or inconsistent date formats.
Check sheet protection, then reapply the filter after correcting the source or range.

If the workbook comes from another person or an external export, preserve an untouched copy before cleaning values. A visible value can be stored differently from its neighbors, and a bulk conversion can change identifiers such as product codes or postal codes that should remain text. The goal is consistent data appropriate to the field, not forcing every column into a numeric format.

Frequently Asked Questions

Why are the filter arrows missing in Excel?
Click inside the data and choose Data > Filter. If the arrows still do not appear, verify that the range is valid and the worksheet is not protected. On Windows, Ctrl+Shift+L toggles AutoFilter; on Mac, use Data > Filter.

Why does Excel show only some of my rows after I clear the filter?
Some rows may have been hidden manually or belong to a collapsed outline group. Unhide the affected rows or expand the group. Also check whether a different table or range has its own active filter.

Why is a value missing from the filter drop-down list?
The value may be outside the filter range, or its cell may contain a slightly different spelling, extra space, or different data type. Confirm the range reaches the record and inspect the source cell rather than relying only on how it looks in the grid.

Why does my filter ignore new rows?
The rows may be outside the filtered range. Expand the range, or add records directly below an Excel table so it can include them. Then use Data > Reapply if the existing criteria do not update the visible results.

Does clearing an Excel filter delete hidden records?
No. Clearing a filter removes the criteria that hide nonmatching rows; it does not delete those records. Confirm that the rows return, and remember that manually hidden rows may need to be unhidden separately.

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.