Excel Filter Not Showing All Data? Find the Cause Fast

Excel filters usually miss rows because the filter range stops before the full dataset, or because the values that look alike are stored differently. In Excel for Microsoft 365 on Windows, clear the current filter, select the entire data range including its headers, and choose Data > Filter; then check for blank separators, inconsistent values, and hidden rows if records are still missing.

How Excel decides which rows to filter

An AutoFilter applies to a rectangular range: a header row and the records below it. When you turn on filtering with a cell selected, Excel usually guesses the data block around that cell. The guess can be wrong if the block contains an empty row or column, or if you started the command from a disconnected part of the worksheet.

Each column’s dropdown filters the records in that range by the values in that column. It does not automatically search every populated cell on the worksheet. For instance, suppose a report has headers in row 1, records in rows 2 through 80, and another group of records in rows 82 through 120. If row 81 is blank, activating Filter from the first group may include only rows 1 through 80. The second group is outside the filter range, even though it looks like part of the same report.

A filter also does not repair inconsistent source data. A date saved as text, a number entered as text, or a value with an extra space may be treated separately from what appears to be the same value. Finding the cause starts with distinguishing a range problem from a value problem.

First checks when records seem to be missing

Before changing the data, check whether a filter is already active. A column dropdown with a filter icon indicates that a condition is applied. Choose Clear Filter From [column name] in that dropdown, or use Data > Clear to clear filters on the current range. This reveals whether another column’s criteria are hiding the rows you expect.

Look at the row numbers. If they skip, some rows are hidden, often by a filter. If the row numbers are consecutive but a record is absent, inspect the range and source values.
Open the relevant dropdown and inspect the checked items. A search term in the dropdown’s search box, or cleared checkboxes, can exclude values without making the reason obvious on the sheet.
Check whether the column has a text, number, or date filter. A condition such as “Greater Than” can hide records that do not meet it, even when their values look close.
Use Ctrl+End on Windows to see how far Excel considers the used worksheet area to extend. This does not prove the filter range is correct, but it can help locate data far below the visible report.

On Mac, use the Data tab and its Filter or Clear controls; ribbon names are generally similar, but keyboard shortcuts can differ by Excel version and keyboard settings. The ribbon commands are a dependable alternative if a Windows shortcut does not apply.

Expand or recreate the filter range

To include all records, select the full rectangular dataset, including its header row, before turning on the filter. Then choose Data > Filter. Check that each intended header has a dropdown and that the selection reaches the last data row and last field. Avoid including unrelated notes or totals below the dataset, since those rows may then be treated as records.

If an existing filter is attached to the wrong range, turn it off with Data > Filter, select the correct range, and turn it back on. You can also select a cell in the intended data and use Ctrl+Shift+L on Windows to toggle AutoFilter; selecting the range first is the safer approach when Excel’s automatic boundary detection may be unreliable. On Mac, use Data > Filter if the Windows shortcut is not available in your setup.

For a dataset that changes regularly, convert it to an Excel table. Select a cell in the data and choose Insert > Table, confirm the displayed range, and verify that My table has headers is selected if the first row contains field names. A table provides filter arrows in its header row and can expand when new data is entered immediately below it. Do not leave a blank row between the table and new records, and verify the table range if pasted data does not become part of it.

To inspect or change a table’s boundaries, click inside it and use Table Design > Resize Table. Review the range shown in the dialog, edit it to include the missing rows or columns, and confirm. Table Design appears when a table is selected. If you use an ordinary range instead, selecting the correct range before Data > Filter is the key step.

Look for blank rows, blank columns, and header issues

A completely blank row inside a dataset can divide what Excel recognizes as a continuous region. A blank column can have a similar effect. These separators are common in reports designed for printing, but they can make the automatic filter range stop early. Remove unnecessary separators or select the complete range manually before applying the filter. A blank cell in one record is different from a fully empty row: it does not necessarily end the range, but it can make that record harder to interpret.

Filtering works best with one clear header row and one field per column. Merged header cells, multirow headings, or decorative title rows above the headers can confuse selection and make the dropdowns appear on the wrong row. Keep a title outside the dataset, use a single header such as “Order Date” or “Region,” and avoid merged cells in the data area. If the source report needs a complex presentation, a separate clean table is often easier to filter.

Check for missing or misleading headers as well. If the first row of the selected range is actually a record, Excel may treat that record as a header, so it will not appear among the filtered data rows. Conversely, including a title row as the header can make the actual column names behave like records. Re-select the range so its top row contains the real field names.

Check for values that look the same but differ

Excel may store visually similar entries as different values. A column can contain the number 125 as a numeric value in one row and the text “125” in another. Dates can also be real Excel dates in some rows and text strings in others. Depending on the filter type and the data, the dropdown may group or present these values differently, and date-specific options may not behave as expected for text dates.

Extra spaces and nonprinting characters are another frequent source of surprises. “North” and “North ” can look identical in a narrow cell but are not the same text. Imported files may also contain nonbreaking spaces that ordinary trimming does not remove. Inspect suspect cells in the formula bar, widen the column, and compare a missing record with a record that does appear. If values came from a CSV, website, or another system, check the import or cleanup process rather than relying only on how the cells are formatted.

Number formats can disguise the underlying value. A cell displayed as 01 may contain the number 1 with a custom format, while another cell contains the text “01.” Formatting changes appearance, not necessarily the stored data. Before converting a column, make a copy or test on a small sample; changing text to numbers or dates can alter identifiers such as account codes that are meant to retain leading zeros.

Check active criteria, hidden rows, and worksheet restrictions

Filters on multiple columns work together. If Region is set to West and Status is set to Open, only records satisfying both conditions remain visible. A missing row may therefore be excluded by a different column from the one you are checking. Use Data > Clear to remove the current filter criteria, then apply one condition at a time to identify which one removes the record.

Manually hidden rows can also make the visible results confusing. Clear filters and inspect the surrounding row numbers; select the rows around the gap, right-click, and choose Unhide if appropriate. Clearing a filter and unhiding rows are separate actions: clearing filter criteria does not necessarily reveal rows hidden manually.

If the filter arrows are missing or unavailable, confirm that the correct cells are selected and that the sheet is not protected in a way that prevents filtering. A protected sheet may allow filtering only if that permission was enabled when protection was set. Ask the workbook owner to adjust protection rather than trying to alter restricted content. For data returned by a query or external connection, also check whether the missing records exist in the refreshed output; a worksheet filter cannot display rows that were never loaded into the sheet.

Make the dataset easier to filter next time

Consistent structure prevents many recurring problems. Keep one header row, avoid blank separator rows within the records, use one data type per field, and put totals below or beside the dataset rather than in its middle. When possible, use an Excel table for data that grows over time. These habits make the range easier for Excel to recognize and make filters more predictable for anyone using the workbook.

When adding records to a table, enter them in the row immediately below it or use the table’s last row. Check that the table boundary expands, especially after pasting.
When importing data, inspect dates, numeric identifiers, spaces, and empty rows before filtering. Preserve leading zeros for codes where they matter.
When a result looks wrong, clear all criteria first, confirm the range, and then apply filters again one column at a time.
Keep an untouched copy of important source data before cleaning or converting values. This makes it easier to recover if a conversion changes identifiers or dates.

These practices also help when sorting, making PivotTables, or moving data into another system, because those tools depend on a clean and consistently structured source range.

Frequently Asked Questions

Why does my Excel filter stop at a certain row?
Excel may have detected only the first continuous block of data, particularly if there is a blank row or column between sections. Select the full range, including its headers, and choose Data > Filter. For a growing dataset, consider converting it to a table.

Why is a value missing from the filter dropdown?
First clear active criteria and check the range. Then compare the source cell with a similar value that does appear. The missing entry may be outside the range, stored as text rather than a number or date, contain extra spaces, or be hidden by a search term in the dropdown.

Does a blank row always stop an Excel filter?
No. A blank cell within a record does not necessarily split the data, but a fully empty row can cause Excel’s automatic range detection to treat the data above and below it as separate blocks. Selecting the entire range manually avoids relying on that detection.

Why does clearing the filter not show every row?
Some rows may have been hidden manually, or the filter may be applied to a range that does not include them. Check for gaps in row numbers, use Unhide where needed, and verify the filter boundary separately. A clear filter removes criteria; it does not automatically fix the selected range or every hidden-row state.

Will an Excel table include new rows automatically?
Tables generally expand when you type or paste data directly beneath them, but a blank separator or a paste outside the table can leave new records out. Click inside the table and inspect Table Design > Resize Table if the new rows do not receive the table formatting and filter behavior.

Why do two identical-looking dates filter differently?
One may be a real Excel date value and the other text that only looks like a date. Cell formatting alone does not convert text into a date. Check how the values were imported and convert only after confirming the intended date interpretation and preserving a backup of the original data.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.