Permission & Access Issues

Allow Users to Edit Selected Cells in Excel

Camila MilosovichCamila Milosovich Nov 18, 2026 868 views

Question details

Allow users to edit selected cells while preventing changes to the rest of an Excel worksheet.

Allow Users to Edit Selected Cells in Excel
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.
Before you start

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.

Solution 1Recommended

Unlock Input Cells and Protect the Excel Worksheet

Use this method to leave selected cells editable while protecting the rest of the worksheet.

1
Select the input cells

Select the cells or ranges users should be allowed to edit. Hold Ctrl while selecting separate ranges if needed.

2
Unlock the selected cells

Right-click the selection, choose Format Cells, and open the Protection tab. Clear the Locked checkbox and select OK.

3
Protect the sheet

Go to Review > Protect Sheet. Set a password if required, choose the actions users may perform, and confirm the protection settings.

4
Test the restrictions

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.

Unlock Input Cells and Protect the Excel Worksheet
Worksheet protection is not file security: Worksheet protection controls editing within the sheet; it does not provide full file-level security. Use file encryption when you need to restrict who can open the workbook.
Edit approved cells in WPS

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. 1. Open the workbook: Open WPS Spreadsheet and use Open to select your Excel workbook.
  2. 2. Select editable cells: Select the cells users should be able to change, then right-click and choose Format Cells.
  3. 3. Remove the locked setting: In Format Cells, open the Protection tab, clear Locked, and select OK.
  4. 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.
Keep designated input cells editable on a protected sheetOpen and save Microsoft Excel XLSX and XLS filesUse familiar spreadsheet formatting and review controlsWork with spreadsheets using a free office suite
microsoft office alternative - wps office

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.