Excel Filter Not Showing All Items? Find the Cause

If an Excel filter is not showing all items, first clear filters on every column, then check that the filter covers the entire data range, including the rows you expect. In Excel for Microsoft 365 on Windows, choose Data > Sort & Filter > Clear to remove active filters; if values are still missing, check for blank-row boundaries, inconsistent entries, or the filter’s 10,000-item display limit.

How Excel decides which items to show

An AutoFilter menu lists distinct values found in the range or table being filtered. It does not list every value anywhere in the workbook. If the range ends before newer records, or another filter has removed the only rows containing a particular value, that value may not appear in the menu. Excel also treats entries that look alike but differ in their underlying content as separate items.

Filters on different columns work together: a row must meet the active criteria in each filtered column to remain visible. For example, filtering a Sales table to show the West region and then choosing a particular product means the list of available values reflects records that satisfy the existing region filter. A value absent from the remaining records may therefore disappear from another column’s menu. This is expected behavior, not necessarily a damaged workbook.

Start by looking for the filter icon in each header. A funnel icon indicates that a filter is active on that column. The drop-down menu may also show check marks or a filter command that lets you clear that column alone. If you are unsure which criteria are active, clear them all and apply the filter again.

Check whether the filter covers all your data

A common cause is a filter applied to only part of the dataset. This can happen when new records were added below the original range, or when a completely blank row or column separated the records from the header. Excel often identifies a contiguous block of data when you turn on filtering; a blank row can make the block appear to end early.

Click a cell in the data and inspect the range outlined when you select the filter or table. Confirm that the header and every intended record are included.
Look for entirely blank rows or columns between the header and the missing records. Remove an accidental separator or select the full dataset before applying the filter.
Choose Data > Filter to turn the filter off, select the complete range including its header row, and choose Data > Filter again.
Open the relevant drop-down and check whether the missing item is now listed.

For a growing dataset, convert the range to an Excel table using Insert > Table, or press Ctrl+T on Windows after selecting the data. Confirm that My table has headers is selected if the first row contains field names. Tables normally expand when you type or paste directly below them, and their filter controls stay associated with the table. If a new block is separated from the table by a blank row, however, it may not be included automatically.

Clear filters in other columns

Filters are cumulative, so a hidden item may simply have no matching records under the other criteria. Clear filters in all columns, not just the one where the missing value should appear. On Windows, use Data > Sort & Filter > Clear to remove the current filters for the range. To clear just one column, open its filter menu and choose the command to clear that column’s filter; the wording includes the column name.

You can also test the dependency directly. Clear the other columns first, then open the menu where the item is missing. If it reappears, the range is probably sound and another filter had excluded its records. Select the other criteria again one at a time to find which combination removes it. This is especially useful in wide reports where several filters can be active without being obvious at a glance.

Choosing several values in the same column generally keeps rows matching any selected value, while criteria applied to separate columns narrow the results together. For example, selecting East and West in Region, then January in Month, shows records in either region that also meet the January criterion.

Look for entries that only appear to match

Entries that look identical on screen may not be identical to Excel. A trailing space, a nonbreaking space copied from a website, a spelling variation, or a different punctuation mark can create a separate filter item. For example, North and North followed by a space may appear nearly the same in a narrow drop-down, but they are distinct text values. Likewise, the number 123 and text stored as 123 can behave differently in sorting and filtering.

Widen the column or inspect the source cells in the formula bar to compare suspicious entries. For a larger list, use a helper column to standardize the source data, or use Find and Replace carefully after making a copy of the data. Trimming ordinary extra spaces may help, but copied nonbreaking spaces can require separate cleanup. Do not replace values blindly: a difference such as ID-01 versus ID-1 may be meaningful in your records.

Dates can also be confusing. Excel’s date filter often presents a hierarchy of years, months, and days rather than a flat list of every formatted date. The displayed format may hide the time portion of a date-time value, so two cells that look like the same date can still have different underlying times. If a date seems absent, clear other filters and inspect the original cells and number formats before changing the data.

Know the filter list’s display limit

Excel’s AutoFilter drop-down displays at most 10,000 unique items in its checklist. If a column contains more distinct entries, the checklist may not show every one even though those records are inside the filter range. This limit concerns what the menu displays; it does not mean the worksheet has lost the records.

Use the search box in the filter menu to look for a particular value that is not visible in the checklist. For broad selection, use the menu’s Text Filters, Number Filters, or Date Filters options, such as choosing a condition or range, rather than checking thousands of individual values. If you need to work with a very high-cardinality field, consider narrowing the data first or using a PivotTable, Power Query, or a separate analysis method that better suits the task.

Check tables, PivotTables, and refreshed data

Regular worksheet filters and PivotTable filters are different features. If the missing items are in a PivotTable, its field menu may show only items represented in the PivotTable’s current source or cache, and other report filters or slicers can narrow the display. Confirm that the source data includes the records, then refresh the PivotTable using PivotTable Analyze > Refresh. If new rows were added outside the original source range, change the data source so the PivotTable includes them before refreshing.

For data loaded from an external source or Power Query, a refresh can replace the table’s contents with the latest results. Check the query’s source and any applied query steps if particular records are absent after refresh. A worksheet filter only filters rows currently present; it cannot restore records that the source or query did not load.

In Excel for the web, the basic Data > Filter controls work similarly, though some advanced options and interface details may differ from desktop Excel. On Mac, use the Data tab’s Filter controls; ribbon layout and keyboard shortcuts can differ from Windows. If menu labels do not match these Windows steps, look for the Filter command on the Data tab and clear the active column criteria there.

A quick troubleshooting order

Use this sequence to isolate the cause without changing the underlying records unnecessarily:

Clear every active filter and confirm whether the supposedly missing records are visible in the sheet.
Check that the filter range or table includes the header and all records, including recently added rows.
Remove accidental blank-row or blank-column separators that split a plain range.
Search for the missing value in the filter menu, especially if the column has many unique entries.
Inspect near-duplicate text, data types, and dates with hidden time values.
If the data is in a PivotTable or query result, check its source and refresh it where appropriate.

If the records are visible after clearing filters but disappear when one criterion is reapplied, the issue is probably the criteria combination. If the records are not in the worksheet at all, investigate the source, table boundary, or refresh process instead of changing filter settings.

Frequently Asked Questions

Why does Excel show only some values in the filter drop-down?
It may be listing values from a partial range, reflecting filters on other columns, or reaching the 10,000-unique-item checklist limit. Clear other filters, confirm the range, and search the menu for a specific value.

Why did my new rows not appear in the filter?
The rows may sit outside the filtered range, particularly if they were added below a blank row or after a plain range was first filtered. Expand the range or convert it to a table so new records added directly below it can be included.

Can another column’s filter hide an item from this menu?
Yes. The available values can reflect the rows remaining after other column filters are applied. Clear the other filters temporarily to see whether records containing the item return.

Why are duplicate-looking values listed separately?
The cells may differ by spaces, punctuation, spelling, number-versus-text storage, or another hidden character. Inspect the source cells before cleaning them, since some apparent differences may be intentional.

Does a PivotTable use the same filter list as a worksheet table?
No. PivotTable field filters depend on the PivotTable’s source and cache, and slicers or report filters may also narrow results. Check the source range and refresh the PivotTable when its data changes.

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.