Fix Excel Filter Stops After a Certain Row in WPS Spreadsheets
Question details
The user needs to make Excel filters apply to the entire data set when filtering stops after a certain row and newer rows are not included.
- Product
- WPS Spreadsheets (Microsoft Excel-compatible)
- Device & OS
- not provided
- Scenario
- The user has a data set where filters only apply to part of the rows, and rows added or located below a certain point are left out of the filter range.
- Observed behavior
- The filter works only on the upper rows of the data set, while newer rows below the Excel Table or defined filter range are not included.
Open the workbook in WPS Spreadsheets and identify the last row currently affected by the filter and the last row that contains data. Note the full range your data should cover before resizing the table or filter range.
Resize the Excel Table range to include all rows
Use this solution when the upper data range is already an Excel Table but filters stop at the rows outside the table.
Filters in an Excel Table only cover the defined table range. Rows added directly below the table are not included until the table range is enlarged.
Click any cell within the existing filtered table in WPS Spreadsheets.
Go to the Table Tools or Table Design tab on the ribbon.
Click Resize Table and select or type the full range that includes all rows and columns in the data set.
Click OK, then use the filter drop-down to confirm that the newly included rows now appear.
Convert the full data set to an Excel Table
Use this solution if the data is a normal range or if you want filters and formulas to expand automatically as new rows are added.
Resize Your Excel Filter Range in WPS Spreadsheets
Open your Excel workbook in WPS Spreadsheets, resize or convert the table, and make filters include every row without rebuilding the file.
- 1. Open the workbook: Launch WPS Spreadsheets and open the Excel file that has the filter issue.
- 2. Click inside the table: Click any cell within the existing table or filtered range.
- 3. Resize the table: Go to Table Tools > Resize Table and extend the range to include all rows.
- 4. Confirm the range: Click OK to apply the expanded range.
- 5. Check the filter: Use the filter drop-down to verify that rows after the previous cutoff are now visible.
Frequently Asked Questions
Why does my Excel filter only work up to a certain row?
The rows below that point may be outside the Excel Table or the defined filter range. Filters only process the range that is currently selected or defined, so rows added below the table are not included until the range is expanded.
How do I resize an Excel Table in WPS Spreadsheets?
Click any cell inside the table, go to Table Tools or Table Design, click Resize Table, and then select or type the full range that should be included.
Can I make filters include new rows automatically?
Yes. Convert the full data set to an Excel Table using Insert > Table or Ctrl+T. An Excel Table automatically expands its range when new rows are added, so filters and formulas update with it.
Does WPS Spreadsheets support Excel Table and .xlsx files?
Yes. WPS Spreadsheets is compatible with Microsoft Excel .xlsx files and supports Excel Table features, including resizing tables, applying filters, and working with structured references.
Where can I check the current table range?
You can check the current table range by clicking inside the table and opening Table Design > Resize Table, or by inspecting the defined names in Name Manager.
