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

  1. Ensure the current worksheet is not protected
  2. Click Allow Users to Edit Ranges in the Review tab
  3. Click the New button
  4. In the pop-up dialog, use the mouse to select the range you want to open for editing in the cell reference input box
  5. Set an independent range password for this range (can be different from the worksheet protection password)
  6. Click OK

image

Setting Permissions for Multiple Ranges

  1. Repeat the steps above to create a new entry for each range that requires independent permissions
  2. Set different passwords for each range
  3. After all settings are complete, click Protect Sheet in the pop-up window
  4. 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"