If an Excel filter includes the wrong data, first check that the filter covers the correct range and that the column has a single, accurate header; then clear and reapply the filter. In Microsoft Excel for Microsoft 365 on Windows, select a cell in the data and choose Data > Reapply, or use the filter arrow to review which values and conditions are selected. Unexpected results usually come from the filter range, inconsistent source data, or criteria that do not mean what you expect.
What an Excel filter does
An AutoFilter temporarily hides rows that do not meet the selected conditions; it does not delete them or change the underlying values. A filter on a status column, for example, can show only rows marked Open. When you clear that criterion, the other rows can appear again. This makes filtering useful for inspecting a subset of a list without making a separate copy.
Excel applies filter conditions to a range of rows and columns, using the first row of that range as its header row. If the range is wrong, the results can look wrong even when the criterion itself is correct. A filter may include an adjacent note column, omit recently added records, or treat a data row as a header. It can also return results that seem inconsistent when the values in a column are not stored in a consistent way.
There is an important distinction between an unexpected row and an incorrectly filtered row. A row may genuinely meet the criterion because its cell contains a similar value, an extra space, or a date stored as text. Check the actual cell contents before assuming Excel has made a matching error.
Check the filter range first
When you turn on filtering from a cell inside a plain data range, Excel tries to identify the surrounding block of data. A completely blank row or column can interrupt that block. If your list has a blank row in the middle, Excel may filter only the section above it, leaving lower records outside the filtered range. Similarly, if you select only part of a list before choosing Data > Filter, the filter may cover only that selection.
Look at the filter arrows: they should appear on every intended header, and no data column should be missing. Then inspect the first and last records in the range. If rows were added below the original list, confirm that they are included. A quick fix is to select the entire intended rectangular range, including its header row, and choose Data > Filter. Avoid including unrelated notes or totals in the selection.
For a stable list that grows over time, convert the data to an Excel table. Select a cell in the range and choose Insert > Table, or press Ctrl+T on Windows; check that My table has headers is selected if the first row contains field names. On a Mac, the Insert > Table command is available too, and the keyboard shortcut may differ by keyboard and Excel version. Tables have filter buttons in their header row and are designed to expand as data is added directly to the table. If new records have not joined the table, use Table Design > Resize Table to confirm or adjust its range.
Make sure the header row is really a header
Each column should have one clear, nonblank label in the first row of the filtered range. A title above the list should not be treated as a header, and merged cells can make a range harder to interpret. If the filter starts one row too high, Excel may treat a title or a record as a field name; if it starts too low, the actual headers may appear as filterable data.
For example, suppose a worksheet has a report title in row 1, field names in row 3, and records beginning in row 4. Applying a filter to the whole region may not produce the intended headers if row 2 is blank or the title is part of the selection. Apply the filter specifically to the header and records, or format the data as a table after selecting the correct range. Keep totals outside the data body unless they are intentionally part of the records.
Look for inconsistent values and data types
Excel can display values that look alike but are stored differently. A column may contain numbers alongside numbers stored as text, dates mixed with text strings, or names with leading or trailing spaces. These inconsistencies can create separate entries in the filter menu or make a condition behave unexpectedly. For example, a numeric value of 25 and text containing 25 can look identical in a cell, but they are not the same underlying type.
Check suspicious cells in the formula bar, and compare several examples from the same column. For text, look for extra spaces, inconsistent punctuation, or variations such as Open, open, and Open followed by a space. For dates, confirm that the cells are real Excel dates rather than text that merely resembles a date. Formatting changes how a value looks; it does not necessarily convert the stored value into a different type.
Correct the source values consistently before filtering. Depending on the data, that may mean trimming unwanted spaces, converting text-formatted numbers to numbers, or importing dates with the correct regional interpretation. Do this carefully: a conversion can change how values are interpreted, particularly dates such as 03/04/2026, whose month and day order depends on the locale. Keep an unchanged copy of important source data before making a bulk correction.
Review the selected criteria
Open the arrow on the relevant column and inspect the checked items, search box, and any active text, number, or date conditions. A search in the filter menu narrows the list of available values; it does not necessarily mean the search text is the only applied condition unless you select the matching item and apply it. A value that looks similar may also be a different category, such as North and North-East.
Filters on separate columns normally work together: a row must meet the conditions in each filtered column to remain visible. Within a single column, a custom filter can allow alternatives, such as a value that begins with East or a value that begins with West. Review every column with an active filter, not just the one you are investigating. A second filter can exclude records that satisfy the first one, making the final result seem incomplete.
Also check whether the rule is an exact value selection or a condition such as Contains, Begins With, Greater Than, or a date period. Contains East can include both East and North-East; an exact selection of East is narrower. Read the condition in the filter menu rather than relying only on the visible rows.
Use a reliable troubleshooting sequence
Work through the checks in order so you can identify whether the problem is scope, criteria, or source data:
- Choose Data > Clear to remove the active filter criteria while leaving the filter controls in place. Confirm whether all expected records return.
- Check the header row and the filter arrows. Make sure every intended column is included and that the first and last records fall inside the range.
- Open each filter menu and inspect selected values and custom conditions. Clear criteria in other columns if they might be narrowing the result.
- Compare a row that appears unexpectedly with one that does not. Check the underlying values, spaces, spelling, and data types rather than only the displayed formatting.
- After fixing the range or data, choose Data > Reapply so Excel updates the displayed results to match the current data.
On Mac, the ribbon layout can vary slightly by Excel release, but the Data tab includes filtering controls. Excel for the web also supports filters, though some ribbon details and advanced options may differ from desktop Excel. If a command is not visible, check the Data tab or the relevant column dropdown rather than assuming the feature is unavailable.
Know when to clear, reapply, or remove a filter
These actions are different. Data > Clear removes filter criteria so the rows can show again, while keeping the filter arrows available. Data > Reapply updates the results using the existing criteria after the source changes. Data > Filter turns the filter controls on or off for the selected range. Turning filtering off is not the same as deleting hidden rows; the records remain in the worksheet.
If a formula-driven value changes and the visible results do not reflect the change, reapply the filter and check that calculation has updated the formula result. Likewise, after pasting new records, confirm that the filter range or table includes them. Do not delete rows merely because they are hidden: first clear the filter and verify what is actually in the source list.
Example: a filter seems to miss new orders
Imagine an order list with headers in row 1 and records through row 120. You add orders in rows 121 through 125, then filter the Status column for Pending. If the original filter range ended at row 120, the new orders will not be considered, even if their status is Pending. Clear the filter, inspect the range, and extend it to include the new rows; or use a table and confirm the added rows are inside it. Then reapply the Pending criterion.
Now suppose an order marked Pending still does not appear. Check whether another column, such as Region, also has a filter applied. If not, examine the Status cell for extra spaces or a slightly different spelling, and confirm the filter menu has the intended value selected. This example illustrates why checking range and criteria before editing data is useful: the same symptom can have several different causes.
When another tool may be more appropriate
AutoFilter is suited to interactive inspection of a list. If you need a separate, automatically updating result area that leaves the source visible, Excel for Microsoft 365 and Excel 2021 can use the FILTER function. That is a different approach: it returns matching records in another location, and its formula and spill range need to be managed separately. For repeatable cleanup and transformation of imported data, Power Query may be a better fit than manually correcting a filter each time.
For a one-time check, an ordinary filter or table is usually simpler. If multiple people edit the workbook, tables can make the data boundary clearer, while consistent headers and data types make both filtering and later analysis more dependable. Choose the method based on whether you want to inspect existing rows, create a live extract, or prepare a repeatable data-cleaning process.
Frequently Asked Questions
Why does my Excel filter show rows that do not match?
Check for a broad condition such as Contains, active filters in other columns, and values with extra spaces or inconsistent types. Also confirm that the row really does not meet the criterion when you inspect its underlying cell value.
Why are some new rows not included in my filter?
The filter may cover only the original range. Extend the range or add the rows to the table, then choose Data > Reapply. Records pasted below a list are not guaranteed to be inside every existing filter range.
How do I show all rows without removing the filter arrows?
Choose Data > Clear to clear the active criteria. The filter controls remain available, so you can apply a different filter without setting them up again.
Does filtering delete or change hidden rows?
No. Filtering hides rows that do not meet the current criteria; it does not delete their contents. Clear the filter to display them again, and check carefully before deleting anything.
Why does a number or date appear as a separate filter value?
The column may mix real numbers or dates with text that looks the same, or contain inconsistent formatting and spaces. Inspect and standardize the source values, then reapply the filter.
Related
- Excel Data Validation List Based on a Cell: How It Works
- Excel Data Validation List: Keep Dropdowns in A-to-Z Order
- Excel Data Validation List Auto Update: How to Set It Up
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- How to Filter for Duplicates in ExcelTo show only duplicate values in Excel, select the cells you want to check, choose Home > Conditional…
- Excel A to Z Formula: How to Sort DataWith the values to sort in A2:A20 and an empty output area beginning at C2, enter =SORT(A2:A20) in…
- How to Filter an Excel Sheet by Text: Steps and TipsTo filter an Excel sheet by text in Microsoft 365 for Windows, select a cell in your data…
- Filter Excel Using a PivotTable: Practical Steps and TipsTo filter Excel data with a PivotTable, click inside the PivotTable, open the PivotTable Fields pane, and drag…
- When VLOOKUP Does Not Work: Common Causes and FixesVLOOKUP usually fails because its lookup value does not exactly match the first column of the selected range,…
- How to Compute Numbers in Excel with Formulas and FunctionsTo compute numbers in Excel, enter a formula in a cell beginning with an equals sign, then use…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.