Excel Filter Not Working for All Rows? Find the Cause

If Excel’s filter is not working for all rows, its filter range may stop before the missing records, or another issue—such as a blank separator row, a manually hidden row, or an active criterion—may be making those records appear absent. In Microsoft 365 for Windows, clear existing criteria, select the complete data range including its header row, then choose Data > Filter; for data you update regularly, convert the range to a table with Insert > Table.

How Excel decides which rows to filter

Excel applies AutoFilter to a range of columns with a header row. When you click a cell in a continuous block of data and turn on filtering, Excel generally detects the surrounding region. That automatic detection is convenient, but it can stop at completely blank rows or columns. If new records sit below a blank line, they may be outside the range even though they look like part of the same worksheet list.

A filter does not delete records. It temporarily hides rows that do not meet the selected criteria, leaving matching rows visible. If a record is outside the filter range, changing a dropdown criterion cannot make it appear: Excel is not evaluating that record at all. This is why checking the range is a useful first step when the filter seems to affect only part of a list.

Headers matter too. Excel expects one distinct heading per column in a single header row. A title above the data is fine if it is outside the filtered range, but including a multi-row heading, merged header cells, or blank header cells can make the list harder to filter reliably. Keep the actual column names together in one unmerged row.

Check and reset the filter range

First remove active criteria so you can tell whether the problem is the range or a filter choice. On the Windows ribbon, choose Data > Clear. This clears filter criteria while leaving filter buttons available. Then inspect the data from the header row down to the last record, including any rows that seem to be missing.

Click a cell inside the data, then choose Data > Filter to turn off the current filter buttons.
Select the complete rectangular range, from the first header through the final row and column. Include blank cells within the data if they belong to the list, but do not include unrelated notes or totals.
Choose Data > Filter again. Check the dropdown buttons on each header and test a criterion that should include a record near the bottom.
If the buttons still cover the wrong range, turn them off, select the intended range explicitly, and apply Filter again.

For example, if headers are in row 1, records run through row 240, and a note is in row 242, the filter should cover the header and records—not the note. Selecting only a cell near the top and relying on automatic detection can exclude later records if a fully blank row separates them. Selecting the intended range explicitly avoids relying on that guess.

Look for blank rows and columns

A fully blank row or column can divide a worksheet into separate regions. A common case is a report with records in rows 2–80, a blank row 81, and more records from row 82 onward. If filtering is started from the upper block, Excel may treat the lower block as separate data. The same can happen when an empty column divides fields that seem visually related.

Do not assume every empty cell breaks a filter. A blank cell within an otherwise continuous list is different from a completely blank separator row. An existing filter range or an Excel table can include blank cells inside its boundaries. The key question is whether the records you need are inside the actual range.

Remove a separator row only if it has no purpose, or include the lower records when selecting the range.
Check for columns that look empty but contain spaces, formulas returning an empty string, or formatting. These may affect how a region is detected.
Avoid putting subtotals, explanatory notes, or a second header in the middle of a list. Keep summaries outside the data range.

Check criteria, search, and data types

Sometimes the range is correct, but a selection in one or more dropdowns excludes the rows you expect. A small filter icon on a header can indicate that a criterion is active. Open each relevant dropdown and check whether Select All is selected, whether a search term remains in the box, and whether another column has a filter that narrows the results. Multiple column filters combine: a row must satisfy every active criterion to remain visible.

The checklist in a dropdown can also be misleading when a column has many distinct values. Excel’s AutoFilter dropdown list displays up to 10,000 unique items. If a field contains more unique entries, searching the checklist may not be a dependable way to locate a value. Use the menu’s Text Filters, Number Filters, or Date Filters options where appropriate, or filter a more specific field.

Data that looks alike may not be stored alike. For instance, a column can contain the number 25 as a numeric value in some rows and the text 25 in others. Dates can likewise be real Excel dates in some cells and text strings in others. A filter may group or offer criteria differently as a result. Check a few cells, their number formats, and the source data if a seemingly identical value is missing. Leading or trailing spaces can also create separate text entries.

Date dropdowns often organize genuine dates into years, months, and days. If you need to find a particular period, use Date Filters rather than assuming the date will appear as one plain text item. For numbers, use Number Filters to set a comparison such as greater than or between. These options can be more precise than manually checking a long list.

Make sure rows are not hidden another way

Clearing a filter does not necessarily reveal a row that someone hid manually. It also does not remove outline grouping, which can collapse rows independently of filtering. If the row numbers jump—for example, from 18 to 25—look for hidden rows or a collapsed outline as well as an active filter.

To reveal manually hidden rows in Excel for Windows, select the row headers on either side of the hidden section, right-click, and choose Unhide. To reveal every hidden row, select the whole sheet using the corner button above row 1 and left of column A, then choose Home > Format > Hide & Unhide > Unhide Rows. Unhiding the whole sheet may reveal rows intentionally concealed, so use it only when that is acceptable. For grouped rows, use the outline controls beside the row numbers to expand the group.

A protected worksheet can restrict filtering or changes to filter settings. Check Review > Unprotect Sheet if you are authorized to edit it; a password may be required. Do not try to work around a password restriction. If the sheet is meant to stay protected, ask its owner to enable the needed filtering permissions or provide an editable copy.

Use an Excel table for a changing list

If records are added often, an Excel table is usually more dependable than a manually maintained filter range. Select a cell in the data and choose Insert > Table. Confirm that the selected range is correct and select My table has headers when the first row contains the column names. Tables provide filter buttons and generally expand when you type or paste data directly into the row immediately below them.

A table is not a cure for every range problem. Records separated from it by blank rows or placed elsewhere on the sheet will not automatically become part of it. Check the table boundary if new rows remain outside the filter. You can resize a table from Table Design > Resize Table, selecting the table first. Table Design appears when a table cell is active; the tab label or layout can vary slightly by Excel release.

Tables also help keep headers and records together when sorting or adding data. Before converting an existing range, check that it has one header row and no merged cells in the data area. If the workbook uses totals or notes, keep them outside the table or use the table’s built-in Total Row option rather than inserting an unrelated row inside the list.

Consider imported data and refreshes

When a list comes from a query, database, or external connection, the worksheet may simply be showing an older or partial result. In Microsoft 365 for Windows, choose Data > Refresh All to refresh workbook connections and queries, provided the connection is available and you have permission. Then check the refreshed output range and the filter again. Refreshing may replace or rearrange data, so save a copy first if the workbook contains manual changes alongside imported results.

For formula-generated values, confirm that calculations are current if the displayed values seem stale. On Windows, check Formulas > Calculation Options and use Automatic if that is appropriate for the workbook. Filtering acts on the values Excel currently has; a filter cannot correct an incorrect source, a failed refresh, or a formula that has not recalculated.

Prevent the problem in future worksheets

A few layout habits make filters more predictable and easier for other people to use:

Keep one header row, with a unique, nonblank name for every field.
Keep each record on one row and each field in one column; avoid blank separator rows inside the list.
Do not merge cells in the header or data area.
Use a table for lists that grow, and verify that new records are inside its boundary.
Keep report titles, notes, and summaries outside the data range.
When results look incomplete, clear criteria and verify the range before rebuilding the worksheet.

On a Mac, the same basic checks apply, but ribbon shortcuts and some controls differ from Windows. Use the Data tab’s Filter and Clear controls or Insert > Table rather than relying on a Windows keyboard shortcut. Excel for the web also supports filtering, though some workbook and ribbon controls may appear in a different location. If colleagues use multiple platforms, a simple table with one header row is easier to maintain consistently.

Frequently Asked Questions

Why does Excel filter only the first part of my list?
The filter may have been applied to a range that ends before later records, often because a blank row or column separated the data when Excel detected the range. Turn off filtering, select the full range including its headers, and apply Data > Filter again.

How do I show all rows after filtering?
Choose Data > Clear to remove active filter criteria while keeping the filter buttons. If some rows remain hidden, check whether they were hidden manually or collapsed in an outline; clearing filter criteria does not necessarily reveal those rows.

Why is a value missing from the filter dropdown?
It may be excluded by a search or another active filter, stored inconsistently as text or a number, or among more unique values than the dropdown list displays. Check the column’s data and try Text Filters, Number Filters, or Date Filters instead of relying only on the checklist.

Will Excel automatically filter rows I add later?
A plain filtered range may not include records added beyond its current boundary. An Excel table generally expands when you enter or paste data directly below it, but separated records still need to be added to the table or range explicitly.

Why are rows still missing after I clear the filter?
They may be manually hidden, concealed by a collapsed row group, or absent because the displayed data has not refreshed. Check row numbers and outline controls, and refresh external data only when appropriate.

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.