Unable to Unhide Rows in Excel? Fix Row Height Problems in WPS Office Spreadsheets
Question details
The user needs to restore rows that appear hidden in a WPS Office Spreadsheets worksheet when the standard Unhide command does not make them visible.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- A user is editing a worksheet and notices that rows are missing or cannot be expanded.
- Observed behavior
- The rows are not formally hidden or the standard Unhide command has no effect. They may have a very small row height, or be affected by filters, grouping, or worksheet protection.
Save the workbook and confirm the worksheet is not protected. If Worksheet Protection is enabled, the Unhide and Row Height commands may be blocked until protection is removed.
Reset Row Height with Home > Format > Row Height
Use this when rows are not expanding because their row height was set to an extremely small value.
In many cases rows are not formally hidden but have a tiny row height. Selecting the surrounding rows and applying a normal height makes them visible again.
Select the rows above and below the missing area, or press Ctrl+A to select the entire worksheet.
Go to the Home tab, click Format in the Cells group, and choose Row Height.
Type a value such as 14 or 15 and click OK. The missing rows should appear.
Clear Filters and Remove Grouping to Reveal Hidden Rows
Use this if AutoFilter or grouped rows are hiding the data instead of a small row height.
Turn Off Worksheet Protection Before Unhiding Rows
Use this when the Unhide and Row Height commands are disabled or grayed out.
Restore Hidden Rows in WPS Office Spreadsheets
Open the workbook in WPS Office Spreadsheets and use the Home > Format > Row Height command to restore rows that appear hidden. WPS Office keeps Excel .xlsx formatting compatible and gives you a direct way to fix row height, filters, grouping, and protection issues.
- 1. Open the workbook in WPS Office: Launch WPS Office Spreadsheets and open the .xlsx workbook that contains the hidden rows.
- 2. Select the affected row area: Click the row headers around the missing rows, or press Ctrl+A to select the whole sheet.
- 3. Reset the row height: Go to the Home tab, click Format, choose Row Height, and enter a normal value such as 14.
- 4. Remove filters or grouping if necessary: Clear AutoFilter from Home > Sort & Filter or remove outlines from the Data tab.
- 5. Save the restored workbook: Confirm the rows are visible and save the file to keep the changes.
Frequently Asked Questions
Why does Unhide not work for rows in Excel or WPS Office Spreadsheets?
The rows may have a very small row height rather than being formally hidden, or they may be affected by filters, grouping, or sheet protection. Select the surrounding rows and set Home > Format > Row Height to a normal value such as 14.
How do I set row height in WPS Office Spreadsheets?
Select the rows or the entire worksheet, go to the Home tab, click Format, choose Row Height, enter a value such as 14, and click OK.
Can I unhide rows when the worksheet is protected?
No. First go to the Review tab and click Unprotect Sheet. If a password was set, enter it, then retry the Unhide or Row Height command.
Does WPS Office support Excel hidden row formatting?
Yes. WPS Office opens and saves .xlsx workbooks while preserving row height, filters, grouping, and worksheet protection settings.
