Allow Users to Edit Multiple Ranges in a Protected Excel Sheet
Question details
Users need access to two editable ranges in a protected Excel worksheet.

- 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.
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.
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.
Open the affected sheet and select Review > Unprotect Sheet. Enter the worksheet password if prompted.
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.
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.
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.
Navigate to each editable range and try editing its cells using an affected user's account or the applicable range password.

Test Editable Ranges in a New Excel Workbook
Use a new workbook to check whether the access issue is specific to the original file, especially if it returned after workbook changes.
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.

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.




