Can’t Filter in Excel? Causes, Fixes, and Workarounds

Formulas & functions · Updated November 19, 2026

Yes—Excel can filter a list or table, but the Filter command may be unavailable, the dropdown arrows may be missing, or a filter may appear not to work. In Microsoft 365 for Windows, select a cell in the data and choose Data > Filter, or press Ctrl+Shift+L; then check the range, headers, and any active filters if the result is still wrong.

Why filtering can seem unavailable

Excel’s filter feature hides rows that do not meet selected criteria; it does not delete those rows. When filtering is set up, dropdown arrows appear in the header cells. If those arrows are absent, the filter may be turned off, applied to a different range, or blocked by the workbook’s structure or protection settings. If arrows are present but the expected records do not appear, the issue is more likely to be the criteria or the way the data is arranged.

Before changing anything, note whether you are working in an Excel table or an ordinary cell range. Tables usually have their own header dropdowns and expand when new adjacent data is added. A range requires Excel to identify the boundaries of the list. In either case, a clear, single header row and consistent columns make filtering more reliable.

Filtering can also be confused with sorting. Sorting changes the order of rows; filtering hides rows that do not match. A filter may leave only a few records visible even though the rest are still in the worksheet. Look at the row numbers: if they skip, some rows are hidden by a filter or hidden manually.

Start with a quick filter reset

For a straightforward list, try these steps before rebuilding the data. They restore the filter controls without changing the underlying values:

  1. Click a cell inside the data you want to filter. If the list is separated from other data, select the full range, including its header row.
  2. On the ribbon, choose Data > Filter. If the command is already on, choosing it can turn the dropdowns off; choose it again to turn them back on.
  3. If arrows appear, open a dropdown and choose Clear Filter From [column name], or select the relevant values again.
  4. Check whether any rows remain hidden. If necessary, select the rows around the list, right-click a row number, and choose Unhide. A filter and manually hidden rows are separate things.

On Windows, Ctrl+Shift+L toggles AutoFilter for the selected range. On Mac, use Data > Filter if the shortcut differs in your Excel version or keyboard settings. Excel for the web also offers the Filter command on the Data tab, though the ribbon layout can differ slightly from desktop Excel.

Check the headers and the selected range

A filter needs a clearly defined set of columns and a header row. Give every column a nonblank, descriptive heading, such as Date, Region, and Amount. Avoid merged header cells and multiple rows of headings. If the data has a title above the actual column names, start the filter selection at the column-name row rather than including the title as part of the list.

For example, suppose A1:C6 contains headings in row 1 and five records beneath them. Clicking a cell in that block and choosing Data > Filter should put arrows in A1:C1. If the actual records begin in row 3, selecting A1:C6 may cause Excel to treat the title and blank row as part of the data. Select the true header-and-record range instead.

Blank rows or columns inside a list can make Excel treat it as separate blocks. When a blank row splits a list, clicking one cell may apply a filter to only the block above or below it. Remove unnecessary separators, or select the entire intended range before choosing Filter. Also check that there are not stray values immediately beside the list that could make Excel include unrelated columns.

If the data is a table, click inside it and look for dropdown arrows in its header row. To create a table from a plain range, select the data and choose Insert > Table; confirm that My table has headers is selected if the first row contains headings. A table is useful when the list will grow, but it is not required for ordinary filtering. Do not convert the data if its current layout or workbook rules make a table unsuitable.

When Filter is greyed out or arrows disappear

If Data > Filter is greyed out, first check whether the worksheet is protected. Protection can restrict changes to filters, depending on how the sheet was protected. If you have permission, choose Review > Unprotect Sheet and enter a password if prompted. If you do not know the password, contact the workbook owner rather than trying to bypass protection. When protecting a sheet, the owner can allow users to use AutoFilter, but the filter must already be applied to the range before protection.

Also check whether you are editing a cell. Press Enter or Esc to finish or cancel the edit, then try the command again. If the workbook is read-only or opened with limited permissions, you may be able to inspect data but not change the filter setup. Save an editable copy only if you are authorized to do so and understand how that affects shared work.

Arrows can disappear if someone toggled Filter off or changed the filtered range. In a table, the filter controls are part of the table header; in a normal range, they are added and removed with the Filter command. If a range has been converted or reorganized, select the intended list again and reapply the filter. Avoid selecting an entire worksheet when the goal is to filter one small list, because unrelated content can complicate the range Excel identifies.

Why a filter may return the wrong rows

Filter criteria depend on the values Excel recognizes, not just on how those values look on screen. A column that appears to contain dates may include text entries that resemble dates. Similarly, numbers stored as text may not behave like numeric values. Mixed types can cause the dropdown to offer unexpected categories or make date and number filters inconsistent. Check a few affected cells, and correct the underlying data type where appropriate.

Extra spaces and inconsistent spelling are another common cause. For example, North, north, and North followed by a space may be treated as distinct text values. If a filter for North misses some records, compare the source cells and standardize the entries. A visible value may also be produced by a formula, so consider the formula’s result rather than assuming the displayed text is typed directly into the cell.

Filtering across columns combines conditions: choosing one region in the Region column and one year in the Year column normally shows rows that meet both selections. Within a single dropdown, selecting multiple values can show rows matching any of those selected values. For more precise conditions, use the dropdown’s Text Filters, Number Filters, or Date Filters options when they are available. Clear filters on all relevant columns if you are unsure which condition is excluding a record.

A dropdown list may not show every distinct value in very large data. Excel’s AutoFilter dropdown is limited to displaying 10,000 unique items. That is a limit on the displayed checklist, not a claim that the worksheet contains only 10,000 records. Use the dropdown search or an appropriate text, number, or date filter to locate a value that is not visible in the list.

Blanks, hidden rows, and other edge cases

Blank cells can be included or excluded through the dropdown’s (Blanks) choice. A cell that looks blank may contain a formula returning an empty string, a space, or another invisible character; those are not always treated like a genuinely empty cell. If blank filtering produces surprising results, inspect the cells and standardize how missing values are represented.

Manually hidden rows are not the same as rows hidden by a filter. Clearing filter criteria may not reveal rows that were hidden separately. Likewise, rows hidden by grouping or outline controls may stay hidden. If the visible record count seems too low after clearing filters, select the surrounding rows and use Unhide, and check for outline controls along the worksheet margin.

Filtering a shared or coauthored workbook can affect what another person sees, depending on the workbook and view being used. Excel’s Sheet View can let people create their own sorting and filtering view in supported Microsoft 365 workbooks. If a colleague reports that your filter changed their view, check whether you are using a personal Sheet View or the default view, and coordinate before changing shared data.

Excel desktop, Mac, and web differences

The basic approach is the same in Excel for Microsoft 365 on Windows, Excel for Mac, and Excel for the web: select the data and use the Filter command on the Data tab. Ribbon placement, shortcut behavior, and some dialog details can vary by platform or version, so the menu is the most dependable route when a shortcut does not work. In the web version, editing permissions and browser display can also affect which commands are available.

Some advanced filtering workflows differ from basic AutoFilter. For example, dynamic-array formulas such as FILTER are available in Microsoft 365 and Excel 2021 or later, but that function creates a formula result rather than adding dropdowns that hide worksheet rows. It is not necessary to use a formula to filter an ordinary list. If you are following instructions for a different Excel edition, check whether that edition supports the feature before relying on it.

When to use a table or another approach

AutoFilter is a good choice when you want to inspect a list interactively and keep the records in place. Use a table when the dataset is likely to grow, has consistent column headings, and would benefit from table features such as automatic expansion and structured formatting. A table does not repair inconsistent values or make a poorly designed data layout reliable; clean headers and consistent entries still matter.

If you need a separate, formula-driven list of matching results, the FILTER function may be appropriate in Excel 2021 or Microsoft 365. That is a different tool from the Data tab’s Filter command, and it returns results in another area rather than hiding source rows. For a simple one-time search, the dropdown’s search box or Find can be quicker. Choose based on whether you need to hide rows, create a live output, or merely locate a value.

Frequently Asked Questions

Why is the Filter button greyed out in Excel?
Check whether you are editing a cell, whether the worksheet is protected, and whether you have permission to edit the workbook. A protected sheet may restrict AutoFilter use. If you are authorized, finish cell editing or ask the workbook owner to adjust the protection settings.

How do I turn filter arrows back on?
Click inside the intended data range and choose Data > Filter. On Windows, Ctrl+Shift+L also toggles AutoFilter. If arrows still do not appear, confirm that the selection includes the real header row and that the sheet is not protected against filter changes.

Why does Excel filter only part of my data?
A blank row or column may have split the list, or the filter may have been applied to a smaller selection. Select the entire intended range, including its header row, and apply Filter again. Removing unnecessary blank separators can also help Excel recognize one continuous list.

Does filtering delete rows in Excel?
No. A filter hides rows that do not meet the chosen criteria; it does not remove their contents. Clear the filter to show the records again. If rows remain missing, check whether they were manually hidden or are excluded by another column’s filter.

Why can’t I find a value in the filter dropdown?
The value may be excluded by another active filter, spelled differently, stored with extra spaces, or absent from the visible checklist because of the 10,000-unique-item display limit. Search in the dropdown, clear other criteria, or use a suitable text, number, or date filter.

Is Excel’s Filter command the same as the FILTER function?
No. The Filter command adds dropdowns and hides rows in the original list. The FILTER function, available in Excel 2021 and Microsoft 365, returns matching values as a formula result in another area. Use AutoFilter for interactive row filtering and the function when you need a dynamic output range.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.