Excel Filter Not Working? Fix the Most Common Causes

If an Excel filter is not working, first check that it covers the complete data range and that the header row is included; then clear the current criteria and apply the filter again with Data > Filter. Missing rows, blank cells, inconsistent data types, or a protected sheet are common reasons results look wrong.

Start with these quick checks

Work through these checks before changing or rebuilding your data. They often reveal whether the problem is the filter itself or the way the data is arranged:

Click a cell inside the data and choose Data > Filter. On Windows, Ctrl+Shift+L toggles AutoFilter on or off.
Look for a drop-down arrow in each header cell. If arrows are missing, the filter may be off, applied to another range, or unavailable because the sheet is protected.
Open the relevant arrow and check whether a search term or selection is already restricting the rows. Choose Clear Filter From [column name] to remove that column’s criteria.
Choose Data > Clear to clear active filters, then inspect the data again. This removes criteria; it does not delete rows.
Check for blank rows, blank columns, merged cells, or data added below the filtered range.

On Mac, use Data > Filter if you do not want to rely on a keyboard shortcut, since shortcuts can differ by keyboard and Excel version. Excel for the web also provides filtering from the Data tab, though its ribbon layout may look different.

How Excel decides which cells to filter

AutoFilter needs to know which row is the header and which rows belong to the list. When you click within a continuous block of data and turn on filtering, Excel generally identifies that block as the range. A completely blank row or column can break the block. For example, if a sales list has a blank row between April and May, Excel may treat May’s records as outside the original range.

Check the range by clicking a cell in the data and looking for filter arrows across the intended header row. If the arrows stop partway across, or the rows below the blank line do not change when you filter, the selected range may be incomplete. Turn filtering off, select the full range including its headers, and choose Data > Filter again. Avoid selecting unrelated notes or totals below the list.

A header row should contain one clear label per column. If Excel treats the first record as a header, that record will not appear among the filterable data. If it treats a title or a blank row as the header, the arrows may appear in the wrong place. Keep a single header row directly above the records, and avoid merged cells in the header or data area because merged cells can interfere with sorting and filtering.

Check the header row and the range boundaries

Headers such as Date, Region, and Amount make each drop-down’s purpose clear. Blank or repeated labels can make a list confusing, and when you convert a range to a table Excel may adjust duplicate header names to make them distinct. If a filter arrow seems to belong to the wrong field, inspect the labels and confirm that the first row of the selected range really is the header row.

New data is a frequent source of the problem. Suppose a filter covers rows 1 through 50, then you paste records into rows 51 through 60 with a blank line between them. The new records may not respond to the existing filter. Remove the blank line if appropriate, extend the range, or convert the list to an Excel table so that the data has a more reliable boundary.

When a filter hides records you expected to see, also inspect the row numbers along the left edge. Rows hidden manually can remain out of sight even after filter criteria are cleared. Select the row headers surrounding the hidden area, right-click, and choose Unhide. This is different from a filter: clearing a filter does not necessarily reverse rows that someone hid manually.

Clear old criteria and reapply the filter

A filter can be active even when its effect is not obvious. A small filter indicator on a column’s arrow signals that criteria are applied. Open each relevant drop-down and review the checked values, search box, and any text, number, date, or color filter. One forgotten condition in a second column can make a record disappear even when the first column looks unrestricted.

Filters across different columns work together: a row must satisfy the criteria in every filtered column. For example, filtering Region to West and Status to Open returns records that are both in the West region and open. Within one column, selecting several listed values includes rows matching any of those selected values. This distinction explains why applying a second column’s filter can make the results unexpectedly small.

To reset criteria without removing the arrows, choose Data > Clear. You can also open a particular column’s arrow and choose its clear-filter command. Then set the intended conditions again. Data > Reapply tells Excel to apply existing sort and filter criteria to the current data, which is useful after changing values. If criteria still behave oddly, turn the filter off and back on over the correct range.

Look for mixed data types, spaces, and unusual values

Values that look alike on screen may not be stored alike. A column can contain genuine numbers in some rows and numbers stored as text in others. The filter menu may then separate values into categories or offer choices that do not behave as expected. For example, an amount entered as the number 125 and another entered as text may both display as 125, but Excel can treat them differently in numeric filtering and calculations.

Dates can have the same issue. A real Excel date is stored as a date value, while a date pasted from a website or imported as text may only look like one. Date filters such as a particular month work on actual date values; text dates can appear as individual text entries instead. Check whether the values behave consistently in the formula bar, and use a controlled conversion or re-import if the column mixes types. Keep a copy before bulk conversions.

Leading or trailing spaces can also create separate filter entries, such as North and North followed by a space. Nonprinting characters copied from external systems may produce similar surprises. If two apparently identical choices appear, inspect the underlying values and clean the source column rather than relying only on what the cells display. Be careful with broad find-and-replace operations: they can alter legitimate content.

Finally, check whether the value you are seeking is actually blank, contains a formula returning an empty string, or has a different spelling. The filter list may offer a Blanks option, but a formula that displays nothing is not always equivalent to a genuinely empty cell. Search the source rows and inspect formulas or imported data when the visible result does not match the menu.

Use a table when the data keeps growing

For a regularly updated list, converting the range to a table can prevent many range-boundary problems. Select a cell in the data and choose Insert > Table, or press Ctrl+T on Windows. Confirm that the selected range is correct and that My table has headers is checked when the first row contains labels. Excel tables include filter arrows and typically expand when you enter or paste data directly next to the table.

A table is helpful, but it cannot fix malformed source data. Check that its header row is correct, avoid blank header names, and make sure new records are added adjacent to the table rather than separated by empty rows or placed elsewhere on the sheet. If a pasted block did not become part of the table, use Table Design > Resize Table to adjust its range. On Mac, the contextual table tab may be labeled Table rather than Table Design, depending on the version.

Tables also make it easier to distinguish a structured list from surrounding notes and totals. They are not essential for filtering, however: a normal, well-formed range can be filtered too. Choose a table when the list changes often; for a one-time analysis, a correctly selected range may be enough.

Check sheet protection and other restrictions

If the arrows are visible but you cannot change the filter, the worksheet may be protected. A protected sheet can restrict actions such as using AutoFilter unless the person who protected it allowed that permission. Check Review > Unprotect Sheet if you are authorized to remove protection. If you do not know the password or do not own the workbook, ask its owner rather than trying to bypass the restriction.

Workbook structure protection is different from worksheet protection, and shared or managed workbooks may also limit what you can change. If the filter command is unavailable or behaves differently in a particular file, check whether the sheet is protected and whether you have editing access. Save a separate copy before making structural changes to a workbook whose contents or permissions matter.

When the command is available but the results seem stale after edits, use Data > Reapply. Also confirm that the values themselves have finished updating, particularly if the workbook depends on formulas or external data. A filter only evaluates the values Excel currently has; it does not repair an incorrect import or a formula that returns an unexpected result.

What filtering does—and what it does not do

Filtering hides rows that do not match the current criteria; it does not remove those records from the workbook. Clear the filter to show them again. This matters when copying, deleting, or calculating: take care to understand which rows are visible and which are merely hidden before making changes. A filtered view can make a list look shorter without changing its underlying contents.

Filtering also does not correct inconsistent values, automatically interpret every text string as a number or date, or find records outside its range. It is a way to display matching rows, not a data-cleaning tool. If you need to inspect possible duplicates, normalize categories, or validate dates, address those tasks separately and keep the original data available until you have checked the result.

For a different way to explore a well-structured table, consider sorting, a PivotTable, or a table slicer. Sorting changes row order rather than hiding nonmatching rows. A PivotTable summarizes data, while a slicer provides clickable controls for filtering a table or PivotTable. These options are useful for different jobs; none automatically fixes a filter range that excludes records.

Frequently Asked Questions

Why is the Excel filter arrow missing?
Filtering may be turned off, applied to a different range, or blocked by sheet protection. Click inside the intended data and choose Data > Filter. If the range has blank rows or columns, select the complete list first and apply the filter again.

Why does Excel show only some of my rows?
One or more columns may still have criteria, the filter range may stop before those rows, or some rows may be manually hidden. Clear criteria with Data > Clear, check the range boundaries, and unhide rows if needed.

Why are new rows not included in my filter?
The new records may have been added outside the filtered range, especially after a blank row or column. Extend the range or convert the list to a table with Insert > Table so adjacent additions are easier for Excel to include.

Why does filtering a date or number column give strange results?
The column may mix real date or numeric values with text that only looks like a date or number. Check the underlying values and make them consistent before applying date or number criteria.

Does clearing an Excel filter delete the hidden rows?
No. A filter hides nonmatching rows; Data > Clear removes the filter criteria and shows filtered-out rows again. Rows hidden manually may need to be unhidden separately.

Can I filter a protected Excel sheet?
Only if the sheet’s protection settings allow filtering. If you have permission, check Review > Unprotect Sheet or ask the workbook owner to adjust the allowed actions.

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.