Others

How to Extend an Excel Filter to Include All Rows

Maira Mehtab Sep 28, 2026 869 views

Question details

The user needs to include newly added rows in an existing Excel filter or sorting range.

How to Extend an Excel Filter to Include All Rows

Product: Spreadsheet
Device & OS: not provided
Scenario: Working with a growing dataset where new rows are added at the bottom but are excluded from the current active filter dropdowns.
Observed behavior: The filter covers only an older portion of the worksheet, leaving newer rows out of the filtering and sorting options.

Before you start

Check your dataset for completely blank rows or merged cells, as these interruptions often cause automatic filtering to stop prematurely.

Solution 1Recommended

Convert the Dataset into an Excel Table

Converting your data range into a structured table is the most reliable way to ensure filters automatically expand when new rows are added.

By formatting your data as a Table, Excel automatically binds the filter to the table boundaries. Any new rows typed directly underneath the table will be absorbed into the table range automatically.

Select your entire dataset

Highlight all the rows and columns that contain your data, making sure to include the header row and the newly added rows at the bottom.

Insert a table

Navigate to the 'Insert' tab on the top ribbon and click on 'Table'.

Confirm table range

A dialog box will appear. Verify that the selected range is correct, check the box that says 'My table has headers', and click 'OK'.

Automatic Updates: Once converted, any new row added directly below the table will automatically inherit the formatting and be included in the filter.

Solution 2

Reapply the Filter to the Full Range manually

Use this method if you prefer to keep your data as a standard range rather than converting it into a formal table.

Solution 3

Resize an Existing Table

If your data is already formatted as a table but the new rows were pasted outside its boundaries, you will need to resize the table range.

Efficient Data Management

Manage Growing Datasets Easily with WPS Spreadsheet

WPS Spreadsheet offers seamless data management tools. By formatting your data as a table in WPS, your filters and sorting ranges will automatically expand to include new entries, eliminating the need to reapply filters manually.

1. Open your dataset in WPS Spreadsheet: Launch WPS Office and open your existing spreadsheet document.
2. Select your data: Click any cell within your contiguous data block.
3. Format as Table: Go to the 'Insert' tab and click 'Table' to convert the range.
4. Add new data seamlessly: Simply type new data in the row immediately below the table; the filter dropdowns will instantly include the new information.

Automatically expands filter ranges when appending new rowsFully compatible with Microsoft Excel (.xlsx and .xls) formatsAdvanced filtering, sorting, and data validation toolsLightweight software with an intuitive, familiar interface

Frequently Asked Questions

Why does my Excel filter stop halfway down the page?

This usually happens when there is a completely blank row in your dataset. When you apply a filter by just selecting the header, the software assumes the data ends at the first blank row. You must remove the blank rows or manually select the entire range including the data below the blank row before applying the filter.

How do I fix a filter list scroll bar that is hidden on Mac?

On macOS, scroll bars may be hidden based on your system preferences. Move your pointer over the filter dropdown list and use a trackpad scroll gesture (two-finger swipe up/down) or a mouse scroll wheel. You can also change this globally by going to Apple Menu > System Settings > Appearance, and setting 'Show scroll bars' to 'Always'.

Will merged cells prevent my filters from working correctly?

Yes, merged cells disrupt the column structure and can cause unexpected results or errors during filtering and sorting. To fix this, select the merged cells, go to the 'Home' tab, and click 'Merge & Center' to unmerge them. Then, copy the necessary data into the individual unmerged cells.

Office Quick Solutions