Allow Users to Edit Selected Cells in Excel
Question details
Allow users to edit selected cells while preventing changes to the rest of an Excel worksheet.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A worksheet has designated input cells that users should be able to change.
- Observed behavior
- Users can edit the approved cells while other cells remain protected.
Identify the cells users should edit and check that the remaining cells have the Locked setting enabled. If the sheet is already protected, use Review > Unprotect Sheet before changing cell protection settings.
Unlock Input Cells and Protect the Excel Worksheet
Use this method to leave selected cells editable while protecting the rest of the worksheet.
Select the cells or ranges users should be allowed to edit. Hold Ctrl while selecting separate ranges if needed.
Right-click the selection, choose Format Cells, and open the Protection tab. Clear the Locked checkbox and select OK.
Go to Review > Protect Sheet. Set a password if required, choose the actions users may perform, and confirm the protection settings.
Try entering a value in an unlocked cell, then try editing a cell that should remain locked. The first edit should work and the second should be blocked.

Protect a Worksheet While Leaving Input Cells Editable in WPS
In WPS Spreadsheet, unlock the intended input cells and then protect the worksheet to limit changes elsewhere.
- 1. Open the workbook: Open WPS Spreadsheet and use Open to select your Excel workbook.
- 2. Select editable cells: Select the cells users should be able to change, then right-click and choose Format Cells.
- 3. Remove the locked setting: In Format Cells, open the Protection tab, clear Locked, and select OK.
- 4. Protect and test the sheet: Go to Review > Protect Sheet, choose the permitted actions and a password if needed, then test an unlocked cell and a locked cell.

Frequently Asked Questions
Why can users still edit cells after I mark them as locked?
The Locked setting takes effect only when the worksheet is protected. Go to Review > Protect Sheet to apply it.
How do I change which cells are editable later?
Go to Review > Unprotect Sheet and enter the password if prompted. Change the Locked setting under Format Cells > Protection, then protect the sheet again.
Can I leave several separate ranges editable?
Yes. Select each range and clear Locked under Format Cells > Protection before using Review > Protect Sheet.
Does protecting a worksheet prevent someone from opening the file?
No. Worksheet protection limits editing within a sheet. Use the workbook's file encryption options if you need to require a password to open it.




