Fix Excel Allow Users to Edit Ranges When Everyone Can Edit a Range
Question details
Restrict an Excel editable range that can currently be changed by everyone.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A worksheet has multiple editable ranges with different intended access restrictions.
- Observed behavior
- Everyone can change one editable range, while the other protected ranges work as expected.
Identify the affected cell range and a working range to compare. Have the worksheet protection password and any range password available if they were set.
Compare the editable range settings and protect the worksheet
Use this method to check whether the affected range is missing a password or has broader permissions than a working range.
On the Review tab, select Unprotect Sheet and enter the worksheet password if prompted. If the sheet is already unprotected, continue to the next step.
Select Review > Allow Edit Ranges, also called Allow Users to Edit Ranges in some versions. Select the affected range and choose Modify to check its cell references and whether a range password is configured.
In the range settings, open Permissions if available and compare the listed users or groups with a working range. Remove unintended access or add the intended users as appropriate.
Use Modify to set or change the range password if password-based access is needed. Check the other range entries for overlapping cell references that could also permit edits.
Select Review > Protect Sheet, choose the allowed actions, and set a worksheet password if appropriate. Test the affected cells with an authorized and an unauthorized user, or with and without the range password.

Check whether the affected cells are unlocked
Use this check if the range settings look correct but the cells remain editable.
Protect and Edit Spreadsheets With WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Excel files, making it easy to move everyday spreadsheet work between suites. It does not repair Microsoft Excel's range-permission settings.

Frequently Asked Questions
Why can everyone edit a range on my protected sheet?
The range may have no password or restrictive permissions, or its cells may be unlocked. Check Review > Allow Edit Ranges and Format Cells > Protection.
Do editable range settings work without protecting the worksheet?
Range restrictions apply when the worksheet is protected. After configuring the ranges, select Review > Protect Sheet and test the cells.
How can I compare a working range with the affected one?
Unprotect the sheet, open Review > Allow Edit Ranges, and inspect each range's cell references, password, and Permissions settings where available.
What if two editable ranges overlap?
Check the cell references in Review > Allow Edit Ranges. An overlapping range may provide another way to edit the same cells, so adjust the references or restrictions and test again.




