Allow Specific Users to Edit a Protected Excel Worksheet
Question details
The user wants certain people to edit designated content in a password-protected Excel worksheet while restricting other changes.
- Product
- Microsoft Excel worksheet protection
- Device & OS
- not provided
- Scenario
- A workbook owner needs to limit edits to selected cells, ranges, or authorized collaborators.
- Observed behavior
- Standard worksheet protection uses one password and does not create true user-specific editing exceptions; anyone with that password can generally unprotect the sheet.
Decide which cells or ranges collaborators should be able to change before protecting the sheet. If access must be tied to individual identities, store the workbook in a shared service that supports collaborator permissions rather than relying only on a worksheet password.
Unlock the cells that collaborators are allowed to edit before protecting the sheet
Use this method when multiple users can edit the same designated cells or input areas without needing the worksheet password.
Excel locks cells by default only after worksheet protection is enabled. Removing the Locked setting from selected input cells lets users edit those cells while the rest of the worksheet remains protected.
In Excel, select the cells or ranges that users should be allowed to change.
Right-click the selected cells, choose Format Cells, open the Protection tab, clear Locked, and select OK.
Open the Review tab, select Protect Sheet, choose the actions users may perform, enter a password if needed, and select OK.
Create password-controlled editable ranges with Allow Edit Ranges
Use this option when different groups need separate passwords for different protected ranges and your Excel edition supports the feature.
Use file sharing permissions for true user-specific workbook access
Use this method for sensitive workbooks or when you must control which named collaborators can edit the file.
Set Editable Ranges and Share Spreadsheet Access with WPS Office
WPS Spreadsheets lets you prepare input cells, protect the rest of a worksheet, and share the workbook with collaborators. Use cell protection for controlled data entry and cloud sharing permissions when access must be managed by person.
- 1. Select the cells users can edit: Open the workbook in WPS Spreadsheets and select the input cells or ranges that should remain editable.
- 2. Unlock the selected cells: Right-click the selected range, choose Format Cells, open Protection, clear the Locked option, and confirm the setting.
- 3. Protect the worksheet: Go to the Review tab, select Protect Sheet, choose permitted actions, enter a password if required, and confirm.
- 4. Share with collaborators when identity-based access is needed: Select Share in WPS Office, invite the intended collaborators, and assign viewing or editing permission for the shared workbook.
Frequently Asked Questions
Can I give each Excel user a different password to edit the whole protected worksheet?
Not through standard worksheet protection. A sheet password applies to the worksheet itself. You can use Review > Allow Edit Ranges for separate range passwords, or use OneDrive, SharePoint, or Microsoft 365 sharing permissions for named-user access.
Why can users still edit some cells after I protect an Excel worksheet?
Those cells are probably unlocked. Select the cells, open Format Cells > Protection, select Locked, and then apply Review > Protect Sheet again.
Does Protect Sheet provide strong security for confidential Excel data?
No. Worksheet protection is mainly designed to prevent accidental editing. For confidential data, use File > Info > Protect Workbook > Encrypt with Password and control file access through approved sharing permissions.
How do I allow data entry but protect formulas in Excel?
Select the data-entry cells and clear Format Cells > Protection > Locked. Leave formula cells locked, then use Review > Protect Sheet to protect the worksheet.
Can I prevent someone from editing an Excel workbook without making it password-protected?
Yes. Save the workbook to OneDrive or SharePoint, select Share, and give non-editors Can view permission. They can open the file but cannot edit it unless you later grant edit access.
