Feature Summary
Allow Edit Ranges is used to set independent editing permissions and passwords for different ranges, enabling refined collaborative editing control.
Feature Description
| Feature Dimension | Description |
|---|---|
| Membership Restriction | No membership restriction |
| Version Restriction | No version restriction |
Steps
Creating a New Allow Edit Range
Feature Entry
"Review" tab → "Allow Edit Ranges" button → "New" button
- Ensure the current worksheet is not protected
- Click Allow Users to Edit Ranges in the Review tab
- Click the New button
- In the pop-up dialog, use the mouse to select the range you want to open for editing in the cell reference input box
- Set an independent range password for this range (can be different from the worksheet protection password)
- Click OK

Setting Permissions for Multiple Ranges
- Repeat the steps above to create a new entry for each range that requires independent permissions
- Set different passwords for each range
- After all settings are complete, click Protect Sheet in the pop-up window
- Set the overall worksheet protection password and confirm
FAQ
Q1: What is the difference between the Allow Edit Range password and the worksheet protection password?
- Solution: The range password only controls editing permissions for that specific range; knowing the password allows editing that range. The worksheet protection password is used to remove overall protection. The two are set independently.
Q2: How do I delete an Allow Edit Range that has already been set?
- Solution: First remove worksheet protection, then open the "Allow Users to Edit Ranges" window, select the unwanted range, and click "Delete".
Q3: What if a user does not know the range password?
- Solution: The range password is optional. If password control is not needed, you can create the range without setting a password, only controlling the scope of protection.
Notes
- Before setting this feature, ensure the worksheet is not protected
- This feature works best when used in conjunction with "Lock Cell" and "Protect Sheet"