How to Fix Excel Online Allowing Selection of Locked Cells
Question details
Users need to prevent the selection of locked cells in a protected worksheet, but Excel for the web fails to enforce this restriction.
- Product
- Excel Online
- Device & OS
- not provided
- Scenario
- Applying worksheet protection to restrict users from clicking or selecting locked cells while allowing edits in specific ranges.
- Observed behavior
- Excel Online ignores the restriction and allows users to select locked cells, especially when 'Allow Edit Ranges' is configured, unlike the desktop version.
Before troubleshooting, verify whether you are viewing the spreadsheet in Excel for the web or the desktop application, as their worksheet protection mechanisms behave differently.
Open the Spreadsheet in the Desktop Application
Since Excel for the web has limitations with layered protection, opening the file in a desktop application ensures exact locked-cell selection restrictions are enforced.
Excel for the web does not currently guarantee the same layered protection behavior as desktop Excel. Specifically, 'Allow Edit Ranges' takes precedence over the setting that prevents users from selecting locked cells online.
In Excel Online, look at the top ribbon menu and find the 'Viewing' or 'Editing' dropdown button.
Click on 'Open in Desktop App' from the dropdown list to launch the full desktop version of Excel.
Once the file opens in the desktop app, go to the 'Review' tab, click 'Protect Sheet', and ensure the 'Select locked cells' option remains unchecked.
Submit a Support Request or Feedback to Microsoft
If you require strict protection behavior natively in the web version, reporting it to Microsoft can help prioritize a future fix.
Use WPS Office for Reliable Worksheet Protection
Since Excel for the web struggles with complex worksheet protection layers, switching to WPS Office provides a lightweight, free, and robust desktop alternative. WPS Spreadsheet accurately enforces your locked-cell selection rules while remaining fully compatible with Microsoft formats.
- 1. Open your file in WPS Spreadsheet: Launch WPS Office and open your existing .xlsx spreadsheet.
- 2. Access protection settings: Navigate to the 'Review' tab in the top ribbon and click on 'Protect Sheet'.
- 3. Enforce strict locking: Uncheck the box for 'Select locked cells', enter a secure password, and click 'OK'. The restrictions will apply perfectly.
Frequently Asked Questions
Why can users still select locked cells in Excel Online?
Excel for the web processes protection settings differently than the desktop version. If you have 'Allow Edit Ranges' configured, it takes priority and overrides the restriction that normally prevents users from selecting locked cells.
Will Excel for the web eventually support exact layered protection?
Microsoft has not guaranteed exact feature parity for layered worksheet protection in Excel Online yet. Users experiencing this issue are encouraged to submit feedback directly through the Microsoft Feedback Portal.
How do I completely prevent locked cell selection for my team?
To guarantee that locked cells cannot be selected, require your team to open and interact with the protected workbook using a desktop application like Microsoft Excel Desktop or WPS Office, which strictly enforce all layered protection settings.
