Excel Filter Button Not Working? Fix Common Causes

If the Excel filter button is missing, greyed out, or not filtering the rows you expect, check that your data has one header row, select a cell inside the data, and choose Data > Filter. If the command is already on, clear the active criteria with Data > Clear; then check for a broken data range, merged cells, or sheet protection.

Quick checks for a filter that will not turn on

Start with the simplest cause: Excel may not recognize the selected cells as one tidy list. Click a cell in the middle of the records and select Data > Filter. Excel should add a dropdown arrow to each header. If the arrows appear but clicking one does nothing useful, the issue is more likely the filter criteria, the range, or the data itself than the button.

Check the selection: Click inside the intended list rather than selecting a blank cell elsewhere. If the list has a completely blank row or column dividing it from nearby data, Excel may treat the sections as separate regions.
Check for an existing filter: The Filter command is a toggle. Selecting it when filtering is already on can remove the arrows. Use the header dropdowns to inspect the current criteria, or choose Data > Clear to remove applied criteria while leaving the filter controls available.
Check the worksheet: A protected sheet can restrict filtering, and a sheet with merged cells in the intended range can prevent Excel from applying AutoFilter normally.
Check the header row: Make sure each column has a single, nonblank heading, with no merged heading cells spanning several columns.

On Excel for Microsoft 365 on Windows, Filter is on the Data tab in the Sort & Filter group. Ctrl+Shift+L toggles AutoFilter. On a Mac, use Data > Filter if the keyboard shortcut differs for your keyboard or Excel version; keyboard mappings can vary by configuration. Excel for the web also has filtering on the Data tab, although the ribbon layout can differ from the desktop app.

How Excel filtering works

AutoFilter adds dropdown controls to a header row. Those controls let you show records matching a value, a text or number condition, a date period, or a selection of values. Excel hides rows that do not match; it does not delete them. Clearing a filter makes those rows visible again.

For example, a table with columns named Region, Salesperson, and Order Date can be filtered to show only West-region orders. Applying an additional filter to Salesperson narrows the visible results further: a row must meet both active column filters to remain visible. This is why a filter can appear to return no results even when one of its criteria seems reasonable. Another column may still have a restrictive condition.

Filtering is not the same as sorting. Sorting changes the order of records, while filtering hides nonmatching records from view. If rows seem to have vanished after using the dropdown, check for filter indicators in the header arrows and choose Data > Clear. Do not assume the records were erased.

Fix a data range that stops too soon or includes extra cells

Excel decides which rows and columns belong to a filter based on the selected range or the current contiguous data region. A completely empty row or column can break that region. If the dropdown arrows appear only on part of the dataset, or new records are left out, inspect the edges of the range for blank separators and stray entries.

A practical example is a list with headers in A1:C1 and records through row 50, followed by a blank row and then a note in row 52. Starting AutoFilter inside the list should usually target the connected records, but selecting only A1:B50 by mistake will omit column C. Likewise, a blank row between records can cause Excel to interpret the entries below it as a separate block. Remove unnecessary separator rows or select the full intended range before applying the filter.

For a dataset that grows regularly, convert the range to an Excel table using Insert > Table, or press Ctrl+T on Windows. Confirm that My table has headers is selected when the first row contains headings. Tables add filter arrows to their headers and generally expand as you add data directly below or beside the table. They also make it easier to keep new records within the same structured range. A table does not fix malformed data or every unusual layout, so verify its boundaries in Table Design if results still omit rows.

Do not include a title row above the actual column headings as if it were a second header. A decorative title such as Monthly Orders merged across several columns can confuse the intended layout. Keep the field names on one row, directly above the records, and place explanatory notes outside the filter range.

Check headers, blank cells, and merged cells

Each column should have one clear heading, such as Date, Customer, or Status. Blank headings, duplicate names, and multi-row headings make a list harder to interpret and can lead to confusing controls. Give every column a distinct, nonblank label. If the data has a heading spread across multiple rows, reorganize it into one header row before filtering.

Merged cells are a frequent obstacle because a filter expects a consistent rectangular list, with one value per cell in each record. Unmerge cells in the data area and fill the resulting cells appropriately before applying AutoFilter. To inspect merges, select the relevant area and look at Home > Merge & Center. Do not unmerge a layout blindly if it contains important labels; first check where the original value should belong.

Blank cells within a column do not necessarily stop filtering, but they affect what appears in the dropdown. Excel may offer a (Blanks) choice, and selecting a particular value will exclude empty entries. A cell that looks blank may instead contain a space, an apostrophe, or a formula returning an empty string. If a value you expect is missing from the list, inspect the underlying cells and consider whether the entries are genuinely identical. For example, North and North followed by a space can behave as different text values.

When the button is greyed out or the sheet is protected

If Data > Filter is unavailable, first check whether the workbook or worksheet is in a restricted state. On a protected worksheet, the person who applied protection can allow users to use AutoFilter. If existing filter arrows are present but cannot be used, protection settings may not permit filtering. Choose Review > Unprotect Sheet if you have permission and the password, or ask the workbook owner to adjust the protection settings.

When protecting a sheet, Excel provides options that control what users are allowed to do. The Use AutoFilter permission applies to using filter controls that are already in place; it does not mean every protected sheet lets users create or remove a new filter. The owner can set up the filter before protecting the sheet and allow AutoFilter use during protection. Do not try to bypass a password: request access from the person responsible for the workbook.

Also check whether the workbook is being viewed in a mode or location that limits editing. If commands are disabled in a shared, read-only, or otherwise restricted copy, save or open an editable copy if you are authorized. In Excel for the web, ask whether you have edit access; a viewer may not be able to change the filter setup. The exact availability of commands can depend on the workbook and sharing permissions.

Why a filter appears to do nothing

Sometimes the button works but the criteria do not match the data as expected. Open the dropdown on the relevant header and look for a funnel icon, which indicates that a filter is active on that column. Choose Clear Filter From [column name] in the dropdown to reset just that column, or use Data > Clear to clear active filters across the sheet. The menu wording can vary slightly by Excel build.

Review the filter type as well as the value. Text Filters, Number Filters, and Date Filters offer different conditions. A condition such as Begins With will not find a value that only contains the text in the middle. Date entries stored as text may not behave like real dates, and numbers stored as text can produce unexpected results in number filtering. If sorting or filtering behaves inconsistently, check the cell format and the underlying value rather than relying only on how the cell looks.

Another common source of confusion is that AutoFilter applies criteria to rows in the filtered range, not to isolated cells. If one column contains repeated customer names, choosing a name shows every matching record, not just one row. If no rows remain, clear the filters and apply one criterion at a time. That makes it easier to identify which condition excludes the records.

Desktop, Mac, and web differences

The core behavior is similar in Microsoft 365 for Windows, Excel for Mac, and Excel for the web: use the Data tab to turn filtering on, then work from the header dropdowns. Ribbon placement and shortcut behavior can vary. On Windows, Ctrl+Shift+L is the standard AutoFilter toggle. If it does not work on your Mac, use the visible Data > Filter command rather than assuming that the Windows shortcut applies.

In the desktop app, the Data tab includes the Sort & Filter controls and is usually the clearest route for troubleshooting. In Excel for the web, the interface may show a simplified ribbon, and some workbook features or permissions can limit what you can change. If a filter is missing or behaves differently in the browser, open the workbook in the desktop app if available and permitted. Be sure to save changes in the same workbook and confirm that you are not looking at a stale or read-only copy.

For shared workbooks, changing a filter can affect what is visible to other people depending on the sharing experience and workbook setup. Excel includes sheet views in supported Microsoft 365 collaboration scenarios so users can work with separate sort and filter views. If colleagues need independent views, check whether Sheet View is available on the View tab instead of repeatedly changing a shared filter.

A reliable way to reset and reapply filtering

If the cause is unclear, use a controlled reset rather than repeatedly clicking the Filter button:

Save the workbook, then check that you are editing the intended sheet and data range.
Choose Data > Clear to remove active filter criteria. If the arrows remain, filtering is still enabled; if they disappear, select a cell in the data and choose Data > Filter once.
Confirm there is one header row, no merged cells in the list, and no blank row or column splitting the records.
Apply one simple filter, such as selecting one known region, and confirm that matching rows remain visible.
If the dataset changes frequently, consider making it a table with Insert > Table so its header controls and range are easier to manage.

This process separates two different problems: a filter control that is not enabled and a filter that is enabled but has criteria or range issues. If the filter still cannot be applied after checking protection and the data layout, test whether the command works in a new, uncomplicated worksheet. If it does, the problem is likely specific to the original sheet or workbook; preserve a copy before making structural changes.

Frequently Asked Questions

Why is the Excel filter button greyed out?
Common causes include worksheet protection, read-only access, or a workbook state that limits editing. Check Review > Unprotect Sheet if you have permission, and confirm that you have edit access. If the sheet is protected intentionally, ask its owner to allow the required AutoFilter use.

How do I remove a filter without deleting rows?
Choose Data > Clear to remove active filter criteria while keeping the records. To turn off the dropdown arrows as well, select Data > Filter. Filtering hides nonmatching rows; it does not delete them.

Why are some rows missing from my filter?
The filter range may stop before the last records, or a fully blank row or column may split the data into separate regions. Check the range boundaries and remove unnecessary separators. Also make sure the missing entries are not excluded by another active column filter.

Why does my filter show no results?
There may be another active filter, the selected condition may not match the actual values, or some entries may contain spaces or be stored as text. Use Data > Clear, then test one criterion at a time and inspect a few source cells.

Can I filter a protected Excel sheet?
Yes, if the sheet was set up to permit AutoFilter use. The filter should generally be created before protection, and the protection settings must allow users to use it. If those conditions are not met, ask the workbook owner to change the setup.

Does filtering delete or change the order of my data?
No. Filtering hides rows that do not match the selected criteria. Sorting changes row order, which is a separate action. Use Data > Clear to show records hidden by filters again.

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.