Permission & Access Issues

How to Allow Editing in Selected Cells in a Protected Excel Worksheet

Nimra Malik Sep 28, 2026 868 views

Question details

The user needs to protect a shared worksheet from unauthorized changes while granting specific users the ability to edit predefined cell ranges.

How to Allow Editing in Selected Cells in a Protected Excel Worksheet

Product: Excel
Device & OS: not provided
Scenario: Sharing an Excel file with multiple collaborators where overall layout and data must be protected, but certain data entry fields need to remain editable.
Observed behavior: When the worksheet is protected, all cells become uneditable by default. The user requires a method to bypass this restriction for specific cell ranges without disabling the main sheet protection.

Before you start

Before proceeding, unprotect your worksheet if it is already protected, and determine exactly which cells need to remain editable for your collaborators.

Solution 1Recommended

Use the Allow Edit Ranges Feature

This method lets you define specific ranges that can be edited by entering a password or by granting domain-based permissions, while keeping the rest of the sheet locked.

By utilizing the 'Allow Edit Ranges' feature, you can assign different passwords to different sections of your worksheet. This is ideal when multiple teams need access to different parts of the same document.

Open Allow Edit Ranges

Navigate to the 'Review' tab on the Excel ribbon and click on 'Allow Edit Ranges'.

Create a New Range

In the dialog box, click 'New'. Enter a title for your range, select the specific cells in the 'Refers to cells' box, and type a 'Range password'.

Set Domain Permissions (Optional)

If your computer is connected to a Windows domain, you can click 'Permissions' to add specific users or groups who can edit the range without a password.

Protect the Worksheet

Click 'OK', confirm your range password, and then click 'Protect Sheet' at the bottom of the dialog box. Set a master password for the worksheet to enforce the protection.

Domain Connection Required: Domain-based permissions are only available if your computer is actively connected to a corporate domain. Otherwise, you must rely on the range password.

Solution 2

Unlock Specific Cells Before Protecting

A simpler alternative if you want specific cells to be editable by anyone, without requiring a range-specific password.

Secure Your Spreadsheets with WPS Office

Manage Worksheet Permissions Easily in WPS Spreadsheets

WPS Spreadsheets offers robust protection features that let you securely lock entire documents while maintaining specific editable cells. It is completely compatible with Excel's protection protocols, ensuring smooth collaboration.

1. Open your Document: Launch WPS Spreadsheets and open the workbook you want to protect.
2. Access Protection Tools: Navigate to the 'Review' tab on the top ribbon and locate the 'Allow Users to Edit Ranges' option.
3. Define Editable Areas: Click 'New' to select the cell range and assign a dedicated range password for authorized editors.
4. Enforce Protection: Click the 'Protect Sheet' button within the same dialog, set your master password, and save the file.

Easily lock or unlock specific cell ranges with a highly intuitive user interface.Fully compatible with Microsoft Excel (.xlsx) file formats, preserving all password and protection settings.Lightweight, fast, and completely free to download.

Frequently Asked Questions

Why is the 'Allow Edit Ranges' button grayed out?

This feature becomes inactive if the worksheet is already protected. You must unprotect the sheet first by navigating to the Review tab and clicking 'Unprotect Sheet' before you can configure new edit ranges.

Can I allow editing without setting a range password?

Yes. If you simply want anyone to edit specific cells while the rest of the sheet is protected, you can select those cells, right-click and choose Format Cells > Protection, and uncheck 'Locked' before applying the final sheet protection.

Will these range passwords work if the file is shared with non-Excel users?

Range passwords and sheet protection work perfectly across compatible software like WPS Spreadsheets. However, web-based tools like Google Sheets handle permissions differently and may not fully recognize Excel's range-specific passwords upon import.

Document & File Issues