Excel Filter Not Working After a Certain Row? Fix It

If Excel filtering stops at a certain row, the filter range usually ends there—often because a completely blank row separates the data, or because the filter was applied to only part of the list. Select the full data range and reapply the filter, or resize the Excel table; then check for other issues such as inconsistent data or an active filter in another column.

What the cutoff usually means

A filter does not normally stop evaluating records after a fixed number of rows. Instead, Excel applies filter controls to a defined range or table. If rows below the cutoff are outside that range, their dropdowns and filter results will not be included. This is why the same apparent symptom can have different causes: perhaps the filter arrows are missing on later rows, or perhaps the arrows are present but some records do not appear when you select a value.

Look at the header row and the first row that seems to be ignored. If filter arrows appear only above the first block of data, suspect a range boundary. If arrows continue down the column but a particular value is missing from the dropdown, investigate the cell contents, the active criteria, and the size of the dropdown’s value list. Excel’s worksheet limit is 1,048,576 rows, so a cutoff in an ordinary-sized list is not a normal row-count limit.

A filter also hides rows rather than deleting them. A row number that jumps, such as 28 followed by 35, means rows 29 through 34 are hidden by the current filter or another hiding action. Clear the filter before deciding that records are missing.

How Excel decides which rows belong to a filter

When you click a cell in a block of data and turn on Filter, Excel generally detects the surrounding current region. A completely empty row or column can mark the edge of that region. For example, if a sales list has headers in row 1 and records in rows 2 through 40, but row 41 is entirely blank and more records start in row 42, Excel may treat the second block as separate. A filter started in the first block can then leave the later records outside its range.

A blank-looking row is not always an entirely blank row. A formula that displays an empty string, a space, or a value in a neighboring column can affect how Excel detects a block. Conversely, a fully empty spacer row is a strong clue that automatic range detection stopped there. Blank cells inside a selected range do not automatically remove the remaining rows from a filter; the issue is often that Excel selected a smaller range in the first place.

Headers matter too. A filter expects one header row with a distinct label for each column. If the data has a title above the headers, multiple header rows, merged header cells, or a blank header, Excel may identify the wrong row or create confusing dropdowns. A decorative title should sit above the list, not be included as if it were a data record.

Quick fix: select the complete range and reapply Filter

For a normal range, the most direct repair is to explicitly select every header and data row, including the rows below the cutoff, before turning on the filter. On Windows in Excel for Microsoft 365:

Click a cell in the data and press Ctrl+A once to select the current region. Check that the selection includes the last row you need. If a blank row splits the records, Ctrl+A may select only one block.
If necessary, select the full range manually by dragging from the top-left header cell to the bottom-right data cell, or click the Name Box to the left of the formula bar, type a range such as A1:F250, and press Enter.
Go to Data > Filter. If filters are already on, turn them off first, make the full selection, and turn them on again.
Open a dropdown and check whether values from the previously excluded rows now appear. Clear any active criteria if the visible results still seem incomplete.

Ctrl+Shift+L toggles Filter on Windows. It is a toggle, not a command that automatically expands an existing range. If the filter is attached to an undersized range, pressing the shortcut alone may simply switch that same filter off and on. On a Mac, use Data > Filter if the shortcut differs on your keyboard or Excel build; the ribbon command is the reliable route.

Check and resize an Excel table

If your list is formatted as an Excel table, the filter range is the table rather than an arbitrary block. Click inside it and check whether the table boundary includes the rows in question. When a row has been pasted below the table, inserted after a gap, or otherwise not incorporated, its values may sit outside the table and will not respond to the table’s filter dropdowns.

To extend a table in Excel for Microsoft 365 on Windows, click inside it, open Table Design, choose Resize Table, and enter or select the complete range, including the header row. Confirm the range and then test the filter again. You can also drag the small resize handle at the table’s bottom-right corner, when visible, down to include additional rows. Table Design appears only when a table cell is selected.

Excel tables often expand when data is typed or pasted immediately below them, but automatic expansion is not guaranteed in every layout or workflow. A blank row, a total row, or content placed beside the table can make the boundary less obvious. Check the table’s actual outline rather than assuming that nearby rows are included. On Mac, the contextual table tab and available commands can vary by release; use the table design controls to find Resize Table, or select the full data range and recreate the table if resizing is unavailable.

When the range is right but results still look wrong

If filter arrows extend through the last row, the range may already be correct. Clear the current criteria first. In Windows Excel, use Data > Sort & Filter > Clear, then reopen the dropdowns. A condition in a second column can make it seem as if one column’s filter is failing: Excel combines filters across columns, so a row must satisfy all active column criteria to remain visible.

Next, inspect the values in the affected column. Text that looks identical may contain leading or trailing spaces, nonbreaking spaces, or other invisible characters. A value such as North followed by a space can be treated differently from North. Numbers stored as text can also behave differently from numeric values, and dates imported as text may not group or filter like real Excel dates. Compare a cell above the cutoff with one below it in the formula bar, and consider cleaning or standardizing imported data before filtering.

Also check whether the rows are hidden manually or by grouping. Clear removes filter criteria but does not necessarily unhide rows hidden with the row commands or outline controls. Select the rows around the gap, right-click a row heading, and choose Unhide if appropriate. If the worksheet is protected, filtering may be restricted depending on the protection settings; ask the workbook owner to review protection rather than assuming the range is broken.

One less obvious limit concerns the dropdown list, not the rows being filtered: Excel’s AutoFilter dropdown can show at most 10,000 unique items in its value checklist. In a column with more distinct values, a value may not be visible in that checklist even though the filter applies to the full range. Use the dropdown’s search box where available, or use text, number, or date filter options instead of scrolling through the checklist.

A reliable way to diagnose the exact cutoff

Work from the boundary outward instead of changing several settings at once. First clear the filter so you can see whether rows are actually hidden. Then confirm that the header arrows appear on the intended header row and that the suspected later records are inside the outlined range or table. If they are outside, expand the range. If they are inside, check criteria and the underlying cell values.

Arrows stop at the cutoff: expand the selected range or resize the table.
Arrows continue, but a value is absent: search the dropdown, clear other criteria, and compare the cell’s actual contents.
Rows are missing even after clearing filters: check for manually hidden rows, grouping, or protection.
Only imported dates or numbers behave oddly: check whether the cells contain real dates or numbers rather than text.

For a controlled test, select a cell in one of the excluded rows and see whether the Table Design tab appears. If it does, that row is part of a table; inspect its boundary. If not, it may be a regular range or a row outside the table. You can also turn Filter off, select the intended range explicitly, and turn it back on. This test distinguishes a range problem from a value or criteria problem without altering the data itself.

Set up lists so filters include future rows

For data that will keep growing, converting a clean list to a table is usually more dependable than relying on automatic detection of a plain range. Select the data, including one header row, and use Insert > Table; confirm that My table has headers is selected when appropriate. Tables provide filter controls and typically extend calculated columns and formatting as new rows are added. Keep one header row, avoid merged cells, and do not place blank spacer rows inside the records.

If a plain range is necessary, leave the data in one uninterrupted block and select the entire intended range before enabling Filter. Avoid putting notes, totals, or a second mini-table immediately beside the list, because adjacent content can confuse the boundary Excel detects. When importing or pasting records, check the final row and verify that the filter still reaches it. These small checks are especially useful in shared workbooks where people add data in different ways.

Filtering is a view of the existing records, not a data-cleaning operation. It does not correct inconsistent text, convert dates stored as text, or permanently remove unmatched rows. Keep a copy before making bulk changes to imported data, and use a separate clean-up step if the underlying values need standardizing.

Frequently Asked Questions

Why does my Excel filter stop at row 100 or another specific row?

That row is often the edge of the range Excel detected when Filter was turned on. Look for a completely blank row or column near the boundary, then select the full list and reapply the filter or resize the table.

How do I extend an Excel filter to include more rows?

For a regular range, select the complete range including headers and use Data > Filter. For a table, click inside it, choose Table Design > Resize Table, and include the additional rows in the new range.

Why is a value missing from the filter dropdown?

First clear other filters and search the dropdown. The value may contain extra spaces, be stored as a different type, or be beyond the dropdown’s 10,000-unique-item checklist display limit. The row can still be inside the filter range.

Does a blank row always stop Excel filtering?

A fully blank row can split the current region Excel detects when you turn on Filter from a single cell. It does not cut off a range that you explicitly selected to include rows on both sides of the gap, although leaving spacer rows inside a data list is still poor structure.

Why are rows still hidden after I clear the filter?

They may have been hidden manually or by a grouped outline rather than by the filter. Select the surrounding row headings, right-click, and choose Unhide, or expand the outline controls. Clearing filter criteria does not undo every other way rows can be hidden.

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.