Excel Sheet Filter Not Working? Fix the Common Causes

If an Excel sheet filter is not working, first clear any existing criteria, then select the complete data range—including its header row—and choose Data > Filter. If the arrows are missing or results are incomplete, check for blank rows or columns splitting the range, hidden rows, merged cells, protection, and values stored in inconsistent formats.

Start with a quick filter reset

A filter can appear broken simply because an old condition is still active. Look for a funnel icon in a column’s header arrow; it indicates that the column has a filter applied. To remove the conditions without removing the filter buttons, click Data > Clear. To turn AutoFilter off and back on, use Data > Filter twice. In Microsoft 365 for Windows, Ctrl+Shift+L also toggles filter buttons.

Then test the sheet with one simple condition. Open a header’s drop-down, select Clear Filter From [column name] if available, and choose one value from the list. If that works, the filter itself is functioning and the issue is likely a previous criterion or an unexpected value in the data. If the command is unavailable, make sure you have selected a cell inside the data and that the sheet is not protected.

Make sure Excel is filtering the whole range

When you click a cell and apply Filter, Excel tries to identify the surrounding data region. A completely blank row or column can make it treat part of a list as a separate block. For example, if a report has headers in row 1, records in rows 2 through 50, and a blank row 51 before the remaining records, the filter may cover only the first block. Rows outside the detected region will not receive filter arrows or respond to its criteria.

To correct the range, remove the current filter, select the full rectangular block from the first header to the last data column and row, and choose Data > Filter. Include all records, even rows that look blank because they contain formulas returning an empty string. Check the first and last visible records after applying the filter; this is a quick way to spot a range that stops too early.

For a list that grows regularly, consider converting it to an Excel table. Select a cell in the data and choose Insert > Table, confirm the proposed range, and ensure My table has headers is checked when appropriate. Tables provide header filters and structured boundaries. Excel commonly expands a table when data is entered directly beneath it, but verify the table range after pasting or importing new rows rather than assuming every pasted record was included.

Check the header row and data layout

AutoFilter expects a single header row with a distinct heading for each column. A title row above the actual headings can confuse range detection if it is included as part of the selected list. Likewise, merged header cells and blank header cells can make the filter controls confusing or prevent Excel from treating the range as a clean list. Keep the column names in one row, avoid merged cells in the filtered range, and give each column a meaningful heading such as Date, Region, or Amount.

Also check whether the records are truly arranged in columns. A filter does not infer that a value in one row belongs to a different field simply because the layout looks visually aligned. If a report contains subtotals, section labels, or repeated headings between groups, consider making a clean, continuous data table first. Each record should occupy one row, and each field should occupy one column. Keep notes and summary totals outside the list where possible.

Look for criteria that exclude the rows you expect

Filters can combine conditions across columns. For example, filtering Region to North and Status to Open shows records that meet both conditions; a record that matches only one will stay hidden. Within a column, selecting several listed values generally includes those selected values, while number, date, and text filters can impose more specific conditions. Review every column with a funnel icon, not just the column you are currently inspecting.

Use Data > Clear to remove all active filter conditions when you are unsure what has been selected. Then apply one condition at a time and observe which records disappear. In the filter menu, check whether the search box is narrowing the checklist and whether the select-all option is checked. A typed search term in that box is a way to choose values, not a permanent change to the underlying cells.

There is an important distinction between filtering and deleting: filtering hides rows that do not match; it does not remove their contents. If a filter returns no rows, clear the conditions before deciding the records are missing. If you need to inspect the actual values, copy the relevant range to a temporary sheet or clear the filter first.

Check numbers, dates, spaces, and formulas

Values that look alike may not be stored alike. A column can contain the number 25 as a numeric value in some rows and the text string 25 in others. Dates can likewise be real Excel dates in some cells and text that merely looks like a date in others. Mixed types can divide the filter menu into unexpected groups or make a number or date condition omit records. Check suspicious cells by selecting them and inspecting the formula bar and number format; changing the display format alone does not convert text into a number or date.

Leading or trailing spaces can make text entries appear identical while Excel treats them as different values. For instance, North and North followed by a space may appear the same in a narrow column but show as separate choices in the filter list. Look for inconsistent spelling, punctuation, nonbreaking spaces from copied web content, and blank-looking cells that contain a formula or a space. Correct the source values consistently before relying on exact text filters.

If a filtered column contains formulas, its displayed result may change after recalculation or after other inputs change. Clear and reapply the filter when the visible records seem out of date. For a workbook with manual calculation enabled, check Formulas > Calculation Options; automatic calculation is the usual setting for routine work. Recalculation updates formula results, but it does not repair inconsistent source data or a filter range that excludes rows.

Distinguish filtered rows from hidden rows

Rows may be invisible for reasons other than a filter. Someone may have hidden them manually, or a group created with Excel’s outline controls may be collapsed. Clearing filter criteria does not necessarily unhide rows that were hidden separately. If records remain absent after choosing Data > Clear, select the row numbers around the gap, right-click, and choose Unhide. You can also select the whole sheet using the corner button above row 1 and left of column A, then use Home > Format > Hide & Unhide > Unhide Rows.

Be careful when selecting and deleting visible rows in a filtered list. A filter only changes what is displayed, and deleting visible records is a different operation from clearing criteria. Before making bulk changes, confirm the selected rows and consider saving a separate copy of the workbook. This is especially useful when a sheet contains manually hidden records as well as filtered ones.

Check protection, selection, and workbook state

If the filter command is dimmed, or drop-downs will not respond, check whether the worksheet is protected. Choose Review > Unprotect Sheet if you are authorized and have any required password. A protected sheet can be configured to allow or disallow use of AutoFilter; without permission to change the protection settings, ask the workbook owner rather than trying to bypass them.

Make sure you are working in the intended worksheet and that the workbook is not in a mode that limits editing. If several worksheets are grouped, Excel can apply some actions across the selected sheets, which is risky for changes to layout. Right-click a sheet tab and choose Ungroup Sheets if multiple tabs are selected. If the filter still behaves oddly, save the workbook, close and reopen it, and test a copy. This can distinguish a workbook-specific issue from a problem with the data or range.

Excel for Mac and Excel for the web

The core checks are similar in Microsoft 365 for Windows, Excel for Mac, and Excel for the web: use a clean header row, select the intended range, and apply or clear filtering from the Data tab. Ribbon placement and wording can vary slightly by platform and window size. On Mac, use the ribbon rather than relying on the Windows Ctrl+Shift+L shortcut; keyboard shortcuts differ between Mac and Windows. In the web version, confirm that you are in an editable workbook, since view-only access can prevent changes.

When a workbook is shared, another person may also have a different view or be changing the underlying data. Excel’s sheet-view options can let users work with separate views in supported versions, so one person’s visible filter state may not describe what another person sees. If the results matter, confirm the active sheet view and filter criteria with collaborators, and avoid assuming that hidden rows have been deleted.

Frequently Asked Questions

Why does Excel filter only some of my rows?
Excel may have detected only one contiguous block of data. Blank rows or columns can split a list, and records added below the original range may not be included. Select the complete range and apply the filter again, or convert the list to a table and confirm its range.

Why is the Filter button greyed out?
The sheet may be protected, the workbook may be read-only, or the current selection or editing state may prevent the command. Check Review > Unprotect Sheet if you have authorization, and verify that you can edit the workbook.

Why does my date filter show strange groups or miss dates?
The column may mix true Excel dates with text values, or contain inconsistent entries. Inspect a few cells and standardize them as real dates before filtering. Changing the number format changes how a value is displayed, but does not by itself convert date-like text into a date value.

Does clearing a filter unhide every row?
No. Data > Clear removes filter criteria, but rows hidden manually or through a collapsed outline can remain hidden. Use the row headers and Unhide commands to reveal those rows.

Why do filter arrows disappear?
AutoFilter may have been toggled off, or the selected range may no longer include the header row. Select the intended data block and choose Data > Filter. If the worksheet is protected, the filter controls may also be restricted by its protection settings.

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.