When using WPS Allow Edit Area, common questions usually focus on password differences, deletion steps, and protected-sheet behavior; this FAQ covers 3 frequent questions and a short glossary.
FAQ
What is the difference between a range password and a worksheet protection password?
- A range password controls editing permission for a specific editable range only.
- A worksheet protection password is used to remove protection from the whole worksheet.
- These two passwords can be set separately and can be different.
How do I delete an editable range that has already been set?
- If the worksheet is protected, unprotect it first.
- Open Allow Users to Edit Ranges from the Review tab.
- Select the target range and click Delete.
Can I create a new editable range after the worksheet is already protected?
- Not directly.
- Unprotect the current worksheet first.
- Then open Allow Users to Edit Ranges and create the new range.
Glossary
| Term | Definition |
|---|---|
| Allow Edit Area | A selected cell range that remains editable inside a protected worksheet. |
| Range password | A separate password assigned to one editable range. |
| Worksheet protection | A protection state that restricts editing actions across the worksheet. |