Fix Excel Rows That Become Hidden After Saving and Reopening
Question details
Find out why visible Excel rows become hidden after a workbook is saved and reopened.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user enters data into visible rows, saves the workbook, and opens it again.
- Observed behavior
- Rows that were visible before saving may be hidden after the workbook is reopened.
Note the affected worksheet and row numbers, then test whether the same behavior occurs in another workbook. Check whether the sheet is protected, as you may need permission or a password to change its settings.
Check row visibility and worksheet settings
Use this solution first when the issue appears to affect a particular workbook or worksheet.
Select the row headings on both sides of the missing rows, right-click the selection, and choose Unhide. Alternatively, select the worksheet and choose Home > Format > Hide & Unhide > Unhide Rows.
Select the affected rows and choose Home > Format > Row Height. Enter a positive height if the rows are too small to see.
On the Data tab, clear any active filters that exclude the rows. If the worksheet contains grouped rows, use the plus signs or outline level buttons beside the row headings to expand them.
Go to Review > Unprotect Sheet if protection prevents you from changing row settings. Enter the password if prompted, or ask the workbook owner for access.
Choose File > Save, close the workbook, and reopen it. Check the affected row numbers to see whether they remain visible.

Test Excel Safe Mode and review add-ins
Use this solution if rows also become hidden in another workbook or the worksheet settings do not explain the issue.
Open Excel Workbooks in WPS Spreadsheets
WPS Office is a free, lightweight, easy-to-use alternative with a familiar spreadsheet interface. Open compatible Excel files in WPS Spreadsheets to continue working with your data and make migration straightforward; it does not repair Excel itself.

Frequently Asked Questions
How can I tell whether a filter is hiding my Excel rows?
Look for filter buttons in the header row, then go to the Data tab and clear active filters. Rows excluded by a filter should appear again.
Why can't I unhide rows in my worksheet?
Sheet protection may prevent changes. Check Review > Unprotect Sheet and enter the password if required. Also check whether the rows have a very small height using Home > Format > Row Height.
How do I start Excel in Safe Mode?
On Windows, close Excel, press Windows + R, type excel /safe, and select OK. Then open the workbook and test whether the rows remain visible after saving and reopening.
What should I do if the rows stay visible in Safe Mode?
An add-in may be involved. In Excel, go to File > Options > Add-ins, choose COM Add-ins from the Manage list, and select Go. Disable add-ins for testing, then re-enable them one at a time and repeat the test.




