Excel Data Filter Not Working? Fix the Common Causes

If an Excel filter is not working, first check that the filter covers the entire data range, that the first row contains clear column headings, and that no blank row splits the data. In Microsoft 365 for Windows, select a cell in the range and choose Data > Filter; if the filter is already active but results look stale, choose Data > Reapply or Data > Clear, then set the criteria again.

What a filter should do

Excel’s AutoFilter hides rows that do not meet the criteria you choose; it does not delete those rows. A column’s drop-down menu lets you select particular text, numbers, dates, colors, or conditions. For example, filtering a Status column to show only Open should hide rows marked Closed while leaving their data in the worksheet. Clear the filter to show the rows again.

That distinction helps diagnose apparent failures. If the records seem to have disappeared, look for filtered row numbers or a funnel icon in the column heading, then clear the filter. If rows you expect to see remain visible, the issue is more likely the selected range, the values in the column, or an unapplied change to the criteria.

Check the filter range first

A filter can only control rows included in its range. If new records were pasted below the original range, they may not respond to the existing filter. Click inside the data and inspect which rows have filter arrows. If the arrows stop before the last record, the range is too short. Remove the filter, select the complete data area, and choose Data > Filter again.

Blank rows and blank columns can interrupt Excel’s detection of a contiguous block. For example, if a sales list has a completely empty row between its first 50 records and the next 20, Excel may treat the lower records as a separate region when you turn on filtering from within the upper block. Remove accidental spacer rows or select the full range explicitly before enabling the filter.

For a list that grows regularly, convert it to an Excel table. Select a cell in the data and choose Insert > Table, confirm the range, and make sure My table has headers is selected when appropriate. A table adds filter controls to its header row and normally expands when you type or paste records directly below it. It is often easier to maintain than a manually selected range, though it will not automatically include data pasted far away from the table.

Make sure the headings and layout are filter-friendly

AutoFilter expects one header row above the records. Give every column a heading, such as Date, Customer, and Status. Two-row headings, blank heading cells, or a title placed directly above the headings can make the selected range ambiguous. Move the report title above the filter range, or select only the actual heading row and records before applying the filter.

Merged cells in the data area can also interfere with sorting and filtering. Unmerge them and repeat the relevant value in each record instead. A filter works best when each row represents one record and each column represents one field. Avoid inserting decorative subtotal rows between records; use a separate summary area or a PivotTable for summaries.

Keep one distinct, nonblank heading in each column.
Put headings immediately above the first record, without an intervening blank row.
Keep records in a continuous rectangular range, with no merged cells inside it.
Use a consistent layout rather than adding section labels or subtotals among the records.

Look for inconsistent values and data types

A filter may appear to miss entries when values that look alike are stored differently. A column might contain the number 125 in some rows and the text 125 in others, or dates stored as real Excel dates alongside date-like text. Extra spaces can create similar confusion: North and North followed by a space are different text values, even if the difference is hard to see. In the filter menu, inspect the available values and search for the exact item you expect.

Check a suspicious cell by selecting it and looking at the formula bar and number format. A value aligned differently from neighboring entries can be a clue that it has a different type, but alignment is not definitive because formatting can change it. For text that may contain extra spaces, a helper column using TRIM can help identify or clean ordinary leading, trailing, and repeated spaces. Review the result before replacing original data, particularly if spaces are meaningful in the source.

Date filters deserve special attention. When Excel recognizes dates, its menu can group them into years, months, or days. If some apparent dates appear as individual text values instead of fitting the date groups, those cells may be text rather than dates. Convert the source consistently, then reapply the filter. Also check regional date conventions: an entry such as 04/05/2026 can be interpreted differently depending on settings.

Text criteria can be exact or partial. In the filter search box, typing a word narrows the listed values; text filters also provide conditions such as Contains and Begins With. Wildcard characters are available in applicable text criteria: an asterisk represents a sequence of characters, and a question mark represents one character. If a value contains a wildcard character literally, use a tilde before it in criteria. Choose the condition that matches the question you are asking rather than relying only on a visually similar label.

Reapply or clear criteria that are out of date

Changing a cell does not always update the visible filtered result immediately. If a value changes from Closed to Open but its row remains hidden, choose Data > Reapply. This tells Excel to evaluate the current criteria against the current data. The Reapply command is useful after editing values, refreshing data, or changing formulas that affect a filtered column.

To remove criteria without removing the filter arrows, choose Data > Clear. The rows that were hidden by the filter should become visible, while the drop-down controls remain available. To turn off the AutoFilter arrows, choose Data > Filter. If the sheet has several columns with criteria, clearing is usually faster than opening each column menu and selecting all values.

Remember that Reapply does not broaden the original range. If records were added outside it, expand the range or use a table. Likewise, clearing criteria will not correct text stored as numbers, remove blank rows, or repair a heading row; those are separate range or data-quality problems.

Check for protection, hidden rows, and interface issues

If the filter command is unavailable, the worksheet may be protected or the workbook may be in a state that prevents the action. On the Review tab, check whether Unprotect Sheet is available. If the sheet is protected, filtering may be permitted or blocked depending on the protection settings chosen by whoever protected it. You may need the password or permission from the workbook owner; do not assume that removing protection is appropriate for a shared or controlled file.

Also distinguish filtering from manually hidden rows. A filter hides rows based on criteria, while a user can hide rows independently. Clearing the filter may not reveal manually hidden rows. Select the surrounding row numbers, right-click, and choose Unhide if that is permitted. Grouped worksheets can make changes affect multiple sheets at once; if sheet tabs are selected together, right-click a selected tab and choose Ungroup Sheets before continuing.

If the filter arrow is difficult to see, widen the column or inspect the heading cell for the drop-down. In Excel for the web, commands and layout can differ slightly from the Windows desktop ribbon, but the data-filter controls are still available from the Data tab. On Mac, use the Data tab’s Filter and Clear controls; keyboard shortcuts can differ, so menu commands are the more reliable instructions across platforms.

A quick troubleshooting sequence

Work through these checks in order so that a formatting fix is not mistaken for a range fix:

Click a cell in the data and confirm that filter arrows appear on the intended heading row.
Check that the last record is inside the filtered area and that no blank row divides the list.
Confirm that each column has one heading and that the data contains no merged cells or extra header rows.
Open the affected column’s menu and inspect its listed values; check for unexpected spaces, text-versus-number differences, or text dates.
Choose Data > Reapply after edits, or Data > Clear to remove criteria and start again.
If commands are unavailable or rows remain hidden, check sheet protection, manually hidden rows, and grouped sheets.

For a useful test, filter a simple column with an unmistakable value, such as a Status column containing Open and Closed. If that works, the filter mechanism itself is functioning and the problem likely concerns the original column’s contents or criteria. If the test only works for part of the list, revisit the range boundaries.

When a table or another tool is a better fit

For everyday lists, AutoFilter is appropriate when you want to temporarily show matching records without changing the source data. An Excel table is a practical choice when records are added over time because its filter controls stay with the table and its range can expand as data is appended. Neither option repairs inconsistent source values automatically; clean and standardize the data if reliable filtering depends on it.

For complex analysis, a PivotTable can summarize and filter fields without rearranging the source list. Slicers provide clickable filter buttons for tables and PivotTables, which can make a report easier to use. These are alternatives when the goal is interactive reporting rather than simply hiding nonmatching rows. If the source is imported or refreshed regularly, Power Query can help transform data into consistent columns before it is loaded into Excel, but it is more setup than a basic filter requires.

Frequently Asked Questions

Why does Excel filter only part of my data?
Most often, the filter range ends before the last records, or a blank row or column splits the data into separate regions. Select the complete range and apply the filter again, or convert the list into a table so appended records are easier to include.

Why is a new row not included in my filter?
The row may have been added outside the filtered range. Expand the range or place the new record directly below an Excel table so the table can expand. If the row is already included but its visibility is wrong after an edit, choose Data > Reapply.

Why does Excel show no matching records?
Check that the selected criteria exactly match the stored values. Hidden spaces, inconsistent spelling, text stored as numbers, text dates, or an active criterion in another column can exclude the rows. Use Data > Clear to remove all current criteria, then test one column at a time.

How do I remove a filter without deleting data?
Choose Data > Clear to remove the active filter criteria and show the records again while keeping the arrows. Choose Data > Filter to turn the filter controls off. Neither command deletes the underlying rows.

Why is the Filter button greyed out?
Check whether the worksheet is protected, whether multiple sheets are grouped, or whether the workbook’s current permissions restrict editing. On a protected sheet, the owner may have allowed or disallowed filtering. Ask for the appropriate access rather than changing protection without authorization.

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.