Excel Filter Not Working? Common Causes and Fixes

When an Excel filter is not working, the cause is usually an incomplete data range, a blank or confusing header row, a filter condition that does not match the cell values, or a worksheet setting that blocks filtering. In Excel for Microsoft 365 on Windows, start by selecting a cell in the data, choosing Data > Filter, and checking that the arrows appear on the correct header row; then clear and reapply any criteria.

First identify what is failing

Not working can describe several different problems, and the fix depends on which one you see. The filter arrows may be missing or disabled, a dropdown may not include all the rows you expect, or a filter may hide nothing even though matching records seem to exist. Sometimes the filter works, but rows remain hidden because they were hidden manually or because another column still has an active condition.

Check the symptoms before changing the data. If there are no dropdown arrows, look at the selected range, worksheet protection, and whether you are editing a cell. If arrows appear but some records are missing, inspect the range and the values in the relevant column. If the results look stale after editing a cell, clear and reapply the filter. These checks help distinguish a setup problem from a criterion that simply does not match.

Check the range Excel is filtering

Excel applies an AutoFilter to a specific range. If you click inside a contiguous block of data and turn on Filter, Excel usually identifies the surrounding region. A completely blank row or column can make Excel treat part of the data as a separate region, so records below that gap may be left outside the filter. A new column added beside the original data can also be excluded if it is separated by a blank column.

Turn off the existing filter with Data > Filter, remove accidental blank rows or columns within the dataset, and select the full range including its headers before turning filtering on again. For example, if a list runs from A1 to D250 but a blank row separates rows 1–100 from 102–250, selecting a cell in the first block may not include the second block. Check the last row and last column, not just the first few records.

When records are added later, make sure they remain inside the filtered range. Excel tables are usually more reliable for growing lists because new rows added directly beneath a table are included as it expands. If using a normal range, you may need to remove and recreate the filter with the complete range selected.

Use a clear, single header row

Each column should have one distinct header in the top row of the filtered data. Blank headers, duplicate names, merged header cells, and title text above the real headers can make the dropdowns appear on the wrong row or make the filter difficult to use. Excel may create generic labels for blank table headers, while merged cells can interfere with selecting, sorting, or filtering a consistent rectangular range.

Put the actual column names in one row, such as Date, Region, and Amount.
Remove merged cells from the data area; unmerge them and repeat a label if needed.
Move report titles and notes above the dataset, leaving a clear gap or formatting them separately.
Use one value per cell and one record per row rather than combining multiple records in a cell.

To make the list easier to manage, click inside it and choose Insert > Table, confirm the range, and indicate whether the table has headers. In Excel for Microsoft 365, a table adds filter arrows to its header row and normally expands when you add rows next to it. Do not include unrelated notes or totals in the table range, since they can then be treated as records.

Clear criteria and test the dropdown

Filters in different columns work together: a row must satisfy the active conditions across those columns to remain visible. Within one column, selecting several listed values generally shows rows matching any of those selected values. A filter on Region set to East and a filter on Status set to Open will therefore show only records meeting both conditions. A second active filter can make it seem as if the first one is failing.

To start fresh, choose Data > Sort & Filter > Clear. This clears filter criteria while leaving the filter controls available. You can also open a column dropdown and choose Clear Filter From that column. Then apply one simple condition and see whether the expected records appear before adding more conditions. The dropdown icon can indicate that a column has an active filter.

Look closely at the condition type. Text Filters, Number Filters, and Date Filters offer different choices, and a condition such as Begins With will not find a value that only contains the search term in the middle. For text searches, Excel supports wildcard characters: an asterisk matches any number of characters, a question mark matches one character, and a tilde can be used to search for a literal wildcard. The dropdown search box is also useful for locating a value in a long list.

Check for inconsistent data types and values

Cells that look identical on screen may not contain identical values. A number stored as text is different from a numeric value for many filtering and sorting purposes. Dates can also be stored as text, and values may contain leading or trailing spaces or nonprinting characters. These differences can split what looks like one category into several entries or cause a filter condition to miss records.

For example, a column may contain both the number 25 and the text value 25. If filtering for one type, Excel may not treat the other as an exact match. Likewise, East and East followed by a space can appear the same in a narrow cell but be separate text values. Check a few affected cells in the formula bar, widen the column, and use consistent number and date formats. Formatting changes how a value looks; it does not necessarily convert text into a real number or date.

For a persistent cleanup, correct the source values consistently rather than trying to compensate with a complicated filter. You can use Excel’s error indicators or conversion options when available, or clean a copied dataset with suitable text and data tools. If the data comes from a report export or another system, review how that source formats dates, numbers, and spaces before importing it again.

When filter controls are missing or unavailable

If Data > Filter is unavailable, first finish editing the current cell by pressing Enter or Esc. Check whether multiple worksheet tabs are selected; grouped sheets can disable or restrict some commands, so right-click a selected tab and choose Ungroup Sheets. Also check whether the sheet is protected. A protected worksheet can prevent users from applying AutoFilter unless the protection settings allow it.

On Windows, the filter toggle shortcut is Ctrl+Shift+L. On Mac, use Data > Filter if the keyboard shortcut differs in your Excel setup. The ribbon path is a useful check because it makes clear whether the command is available. In Excel for the web, use the Data tab and its Filter command; some workbook controls and protection options can differ from the desktop app.

If a file opens in Protected View or read-only mode, editing and some data actions may be restricted. Only enable editing when you trust the file and its source. If the worksheet is protected, ask its owner for permission or for an unprotected copy rather than trying to bypass the protection.

Reapply filters after data changes

A filter can appear out of date if the underlying values change while criteria are active. For example, a row may have been hidden because its Status was Closed; if you change the cell to Open, the row may not immediately appear under the current filtered view. Choose Data > Sort & Filter > Reapply to update the displayed results. You can also clear the conditions and apply them again.

Check the range again if the changed record is a newly added row. Reapplying updates a filter within its range; it does not necessarily add data that sits outside that range. If you frequently append records, use a properly defined Excel table or update the filtered range when necessary.

In a workbook shared with other people, a change to the visible filter can affect what collaborators see, depending on how the workbook and view are being used. Excel’s Sheet View feature can provide a separate view for filtering in supported Microsoft 365 workbooks. Look under View > Sheet View if you need to sort or filter without changing the view for other people. Availability can depend on the workbook being stored in a supported shared location.

Distinguish filtering from other hidden-row causes

AutoFilter hides rows that do not meet the active criteria; it does not delete those records. But rows can also be hidden manually, grouped with the outline controls, or concealed by another feature. Clearing the filter does not necessarily reveal rows hidden by those other methods. If expected rows still do not show after choosing Clear, select the surrounding rows, right-click a row heading, and choose Unhide. If outline levels are present, expand the relevant group.

Also check for another filter mechanism, such as a slicer connected to a table or PivotTable. A slicer selection can restrict the displayed records independently of the ordinary column dropdowns. PivotTable filters operate on the PivotTable’s fields and source data, not like a plain worksheet range filter. Identify which control is affecting the view before assuming the worksheet AutoFilter is broken.

Frequently Asked Questions

Why does Excel filter only part of my list?
Excel may have detected a smaller contiguous range because of a blank row or column, or later records may have been added outside the filter range. Select the full dataset, including headers, and recreate the filter; consider using an Excel table for a list that grows.

Why is the Filter button greyed out in Excel?
Finish editing the current cell, ungroup any selected worksheet tabs, and check whether the sheet is protected. Protection settings can block AutoFilter unless filtering is permitted. Read-only or Protected View files can also limit editing actions.

Why does Excel show no results when I filter?
Clear all filters and test one condition. The requested value may differ because of extra spaces, text-versus-number differences, a date stored as text, or another active filter in a different column.

Why do new rows not appear in my filtered list?
The rows may sit outside the current AutoFilter range. Reapply the filter for changes within the range, or expand the range to include new records. A table often expands when rows are added directly below it.

Does clearing a filter unhide every row?
No. Clearing removes filter criteria, but it does not necessarily unhide rows hidden manually or collapsed in an outline. Use Unhide or expand the outline if rows remain missing.

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.