Why a Google Sheets Filter Misses New Rows

A Google Sheets filter can miss new rows when its range stops above the latest data. Turn the old filter off, select the complete table—including the new rows—and create the filter again.

Last verified: July 28, 2026.

Check the Filter Range#

1. Click a filter icon in the header row.
2. Compare the last row in the filter range with the last row of your data.

If the filter ends at row 195 but your data now reaches row 260, rows 196–260 are outside the filter and will never appear in its values list.

Recreate the Filter Over the Full Table#

1. Choose Data > Remove filter or turn off the current filter.
2. Select the complete table through the last data row.
3. Choose Data > Create a filter.
4. Open the column filter and test a value from the newest row.

When rows are added later, leave blank rows inside the selected range or recreate the filter after expanding the table.

Use Filter Views for Shared Sheets#

Regular filters change the visible sheet for everyone. If collaborators need to filter independently, choose Data > Filter views > Create new filter view. Each person can then work with their own view without changing what others see.

Avoid Filtering Formula Output Directly#

Data filters are a poor fit for a range populated by QUERY, FILTER, SORT, or an array expression. The formula controls the output order and can refill rows after a manual filter operation. Put formula output on a dedicated tab, or add the sort condition to the formula itself.

Why a Text Value May Not Appear#

• The row is outside the filter range.
• The value contains an invisible space or different punctuation.
• The column mixes numbers and text.
• A formula output is being filtered as if it were manual data.

Quick Checklist#

• Compare the filter range with the latest data row.
• Remove and recreate the filter over the complete table.
• Use Filter views when collaborators need separate views.
• Keep formula-generated results separate from manual filter ranges.
• Clean spaces and mixed data types before searching filter values.

The Google Sheets filter community solution identifies an incomplete range as the cause when newer rows are excluded.

Related Google Workspace Fixes#

• How to Fix “Array Result Was Not Expanded” in Google Sheets
• How to Fix a Circular Dependency in Google Sheets

Get the Add-On#

免费获取插件

Text To Table Converter

Work faster inside Google Forms, Docs, Sheets, and Slides: Install the free Text To Table Converter add-on for quiz building, choice syncing, QR codes, document tools, and more.

免费安装