This section answers common questions about WPS Area Permissions on Windows and explains key terms so you can understand protected ranges and collaboration permissions more quickly.
FAQ
Can the spreadsheet creator manage all area permissions?
- Yes.
- The spreadsheet creator and spreadsheet managers can manage all area permission settings in the spreadsheet.
- If you need to adjust permissions centrally, use the Protect Range panel on the right side.
How do I remove protection from one range?
- Open the Protect Range panel on the right side.
- Find the target range in the protected range list.
- Click Delete next to that range to remove its protection.
- If you want to remove all range protection, turn off the main Turn On Area Permissions switch.
Can one worksheet contain multiple protected ranges?
- Yes.
- One worksheet can include multiple protected ranges.
- The permissions for each range are set independently.
Is there a quick way to turn on area permissions?
- Select the cells or worksheet that you want to work with.
- Right-click to open the shortcut menu.
- Turn on area permissions from the right-click menu.
Glossary
| Term | Definition |
|---|---|
| Area Permissions | A feature that sets view or edit permissions for specific cell ranges in a collaborative spreadsheet. |
| Protected Range | A cell range or current worksheet that has permission controls applied. |
| Designated Persons Can View/Edit | A setting that assigns view or edit permissions to specific collaborators. |
| Current Worksheet | The worksheet currently being edited, which can be selected as the protection scope. |