Data Import & Export

Fix Excel Filter Not Including New Data

Camila Milosovich Nov 12, 2026 869 views

Question details

The user needs to make an Excel filter include newly added records.

Product: Microsoft Excel
Device & OS: not provided
Scenario: New values were added below an existing filtered data range, but the filter does not include those rows.
Observed behavior: The filter covers only the original data region, often because a blank row interrupts the range or the new rows fall outside the selected filter range.

Before you start

Check whether a blank row separates the original records from the new data, and identify the header row plus every data row that should be filtered. Remove any active filter before selecting the complete range.

Solution 1Recommended

Reapply the filter to the complete data range

Use this method when new rows fall outside the range originally selected for the filter.

A blank row can make Excel treat the data as separate regions. Selecting the header and all current records together ensures the filter covers the intended rows.

Remove the current filter

Open the Data tab, select Filter, and turn off the existing filter or choose Clear to remove the current filtering conditions.

Select the full range

Drag from the header row through the last new data row, including every column that belongs to the dataset and any rows below the previous range.

Apply the filter again

With the complete range selected, open the Data tab and click Filter. Use the drop-down arrow in the header to filter the expanded range.

Check the range boundary: Make sure no blank row or blank column interrupts the data region. If one exists, remove it or select the range manually from the header through the final record.

Solution 2

Convert the data range to an Excel table

Use a table when records will continue to be added and the filter should expand automatically.

Keep New Rows Included in WPS Spreadsheet Filters

WPS Spreadsheet can reapply a filter to the complete data range or convert the range into a table so new records are easier to manage. Its familiar interface supports Excel workbooks and helps maintain filtering workflows during migration.

1. Open the workbook: Open the Excel workbook in WPS Spreadsheet and locate the data range with the incomplete filter.
2. Select all records: Select the header row and every current data row, including the newly added values and all relevant columns.
3. Apply the filter: Open the Data tab and click Filter to create a filter over the complete selected range.
4. Create a table if needed: For data that will grow, select the range, open the Insert tab, choose Table, confirm the header setting, and click OK.

Reapply filters across the complete header and data rangeUse tables that expand as new rows are addedOpen and save Microsoft Excel .xlsx files with strong format compatibilityWork in a lightweight spreadsheet application with a familiar Office-style interface

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel filter stop before the newest rows?

The filter may have been created on only the original range, or a blank row may separate the old and new records. Select the header and all data rows, then use Data > Filter again.

Can a blank row prevent Excel from filtering new data?

Yes. Excel can interpret the blank row as the end of the current data region. Remove the blank row or manually select the complete range before applying the filter.

How can I make a filter expand when I add records?

Convert the range to a table. Select the dataset, choose Insert > Table, confirm that the table has headers, and add future records directly below the table.

Should I include the header row when reapplying an Excel filter?

Yes. Include the complete header row and every data row in the selected range. The header cells provide the filter drop-down controls for each column.

Excel & Data Problems