Permission & Access Issues

How to Restrict Excel Users to Editing One Cell Range

Camila Milosovich Oct 9, 2026 868 views

Question details

The user wants to allow most users to edit all fields in a shared Excel workbook while restricting specific users to editing only one permitted cell range.

How to Restrict Excel Users to Editing a Single Cell Range

Product: Microsoft Excel
Device & OS: not provided
Scenario: Sharing an Excel workbook with a team where different users require different editing permissions for specific areas of the sheet.
Observed behavior: The user found that the 'Changes' tab does not provide range-specific editing control, and standard sheet protection settings appear insufficient or disabled without further configuration.

Before you start

Before setting up range-specific restrictions, ensure you have administrative or owner access to the workbook, and verify whether you will use password-based restrictions or Windows user accounts to authenticate the restricted users.

Solution 1Recommended

Use Allow Users to Edit Ranges with Sheet Protection

This is the standard and most effective method in Excel to assign specific editing permissions to different users or groups for strictly defined cell ranges.

To restrict certain users to specific areas, you must define the permitted ranges first and then protect the entire worksheet. The Changes tab is designed for tracking modifications, not for restricting access to specific cells.

Unprotect the Worksheet

Navigate to the Review tab on the ribbon. If the sheet is currently protected, click 'Unprotect Sheet' and enter the password if prompted.

Open the Allow Edit Ranges Dialog

On the Review tab, click on 'Allow Edit Ranges' (or 'Allow Users to Edit Ranges' depending on your Excel version) in the Protect group.

Define the Permitted Range

Click the 'New' button. Enter a Title for the range, click the 'Refers to cells' box to select the specific cell range the user is allowed to edit, and enter a Range Password.

Set Specific User Permissions (Optional)

Instead of using a password, you can click 'Permissions', click 'Add', and select specific Windows users from your directory who can edit this range without needing the password.

Protect the Sheet

Click OK to close the permissions window, then click the 'Protect Sheet' button at the bottom of the Allow Users to Edit Ranges dialog box. Set a master password for the sheet and click OK.

Use Allow Users to Edit Ranges with Sheet Protection

Shared Workbook Limitations: If you are using Excel's Legacy Shared Workbook feature, the 'Allow Users to Edit Ranges' option may be grayed out. You must temporarily unshare the workbook (Review > Share Workbook), configure your ranges and protection, and then re-share it.

Solution 2

Unlock Specific Cells and Protect the Rest of the Sheet

If you do not need strict user-by-user authentication and just want to restrict general users to a specific range, you can manually unlock those cells.

Secure and Share Your Spreadsheets Easily with WPS Office

WPS Office Spreadsheet provides robust and intuitive sheet protection features, allowing you to restrict editing to specific cell ranges just like Microsoft Excel. It offers a seamless way to manage cell permissions in shared environments while maintaining full compatibility with your existing files.

1. Open Your Spreadsheet in WPS Office: Launch WPS Spreadsheet and open the workbook you want to protect.
2. Navigate to the Review Tab: Click on the 'Review' tab located on the top ribbon.
3. Configure Edit Ranges: Click 'Allow Users to Edit Ranges', define the cells that specific users can modify, and assign passwords if necessary.
4. Protect the Sheet: Click 'Protect Sheet' from the same tab to lock the rest of the document and enforce your range restrictions.

Fully compatible with Microsoft Excel (.xlsx, .xls) files and their native protection formatting.Easily configure 'Allow Users to Edit Ranges' with an intuitive, user-friendly interface.Free, lightweight, and fast-loading spreadsheet alternative.Seamlessly manage workbook sharing and permission settings across different devices.

microsoft office alternative - wps office

Frequently Asked Questions

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

This button becomes inactive if the worksheet is already protected or if you are using an older 'Legacy Shared Workbook' mode. To fix this, unprotect the sheet first. If it is still grayed out, stop sharing the workbook temporarily, configure your ranges, and then re-share the file.

Can I assign different passwords to different cell ranges?

Yes. When you use the 'Allow Users to Edit Ranges' feature, you can click 'New' multiple times to create multiple distinct ranges. You can assign a unique password to each range, allowing you to give different passwords to different users based on what they are allowed to edit.

Does range restriction work when editing in a web browser?

Spreadsheet web applications generally respect the sheet protection and locked cells established in the desktop app. However, configuring advanced range-specific user permissions usually requires setting up the rules in the desktop application first before uploading or sharing the file online.

Document & File Issues