Permission & Access Issues

How to Protect Shared Excel Cells While Allowing Authors to Edit

Maira Mehtab Sep 22, 2026 869 views

Question details

The user needs to protect a shared Excel workbook so that only authorized authors can edit specific input cells, avoiding the need to constantly toggle worksheet protection.

Product: Excel
Device & OS: not provided
Scenario: Sharing an Excel workbook and restricting cell edits to specific authors for secure collaboration.
Observed behavior: Currently, the owner has to repeatedly turn worksheet protection off and on to allow edits, which is highly impractical.

Before you start

Before proceeding, determine exactly which cells need to be editable and identify the users or passwords you will use to grant access to these specific ranges.

Solution 1Recommended

Use Allow Edit Ranges and Protect Sheet

Configure specific cell ranges to be editable for authorized users before applying overall worksheet protection.

Excel provides a built-in feature called 'Allow Edit Ranges' that works in conjunction with 'Protect Sheet'. You can either assign permissions to specific domain users or set a separate password for the editable range, ensuring only authorized authors can make changes.

Access Allow Edit Ranges

Open your Excel workbook, navigate to the 'Review' tab on the ribbon, and click on 'Allow Edit Ranges' (or 'Allow Users to Edit Ranges').

Create a new editable range

Click the 'New' button in the dialog box. Give the range a title and select the specific cells you want to be editable in the 'Refers to' box.

Set passwords or permissions

If your computer is not on a domain, enter a specific 'Range password'. If you are on a domain network, click the 'Permissions' button to add specific users who can edit the range without a password.

Protect the worksheet

Click 'OK' to save the range. Finally, click the 'Protect Sheet' button in the same dialog box (or on the Review tab) to apply a master password that locks the rest of the worksheet.

Domain Requirement for Direct Permissions: Assigning specific users directly via the 'Permissions' button requires your computer to be connected to a Windows domain. If it is not, you must use the range password method to grant access.

WPS Spreadsheet Solution

Protect and Share Workbooks Easily with WPS Spreadsheet

WPS Office Spreadsheet provides full support for sheet protection and selective cell editing, making it easy to collaborate securely with your team without compromising data integrity.

1. Open your workbook: Launch WPS Spreadsheet and open the file you want to protect.
2. Set editable ranges: Navigate to the 'Review' tab and click on 'Allow Users to Edit Ranges'.
3. Add ranges and passwords: Click 'New' to add your desired cell ranges and set an access password for the authors.
4. Apply sheet protection: Click 'Protect Sheet' to lock the rest of the workbook against unauthorized changes.

Easily lock specific cells while allowing authorized users to editFully compatible with Microsoft Excel (.xlsx) file formatsLightweight, fast, and highly intuitive interfaceFamiliar ribbon layout for seamless migration from other Office suites

microsoft office alternative - wps office

Frequently Asked Questions

Can I assign different passwords for different cell ranges?

Yes, when setting up 'Allow Edit Ranges', you can create multiple ranges and assign a unique password to each one. This allows you to give different authors access to entirely different parts of the same worksheet.

What happens if a user forgets the range password?

If a user forgets the range password, the worksheet owner can simply unprotect the entire sheet using the master sheet password, and then modify or remove the forgotten range password from the 'Allow Edit Ranges' menu.

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

The 'Permissions' button is only available if your computer is connected to a Windows domain network (commonly used in corporate environments). If you are on a personal computer or a non-domain network, this button will be inactive, and you must use the password method to restrict access.

Document & File Issues