Excel AutoFilter Not Working? How to Fix It

Errors & fixes · Updated November 19, 2026

If Excel AutoFilter is not working, check that the filter covers the entire data range, that the header row is recognized, and that no other filter or worksheet setting is interfering. In Excel for Microsoft 365 on Windows, select a cell in the data and choose Data > Filter; if arrows already appear, use Data > Clear, then Data > Reapply to reset the current criteria.

What AutoFilter does—and what “not working” can mean

AutoFilter adds dropdown arrows to column headings so you can show rows that match chosen values, text, dates, colors, or conditions. It hides rows that do not match; it does not delete them. That distinction matters: a filtered sheet can look as if records have disappeared even though they remain in the workbook.

People usually describe several different problems as an Excel filter error. The arrows may be missing, a dropdown may be unavailable, a selection may return no rows, or new records may not appear in the filter’s range. Sometimes the filter works but the visible result seems wrong because rows are hidden manually or because the data has inconsistent values. The right fix depends on which symptom you see.

Before making changes, save the workbook if it contains important data. If filtered rows are hidden, clear the filter and confirm the full list returns before deleting, copying, or editing records. Filtering is a view of the data, not a safe way to select only the visible records for every operation.

Try a quick filter reset first

Start with a cell inside the list, rather than selecting an entire worksheet. On the Data tab, choose Filter. If arrows disappear, choose Filter again to turn them back on. If arrows remain but the results look stale, choose Data > Reapply. Reapply updates the displayed results using the current criteria; it does not necessarily expand the filtered range to include new rows.

To remove criteria without removing the dropdown arrows, choose Data > Clear in the Sort & Filter group. You can also open a column’s dropdown and choose Clear Filter From [column name]. To turn AutoFilter off completely, choose Data > Filter. These are different actions: Clear removes active criteria, while Filter toggles the arrows and filtering controls.

On Windows, Ctrl+Shift+L toggles AutoFilter for the selected range. If the shortcut seems to do nothing, click a cell in the data first and check that the worksheet is not protected. On Mac, use Data > Filter if the keyboard shortcut differs in your Excel setup; shortcut behavior can vary with macOS and keyboard settings.

Check the range, headers, and blank rows

A frequent cause is that Excel has detected only part of the list. AutoFilter works on a contiguous range: a completely blank row or blank column can make Excel treat the data on either side as separate regions. If you start the filter in one region, records below a blank row may be left out.

Look for blank rows within the records, blank columns between fields, and a title or note placed directly above the actual headings. Put one clear header row immediately above the records, with one heading per column. Remove empty rows inside the list, or select the complete intended range before choosing Data > Filter. If you have a title, leave a blank row between it and the headers so it is not mistaken for a field name.

  • Click a cell in the data and inspect the outline of the range Excel selects when you press Ctrl+A. If it selects only part of the records, check for gaps or select the full range deliberately.
  • Make sure each column has a header. Avoid merged heading cells, empty headings, or multi-row headings; a simple one-row header is more reliable.
  • When adding records, enter them directly below the last row of the list without leaving a blank row. Then use Data > Reapply if needed.

Headers are not just decoration: Excel uses them to label the filter menus. Duplicate or vague headings can make the menus difficult to identify. Give each column a distinct, useful name, such as Order Date or Region, rather than leaving headings blank.

When the filter arrows are missing or unavailable

If the arrows do not appear, first confirm that you selected a cell in the data and that the workbook is not in a mode that prevents editing. A protected worksheet may restrict filtering, depending on how protection was configured. Check Review > Unprotect Sheet if you are authorized to unprotect it. If you do not know the password or do not own the file, ask its owner rather than trying to bypass protection.

Also check whether the range is part of an Excel table. Tables normally display filter arrows in their header row. If they are absent, click in the table and look for the Table Design tab; confirm that Header Row is enabled and that Filter Button has not been turned off. The exact controls can vary slightly with window size and ribbon layout.

Another possible source of confusion is multiple ranges on one worksheet. A worksheet’s ordinary AutoFilter applies to a range, while each Excel table has its own table controls. If a filter is already active on a different ordinary range, clicking Filter after selecting new cells may not create the separate filter you expect. Clear or turn off the existing ordinary filter, then apply it to the intended range. Tables are often a better choice when a worksheet contains separate lists.

When filtering gives the wrong results

Check the criteria before assuming Excel has lost data. A column can have multiple criteria active, and a filter on another column combines with them. For example, selecting East in Region and Pending in Status shows only rows matching both conditions. Clear the filters from all relevant columns to see whether the missing records return.

Values that look identical may not be identical to Excel. A column might contain a mixture of numbers stored as text and real numbers, or entries with leading or trailing spaces. A date imported as text may not behave like a true Excel date. Similarly, North and North followed by an extra space can appear alike in a narrow cell but be separate filter choices.

To investigate, clear the criteria and inspect a few source cells directly. Widen the column, check the formula bar, and compare suspicious entries. If data was imported, use the import or cleanup process appropriate to its source before filtering. Avoid using Find and Replace broadly until you understand what it will change; replacing text can alter legitimate values elsewhere in the selected range.

Manual hiding can also make results appear incomplete. Clearing an AutoFilter criterion does not necessarily unhide rows hidden with the Hide command. Select the affected row numbers, right-click, and choose Unhide, or use Home > Format > Hide & Unhide > Unhide Rows. Then check whether the rows return. Hidden columns can similarly make fields seem missing without changing the filter itself.

New rows do not appear in the filter

If you add data outside the range AutoFilter covers, the new rows may not appear in the dropdown’s available values and may not be filtered with the rest of the list. This commonly happens when there is a blank row between the original data and the additions, or when records are pasted below a fixed range.

Check the selected range before applying the filter. If necessary, turn off AutoFilter, select all headers and records, and turn it back on. For ongoing lists, convert the range into a table using Insert > Table, then confirm that My table has headers is selected when appropriate. A table expands as you add data directly below it, which helps keep new records within the structured list. If data is pasted with gaps or far outside the table, confirm that the table actually expanded.

Do not assume that clicking Reapply expands every range. Reapply refreshes filtering on the existing range. It is useful after changing cell values, but you should inspect or resize the range when records have been added outside it.

Tables, ordinary ranges, and other options

For a single, growing dataset, an Excel table is usually the easiest option. Click inside the data and choose Insert > Table, then verify the header setting. Tables provide filter buttons and expand when data is added in the expected location. They also support structured references in formulas, but you do not need to use those formulas just to filter records.

An ordinary range can be preferable for a small, temporary list or when the worksheet layout does not suit a table. It still supports AutoFilter, but you must take more care that the selected range includes all records. Neither approach repairs inconsistent source data or removes manually hidden rows; those need separate checks.

For more advanced reporting, a PivotTable or a separate summary may be more suitable than repeatedly filtering a source list. A PivotTable summarizes data and provides its own filtering controls, but it is not a replacement for correcting missing or malformed source records. Choose the approach based on whether you need to inspect individual rows, maintain a growing list, or summarize information.

Differences in Excel for Mac and the web

The main troubleshooting principles are the same in Excel for Microsoft 365 on Mac and Excel for the web: check the data range, header row, criteria, and protection status. Ribbon placement and shortcuts can differ. If a Windows shortcut does not work on a Mac, use the Data tab’s Filter, Clear, or Reapply controls rather than assuming the feature is unavailable.

In Excel for the web, commands and ribbon options may be arranged differently, and some workbook features can be limited compared with the desktop application. If a control is missing or a protected workbook prevents a change, open the workbook in the desktop app if you have access and permission. Be mindful when several people are editing a shared workbook: another user may change cell values or filters while you are diagnosing the view.

Frequently Asked Questions

Why does Excel say there are no items to filter?
There may be an active criterion, an incomplete range, or values in the column that are blank or inconsistent. Clear the filters, verify the range includes the records, and inspect the source values for text-number or date-text differences.

Why does AutoFilter skip rows below a blank line?
A completely blank row can split a list into separate regions. Remove the gap or select the full intended range before applying Filter. For lists that grow, consider converting the data to a table.

Does Clear Filter delete rows?
No. Clear removes filter criteria so matching and nonmatching rows can show again. It does not delete the underlying records. Check for manually hidden rows separately if some remain out of view.

Why are new records missing from the dropdown?
The records may sit outside the range AutoFilter is using. Extend or reapply the filter to the complete range, or add records directly below an Excel table so the table can expand.

Can I filter a protected worksheet?
Only if the worksheet’s protection settings allow filtering. Ask the workbook owner to enable the required permission or provide an unprotected copy; do not try to circumvent a password.

What is the difference between Clear and Reapply?
Clear removes the current filter criteria. Reapply refreshes the results using the criteria already set. Neither command should be confused with turning AutoFilter off, which removes the dropdown controls.

Related

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.