WPS Features
Resources
Free AI Tools
Docs Center

How to Use WPS Allow Edit Area on macOS

Last updated:July 16, 2026

Use Allow Edit Area with 4 how-to topics, including 4 free topics and 0 membership-related topics; choose a topic from the index and follow the steps to complete the setup.

How-to Index

No.TopicMembership Requirement
11. Create a new allow edit areaFree
22. Set different permissions for multiple rangesFree
33. Protect the worksheet while keeping editable rangesFree
44. Delete an existing allow edit areaFree

How-to Guide

1. Create a new allow edit area

Feature entry: Review → Allow Users to Edit Ranges → New

  1. Make sure the current worksheet is not protected.
  2. Click Allow Users to Edit Ranges on the Review tab.
  3. Click New.
  4. In the dialog box, select the cell range that should remain editable.
  5. Set a separate range password for that area. This password can be different from the worksheet protection password.
  6. Click OK to finish creating the range.

Success Criteria

  • Interface result: The new range appears in the allow edit area list.
  • Next action available: You can continue adding more ranges or move on to worksheet protection.

Tips While Using

  • Common mistake: If the worksheet is already protected, unprotect it before creating a new range.
  • Environment note: This feature is used inside a worksheet in WPS Spreadsheets.

2. Set different permissions for multiple ranges

Feature entry: Review → Allow Users to Edit Ranges → New

  1. Repeat the new-range process for each section that should stay editable.
  2. Assign a different range password to each editable area as needed.
  3. Check the range names, cell references, and passwords to make sure they match the actual editing plan.
  4. Keep the settings window open and prepare to protect the worksheet.

Success Criteria

  • Interface result: Multiple editable ranges appear in the list.
  • Next action available: You can continue directly to Protect Sheet.

Tips While Using

  • Common mistake: If two ranges overlap, review the section design before saving.
  • Environment note: Planning the editable sections in advance helps reduce later changes.

3. Protect the worksheet while keeping editable ranges

Feature entry: Allow Users to Edit Ranges window → Protect Sheet

  1. After all editable ranges are configured, click Protect Sheet in the dialog.
  2. Set and confirm the worksheet protection password.
  3. After protection is enabled, test whether the selected ranges are still editable.
  4. Confirm that the other areas remain protected.

Success Criteria

  • Interface result: The worksheet enters protected status.
  • Next action available: Users who know the range password can edit the corresponding area, while other areas remain protected.

Tips While Using

  • Common mistake: If you set only a range password but do not protect the worksheet, the section-based control will not fully take effect.
  • Environment note: Keep the range passwords and worksheet protection password recorded separately for later maintenance.

4. Delete an existing allow edit area

Feature entry: Review → Allow Users to Edit Ranges

  1. If the worksheet is protected, unprotect it first.
  2. Open the Allow Users to Edit Ranges window.
  3. Select the range you no longer need.
  4. Click Delete and confirm the action.

Success Criteria

  • Interface result: The deleted range no longer appears in the list.
  • Next action available: You can create a new range again or protect the worksheet again.

Tips While Using

  • Common mistake: If you do not unprotect the worksheet first, you may not be able to change existing ranges.
  • Environment note: After deleting a range, review the overall protection settings if you still need controlled editing.