Fix Excel Protect Sheet Selecting Locked and Unlocked Cells Together
Question details
The user is trying to restrict cell selection using the Protect Sheet feature, but Excel automatically selects both 'Select locked cells' and 'Select unlocked cells' together.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Protecting a worksheet to restrict users from clicking or editing specific locked cells.
- Observed behavior
- When checking 'Select locked cells' in the Protect Sheet dialog, the 'Select unlocked cells' option is automatically selected alongside it across multiple files and versions.
Ensure your Office suite is updated to the latest version, as this specific Protect Sheet behavior may be tied to a known bug in certain Excel builds.
Troubleshoot Excel Version and File Integrity
Verify if the issue is a file-specific corruption or a broader Excel version defect by testing on a fresh workbook.
In some instances, unexpected selection behavior in the Protect Sheet menu is tied to a specific build of Microsoft Excel rather than user error. Testing a blank document helps isolate the root cause.
Open Excel and click 'File' > 'New' > 'Blank workbook' to start a fresh file without any inherited settings.
Go to the 'Review' tab on the ribbon, click 'Protect Sheet', and try toggling the 'Select locked cells' checkbox to see if 'Select unlocked cells' is also forced.
Navigate to 'File' > 'Account' and note your exact version and build number under 'About Excel'. This information is necessary if the bug persists and requires escalation.

Contact Microsoft Support with Evidence
Since this might be a confirmed defect in the current version, reaching out to official support with a reproduction video is the next best step.
Try WPS Office for Reliable Worksheet Protection
If Microsoft Excel's Protect Sheet feature is malfunctioning due to version bugs, consider switching to WPS Office. WPS Spreadsheet offers precise, bug-free control over cell locking and protection, ensuring your sensitive data remains secure. It is a free, lightweight alternative that fully supports Microsoft Office document formats.
- 1. Open your file in WPS Spreadsheet: Launch WPS Office and open your existing Excel (.xlsx) file.
- 2. Lock or Unlock Cells: Select the cells you want to be editable, right-click, choose 'Format Cells', go to the 'Protection' tab, and uncheck 'Locked'.
- 3. Protect the Worksheet: Navigate to the 'Review' tab and click 'Protect Sheet'.
- 4. Set Permissions: Check only the specific permissions you want to grant (e.g., 'Select unlocked cells') and enter a password to enforce the protection without unexpected bug behavior.

Frequently Asked Questions
Why does Excel force 'Select unlocked cells' when I choose 'Select locked cells'?
This is often due to a known bug or specific design behavior in certain versions of Microsoft Excel. Testing it in a brand-new workbook can help confirm if it is a version-wide defect.
How can I prevent users from clicking on locked cells?
In a fully functioning version, you would go to the 'Review' tab, click 'Protect Sheet', uncheck 'Select locked cells', and only leave 'Select unlocked cells' checked. If your version is bugged, you may need to wait for a Microsoft update or use an alternative software like WPS Spreadsheet.
Will this issue affect my existing locked cells' security?
No, as long as the sheet is protected with a password, users still cannot edit the locked cells. The bug merely affects whether they can click on or highlight those cells, not whether they can modify the data.




