Document Editing Problems

Fix Excel Protect Sheet Selecting Locked and Unlocked Cells Together

Bushra ParveenBushra Parveen Nov 2, 2026 868 views

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.

Fix Excel Protect Sheet Selecting Locked and 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.
Before you start

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.

Solution 1Recommended

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.

1
Create a New Workbook

Open Excel and click 'File' > 'New' > 'Blank workbook' to start a fresh file without any inherited settings.

2
Test Protect Sheet Feature

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.

3
Check Excel Version

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.

Troubleshoot Excel Version and File Integrity
Known Product Behavior: If the issue persists in a new workbook, it is likely a software defect or an updated product behavior in your specific Excel version rather than a broken spreadsheet file.
Free Microsoft Office alternative

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. 1. Open your file in WPS Spreadsheet: Launch WPS Office and open your existing Excel (.xlsx) file.
  2. 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. 3. Protect the Worksheet: Navigate to the 'Review' tab and click 'Protect Sheet'.
  4. 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.
Precise control over locked and unlocked cell selection during sheet protection.Fully compatible with Microsoft Excel (.xlsx, .xls) files.Familiar user interface makes transitioning effortless.Free to use and lightweight, avoiding heavy system resource usage.
microsoft office alternative - wps office

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.