Fix Hidden Rows Showing in a Protected Excel File on iOS
Question details
The user wants hidden rows and columns in a protected Excel workbook to remain hidden when opened on an iPhone.

- Product
- Microsoft Excel for iOS
- Device & OS
- Older iPhone running iOS; desktop OS not provided
- Scenario
- A workbook with hidden rows and columns is protected on a desktop and then opened in Excel on an older iPhone.
- Observed behavior
- Rows or columns hidden on the desktop may appear in the iOS version of Excel.
Make sure you have the worksheet protection password if one was set, and check which version of Excel is installed on the iPhone. If possible, update Excel through the App Store before testing the workbook.
Resave and test the protected workbook in current Excel versions
Use this approach to check whether an older workbook or iOS app is causing the display difference.
Older Excel for iOS versions may handle hidden content and protection differently from desktop Excel. Resaving and updating can help, but they do not guarantee identical behavior on every device.
Open the file in a current desktop version of Excel and select the worksheet where the rows or columns should be hidden.
Inspect the row numbers and column letters. If content that should be hidden is visible, select the relevant row or column headings, right-click, and choose Hide.
Open the Review tab and check worksheet protection. If you need to change it, select Unprotect Sheet, enter the password if prompted, and then use Protect Sheet to set the desired permissions. Check Protect Workbook separately if workbook structure protection is needed.
Select File > Save As to save a copy, then open that copy in Excel on the iPhone. Check both the hidden rows and columns and the protection behavior.

Protect sensitive workbook data with encryption or restricted access
Use this approach when hidden rows or columns contain information that other people must not access.
Review Excel Workbooks with WPS Office
WPS Office is a free, lightweight Office alternative with a familiar interface and support for Excel formats, making it easier to open existing spreadsheets and move between office suites. Test your workbook's hidden rows and protection behavior before relying on it across apps.

Frequently Asked Questions
Why are hidden rows visible in Excel on my iPhone?
An older Excel for iOS version may handle hidden content or workbook protection differently from desktop Excel. Update Excel through the App Store if possible, then test a freshly saved copy of the workbook.
Does protecting a worksheet keep hidden data private?
No. Worksheet protection and hidden rows are not reliable security measures. Use file encryption or restrict access through the workbook's OneDrive or SharePoint sharing settings for sensitive data.
How can I check whether the sheet is protected?
Open the workbook in desktop Excel and select the Review tab. Look for Protect Sheet or Unprotect Sheet; you may need the password to change existing protection.
What if my older iPhone cannot update Excel?
Test the workbook on a newer supported device or in desktop Excel. If the hidden data is sensitive, remove it from the shared copy or use encryption and restricted access rather than relying on the hidden setting.




