'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Cannot Edit Unlocked Cells in Protected Excel Sheets on Android
Question details
Users are unable to modify specific unlocked cells within a protected spreadsheet when using the Excel mobile app on Android.
- Product
- Microsoft Excel
- Device & OS
- Android
- Scenario
- Attempting to input data or modify designated unlocked cells in a protected worksheet via an Android mobile device.
- Observed behavior
- The Excel Android app displays a view-only or protected sheet error and prevents editing, even though the same file functions perfectly on iOS, Windows, and macOS.
Verify that the cells you are trying to edit are properly marked as 'unlocked' using a desktop version of Excel before transferring the file to your Android device.
Verify Protection Settings and Update the Excel App
Ensure your file permissions are configured correctly and your mobile app is updated, as platform-specific bugs are often patched in newer releases.
Because this issue frequently isolates to the Android environment, it is often tied to an outdated app version or a temporary rendering bug with cell protection logic.
Open the Google Play Store on your Android device, search for 'Microsoft Excel', and tap 'Update' if a new version is available.
Open the file on a PC or Mac. Select the cells meant to be editable, right-click, and choose 'Format Cells'. Under the 'Protection' tab, confirm the 'Locked' box is unchecked.
Go to the 'Review' tab, re-protect the sheet ensuring 'Select unlocked cells' is permitted, save the file, and re-open it on your Android device.
Submit Feedback or Open a Support Ticket
If the problem affects multiple Android devices despite correct settings, it is likely a known limitation or bug requiring Microsoft's intervention.
Edit Protected Spreadsheets Seamlessly with WPS Office
Frustrated by Android-specific bugs in Microsoft Excel? WPS Office offers a free, lightweight, and highly compatible alternative. Effortlessly open your protected sheets and edit unlocked cells on your mobile device without unexpected view-only restrictions.
- 1. Install the app: Download and install WPS Office from the Google Play Store.
- 2. Open your file: Launch the WPS Office app, tap on 'Files', and locate your protected Excel spreadsheet.
- 3. Edit with ease: Tap the file to open it. You can immediately tap and edit the unlocked cells without encountering the view-only error.
Frequently Asked Questions
Why does my Excel file say 'read-only' on Android when it works on my PC?
This usually occurs due to version-specific bugs in the Android app, unsupported macro features, or file permission restrictions. Updating the app or using a highly compatible alternative like WPS Office can resolve this.
How do I unlock specific cells in an Excel spreadsheet?
On a desktop, highlight the cells you want to make editable, right-click and select 'Format Cells'. Navigate to the 'Protection' tab, uncheck 'Locked', click OK, and then protect the sheet via the 'Review' tab.
Can I remove sheet protection directly on my Android device?
The Microsoft Excel app for Android has limited capabilities for managing sheet protection. It is recommended to unprotect or modify these settings using a desktop application.
