Excel Not Letting You Filter? Fix the Common Causes

If Excel is not letting you filter, first select a cell in the data and choose Data > Sort & Filter > Filter; if the button is unavailable, check whether the sheet is protected, multiple sheets are grouped, or Excel is still editing a cell. If filter arrows appear but the results are wrong, the usual causes are an incorrectly detected data range, blank or inconsistent headers, or values stored in mixed formats.

Identify what is going wrong

“Excel won’t filter” can describe several different problems, and the fix depends on what you see. The Filter command might be greyed out, the arrows might be missing, or the arrows might work without showing the rows you expect. Start by distinguishing those cases rather than repeatedly clicking the same button.

Filter is greyed out: look for worksheet protection, grouped worksheet tabs, or an active cell-editing session.
The arrows are missing: apply Filter to the correct range, and check that the first row is intended to be the header row.
The arrows appear, but rows do not filter as expected: inspect the selected range, blank rows, hidden rows, and inconsistent data types.
Some rows are missing after clearing a filter: check whether they were hidden manually or excluded from the filter range.

Filtering hides rows that do not match the chosen criteria; it does not delete them. This distinction matters when a result looks incomplete: clear the filter before assuming that records have been removed.

Try a reliable quick fix

For a typical list with one header row and records beneath it, these steps reset the filter using the intended data range:

Click a cell inside the list. If Excel has trouble identifying its boundaries, select the full rectangular range, including the headers and all records.
On Windows, open Data > Sort & Filter > Filter. You can also press Ctrl+Shift+L to turn AutoFilter on or off.
If the arrows were already on, use Data > Sort & Filter > Clear to clear the current criteria, then check the range and apply Filter again if needed.
Open a column’s arrow and choose a value or condition. To show all rows in that column again, choose Clear Filter From followed by the column name, or use Clear on the Data tab.

Ctrl+Shift+L is a toggle, not a command that always turns filtering on. Pressing it when filters are already active can remove the arrows, so check the worksheet after using it. On Mac, use the Data tab if you are unsure of the shortcut available in your Excel version.

Check that Excel is filtering the right range

AutoFilter applies to a contiguous block of data. When you click inside a list, Excel tries to detect that block automatically. A fully blank row or blank column can make Excel treat the data below or beside it as a separate block, so the filter may omit records. A row that merely contains an empty cell does not necessarily split the data; the concern is a gap that breaks the continuous region.

For example, suppose a report has headers in row 1, records in rows 2 through 80, and another set of records beginning in row 82 after a completely blank row. Applying Filter from the first block may include rows 1–80 but not row 82 onward. Select the complete intended range before applying Filter, or remove the unintended gap if it is safe to do so.

If your list is already an Excel table, click in it and use Table Design > Resize Table to inspect or adjust its boundaries. For an ordinary range, select the full dataset, including the header row, and apply Filter. Before changing a range, confirm that it does not include unrelated notes or totals that should not be filtered with the records.

Make the header row unambiguous

Excel uses the top row of the filtered range as column labels. Give every column a distinct, nonblank heading, such as Date, Region, and Amount. If you include a title row, a blank row, or a merged heading above the actual labels in the selected range, Excel may treat that title as the header and place arrows on the wrong row.

Check for these common header problems:

A blank heading or duplicate labels that make columns difficult to identify.
Two rows of headings, such as a report title followed by the real field names.
Merged cells in the header area, which can make the range harder to manage and may interfere with sorting or other table operations.
A total row included as if it were an ordinary record.

Keep one clear header row at the top of the selected list. If the worksheet uses a decorative title, leave it outside the filter range. For data you will filter regularly, avoid merged cells in the data area and use a proper table structure instead.

When the arrows work but the results look wrong

Filters compare the values Excel recognizes, not just the way cells look on screen. A column that appears to contain dates can include genuine Excel dates, text that looks like a date, and blanks. Numbers stored as text can likewise behave differently from numeric values. In such a column, the dropdown may offer unexpected categories or a condition may leave out values you thought should match.

Inspect a few examples from the values that are missing. Click a cell and look at the formula bar; also check whether the values align or sort consistently. Formatting a text value as a date or number does not necessarily convert the underlying text into a genuine date or number. If the column is mixed, standardize the source values before relying on date or number filters. Make a copy before using a conversion method that could alter data.

Other reasons for surprising results include an active filter on another column, a search term still entered in the dropdown, or records outside the filter range. Use Data > Sort & Filter > Clear to remove filter criteria across the current range, then apply one criterion at a time. This helps reveal whether a second condition was narrowing the results.

Finally, distinguish filtered rows from manually hidden rows. Clearing a filter restores rows hidden by that filter, but it does not necessarily unhide rows someone hid using the row commands. If expected records remain absent, inspect the row numbers for gaps and use the worksheet’s Unhide option where appropriate.

Why the Filter command may be unavailable

If Filter is greyed out, check whether the worksheet is protected. Protection can restrict changes to filtering; depending on how protection was set, users may be allowed to use an existing AutoFilter without being allowed to create or remove one. The sheet owner can review Review > Protect Sheet and, when protecting the sheet, allow Use AutoFilter. Only change protection if you have permission, and avoid removing it just to test a filter on a shared or controlled workbook.

Look at the worksheet tabs, too. If several sheets are selected as a group, Excel disables some commands because an action could affect multiple sheets. Right-click a selected sheet tab and choose Ungroup Sheets, or click a single sheet tab, then try Filter again.

Excel may also be in cell-editing mode. This happens while you are typing into a cell or editing its contents in the formula bar. Press Enter to commit the edit or Esc to cancel it, then try the command. If a dialog box is open, close or finish that dialog first.

Choose between a table and a regular filter

A regular AutoFilter is suitable for a one-off list or a range that needs dropdown filters without extra table formatting. An Excel table is often more convenient for a dataset that grows: tables provide header filter arrows and can expand as records are added. To create one, select a cell in the data and choose Insert > Table, then confirm the range and whether it has headers.

Tables do not repair bad source data automatically. They still need a clear header row, consistent values, and the correct boundaries. If a table does not include new records, check whether those records were added directly below it, whether a blank row separates them, and whether the table range needs adjustment through Table Design > Resize Table.

Do not turn a list into a table solely to solve a protection restriction or a mixed-data problem. A table changes how the range is structured and formatted, while the underlying cause may be a locked worksheet or values stored as text. Identify the issue first, then choose the simplest option that fits how the workbook is maintained.

Differences across Excel versions

The steps above are for Excel for Microsoft 365 on Windows. In Excel for the web, the Data tab also provides filtering, though the ribbon layout and some controls can differ; if a command is not where expected, use the ribbon search or inspect the Data tab. A workbook opened in a browser can also have editing restrictions set by its owner, which are different from a filter problem in the worksheet itself.

Excel for Mac has the same basic concept of AutoFilter and table filters, but keyboard shortcuts and ribbon arrangements can differ from Windows. Use the Data tab when a Windows shortcut does not apply. If you are collaborating, confirm that you have editing permission and that the workbook is not in a read-only state before changing the range or protection settings.

Frequently Asked Questions

Why is the Filter button greyed out in Excel?
Common reasons include a protected worksheet, multiple worksheets selected as a group, or Excel being in cell-editing mode. Ungroup the sheets, finish or cancel the edit, and ask the sheet owner to allow AutoFilter if protection is enabled.

Why are filter arrows missing from my header row?
Select a cell in the data or select the complete range, including its header row, and choose Data > Sort & Filter > Filter. Make sure the selected range starts with the actual column labels, not a report title or blank row.

How do I remove a filter without deleting data?
Choose Data > Sort & Filter > Clear to show the rows hidden by the active filter criteria. This clears the criteria; it does not delete the records. To remove the dropdown arrows themselves, toggle Filter off.

Why does Excel filter only part of my list?
The range may stop at a blank row or column, or the filter may have been applied to only part of the data. Select the complete range and reapply Filter. For a table, inspect its boundaries with Table Design > Resize Table.

Why do some dates or numbers not appear in the filter list?
The column may mix real dates or numbers with text that only looks like those values, or the values may be outside the filtered range. Check representative cells and standardize the source data before filtering again.

Can I filter a protected worksheet?
It depends on the protection settings. The person protecting the sheet can allow Use AutoFilter, which permits use of an existing filter; the settings may still prevent users from applying or removing filters. Ask the workbook owner to adjust protection if necessary.

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.