Permission & Access Issues

Allow Users to Edit Multiple Ranges in a Protected Excel Sheet

Steve KSteve K Nov 18, 2026 869 views

Question details

Users need access to two editable ranges in a protected Excel worksheet.

Allow Users to Edit Multiple Ranges in a Protected Excel Sheet
Product
Microsoft Excel
Device & OS
not provided
Scenario
A protected worksheet has two designated editable ranges, including cells below a separate header or section.
Observed behavior
Users can access the first range but cannot access cells in the second range, even though the range definitions and permissions appear correct.
Before you start

Open the workbook in desktop Excel and identify the cells that should be included in each editable range. Have the worksheet protection password and any range passwords available if they were set.

Solution 1Recommended

Enable Selection of Locked Cells and Check Both Editable Ranges

Use this solution when users can edit the first range but cannot navigate to or edit the second range.

1
Unprotect the worksheet

Open the affected sheet and select Review > Unprotect Sheet. Enter the worksheet password if prompted.

2
Check the range definitions

Select Review > Allow Edit Ranges, also called Allow Users to Edit Ranges in some versions. Select each range and choose Modify to confirm that its cell references include all intended cells.

3
Verify access to each range

In the Allow Edit Ranges dialog, check the password or permissions assigned to each range. Make sure affected users have the required permission or know the range password.

4
Restore protection with selection enabled

Select Review > Protect Sheet and enable Select locked cells. Leave Select unlocked cells enabled if users also need to navigate to unlocked cells, then apply protection.

5
Test both ranges

Navigate to each editable range and try editing its cells using an affected user's account or the applicable range password.

Enable Selection of Locked Cells and Check Both Editable Ranges
Selection is not edit permission: Select locked cells allows users to navigate to locked cells; it does not by itself grant permission to edit them. The range definition and its access settings must also allow editing.
Free Microsoft Office alternative

Work With Protected Spreadsheets in WPS Office

WPS Office is a free, lightweight Office alternative with a familiar spreadsheet interface and support for Excel files, making it easy to move everyday spreadsheet work. Use Excel to troubleshoot its specific editable-range permissions.

Open and edit spreadsheets in a familiar interfaceCompatible with Microsoft Excel XLS and XLSX formatsUse spreadsheet protection features for everyday worksheet workFree and lightweight for everyday Office tasks
microsoft office alternative - wps office

Frequently Asked Questions

Why can users select a cell but still not edit it?

Selecting a locked cell does not grant edit access. In Review > Allow Edit Ranges, check that the cell is included in an editable range and that the user has the required permission or range password.

Where can I check the cells included in an editable range?

Unprotect the sheet with Review > Unprotect Sheet, then open Review > Allow Edit Ranges. Select the range and choose Modify to inspect its cell references.

What should I do if the second range stopped working after workbook changes?

Recheck the range references and permissions under Review > Allow Edit Ranges, then restore protection with Select locked cells enabled. If the issue persists, reproduce the setup in a new workbook and compare the results.

Do users need the worksheet protection password to edit an allowed range?

Not necessarily. Users may edit an allowed range using its assigned permission or range password. The worksheet protection password is generally needed to unprotect the sheet and change its protection settings.