When using Allow Edit Area, the most common questions focus on password differences, deleting ranges, and whether a range password is required; this FAQ includes 3 common questions and a glossary.
FAQ
What is the difference between a range password and a worksheet protection password?
- A range password controls editing access for one specific allow edit area.
- A worksheet protection password controls the protection status of the entire worksheet.
- These passwords can be set separately. A user who knows a range password can edit that range, but that does not mean the user can remove worksheet protection.
How do I delete an allow edit area that has already been created?
- Unprotect the current worksheet first.
- Open the Allow Users to Edit Ranges window.
- Select the target range and click Delete.
- If other areas still need restricted editing, protect the worksheet again afterward.
Do I have to set a range password when creating a new allow edit area?
- A range password can be set based on your actual needs.
- If you want clearer control for different worksheet sections, setting a separate password is helpful.
- If you only need to define editable areas, you can also manage the worksheet with worksheet protection.
Glossary
| Term | Definition |
|---|---|
| Allow Edit Area | A cell range that remains editable inside a protected worksheet. |
| Range password | A password set for one editable range to control editing access for that range. |
| Worksheet protection | A protection mechanism for the entire worksheet that limits unauthorized editing. |