Permission & Access Issues

Fix Excel Allow Users to Edit Ranges When Everyone Can Edit a Range

Jason MillerJason Miller Nov 13, 2026 869 views

Question details

Restrict an Excel editable range that can currently be changed by everyone.

Fix an Excel Editable Range That Everyone Can Change
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.
Before you start

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.

Solution 1Recommended

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.

1
Unprotect the worksheet

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.

2
Inspect the affected range

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.

3
Compare permissions

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.

4
Set the intended restriction

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.

5
Protect and test the sheet

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.

Compare the editable range settings and protect the worksheet
Passwords and permissions: A range without a password or restrictive permissions may be editable by anyone when the worksheet is protected. User permissions depend on the Excel version and environment.
Free Microsoft Office alternative

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.

Protect worksheets and manage spreadsheet editing in WPS SpreadsheetsOpen and save Microsoft Excel formats, including XLSXUse a familiar interface for everyday spreadsheet workMove existing spreadsheet files into a lightweight office suite
microsoft office alternative - wps office

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.