Office Compatibility Issues

Fix Hidden Rows Showing in a Protected Excel File on iOS

Emma BrownEmma Brown Nov 18, 2026 868 views

Question details

The user wants hidden rows and columns in a protected Excel workbook to remain hidden when opened on an iPhone.

Fix Hidden Rows Showing in a Protected Excel File on iOS
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the workbook on a desktop

Open the file in a current desktop version of Excel and select the worksheet where the rows or columns should be hidden.

2
Check the hidden content

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.

3
Review protection settings

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.

4
Save and reopen on the iPhone

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.

Resave and test the protected workbook in current Excel versions
If the content still appears: The iPhone may not support a newer Excel version, or the mobile app may handle the workbook differently. Test the file on a newer device or use desktop Excel when consistent display is essential.
Free Microsoft Office alternative

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.

Open and review spreadsheets with hidden rows and columnsCompatible with Microsoft Excel formats, including XLS and XLSXFamiliar spreadsheet interface for an easier transition from ExcelFree and lightweight office suite
microsoft office alternative - wps office

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.