Cannot Unhide Rows in WPS Excel? Check Active Filters and Row Height
Question details
The user needs to restore rows that remain hidden in a WPS Spreadsheets worksheet, typically because an active AutoFilter excludes rows or because rows have a zero row height.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user is working in a worksheet where rows are missing from view and standard Unhide Rows commands do not bring them back.
- Observed behavior
- Rows remain hidden until the active filter is cleared, row height is reset, or manual hidden rows and outline groups are expanded.
Open the affected workbook and confirm which worksheet contains the missing rows. Check whether the Data tab shows the Filter button as active, and note any grouped outline areas or frozen panes that may affect row visibility.
Clear Active AutoFilter to Restore Rows Hidden by Filters
Use this solution first when the Filter button is highlighted on the Data tab or filter arrows show an active filter.
Active AutoFilter excludes rows from view, but the rows are not permanently hidden. Turning off filtering restores them without changing the underlying data.
In WPS Spreadsheets, open the affected worksheet and click the Data tab on the ribbon.
In the Sort & Filter group, check whether the Filter button is highlighted. If it is, an AutoFilter is active.
Click the Filter button to turn it off. Rows hidden by filter criteria will reappear immediately.
If you want to keep the filter feature enabled, click the filter arrow on the filtered column and choose Clear Filter.
Reset Row Height to Restore Rows Hidden at Zero Height
Use this solution when clearing filters does not reveal the missing rows and the rows may be hidden by a zero or very small row height.
Check Manual Hidden Rows and Outline Groups
Use this solution when filters and row height are normal but specific rows remain hidden.
Restore Hidden Rows in WPS Spreadsheets
This task can be completed directly in WPS Office Spreadsheets. Turn off active filters, reset row height, and unhide manual rows to bring missing WPS Excel data back into view.
- 1. Open WPS Spreadsheets: Launch WPS Office and open the affected .xlsx or WPS spreadsheet file.
- 2. Open the Data tab: Click Data on the ribbon and locate the Sort & Filter group.
- 3. Turn off the active filter: If Filter is highlighted, click it to clear the active filters and reveal rows that were hidden by the filter.
- 4. Reset row height: Press Ctrl+A twice to select the whole worksheet, then click Home > Format > Row Height and enter 15.
- 5. Unhide manual rows: Select the rows around the hidden area, right-click, and choose Unhide.
Frequently Asked Questions
Why does Unhide not work in WPS Excel when rows are missing?
The rows may not be manually hidden; an active AutoFilter can exclude them from view. Open the Data tab and click the Filter button to turn off filtering.
How do I know if AutoFilter is active in WPS Spreadsheets?
On the Data tab, check whether the Filter button in the Sort & Filter group is highlighted. Filter arrows may also appear in the column headers.
What row height should I use to make invisible rows visible again?
Select the entire worksheet, click Home > Format > Row Height, and enter 15 points. This resets zero or very small row heights to a standard visible height.
How do I unhide manual hidden rows in WPS Excel?
Select the rows above and below the hidden area, right-click the row header, and choose Unhide. Also check for collapsed outline groups in the left margin.
Will clearing filters delete any data from my worksheet?
No. Clearing filters only removes the current view filter. The underlying data and formatting remain unchanged.
