How to Protect an Excel Worksheet While Allowing Specific Cells to Be Edited
Question details
The user needs to protect an Excel workbook stored online but wants to allow specific input cells to remain editable by other collaborators.
- Product
- Excel / WPS Spreadsheet
- Device & OS
- not provided
- Scenario
- Collaborating on a shared spreadsheet where certain formulas or data must be locked, but designated areas require user input.
- Observed behavior
- The goal is to establish a partially protected worksheet where only selected cells are unlocked for editing without removing protection entirely.
Identify and note down exactly which cells or ranges need to be edited by your collaborators before applying any worksheet protection.
Unlock Specific Cells and Protect the Worksheet
By default, all cells are locked when you protect a worksheet. You must manually unlock the specific cells first, then apply sheet protection.
This method works in both Excel desktop applications and Excel for the web. Remember that locking or unlocking cells has no effect until you actually protect the worksheet.
Highlight the specific cells or ranges that you want other users to be able to edit.
Right-click the selected cells and choose 'Format Cells'. Go to the 'Protection' tab and uncheck the 'Locked' box, then click OK.
Navigate to the 'Review' tab on the top ribbon and click 'Protect Sheet' (or 'Manage Protection' in Excel for the web).
Enter a password if required. Ensure that 'Select unlocked cells' is permitted, configure any other permitted actions, and click OK to enforce the protection.
Easily Protect and Unprotect Cells with WPS Spreadsheet
WPS Office offers an intuitive and highly efficient way to manage worksheet protection. You can quickly unlock specific cells for collaboration while keeping sensitive data secure, all within a familiar interface.
- 1. Open your file in WPS Spreadsheet: Launch WPS Office and open the spreadsheet you wish to protect.
- 2. Unlock the target cells: Select the cells you want users to edit, right-click, select 'Format Cells', go to the 'Protection' tab, and uncheck 'Locked'.
- 3. Apply Worksheet Protection: Go to the 'Review' tab, click 'Protect Sheet', enter an optional password, and confirm your settings to lock the rest of the file.
Frequently Asked Questions
Why can I still edit all cells after turning on 'Protect Sheet'?
If you can still edit all cells, you may have unchecked the 'Locked' property for the entire worksheet by mistake, or you entered the protection password to temporarily disable it. Ensure only your specific input cells are unlocked.
Can I allow different users to edit different cells in the same worksheet?
Yes. In the desktop versions of spreadsheet software, you can use the 'Allow Users to Edit Ranges' feature found under the Review tab. This lets you assign different passwords for different cell ranges.
How do I remove the protection from a locked worksheet?
Navigate to the 'Review' tab and click 'Unprotect Sheet'. If the sheet was protected with a password, you will be prompted to enter it before the protection is removed.
Does cell protection work when I share the file online?
Yes, when you upload and share the file via OneDrive, SharePoint, or WPS Cloud, the sheet protection and unlocked cell rules remain active, ensuring users can only edit the designated fields.
