How to Use WPS Protect Worksheet on iOS

Use Protect Worksheet with 2 how-to topics, including turning worksheet protection on and removing worksheet protection; choose a topic from the index and follow the entry path and steps to complete it.

How-to Index

How-to Guide

1. Turn On Protect Worksheet

Entry path:

• Path 1: Tools → Review → Protect Worksheet
• Path 2: Tap the worksheet name → Floating menu → Protect

1. Open WPS Spreadsheet and go to the workbook you want to protect.
2. Tap Tools at the bottom of the screen, then open the Review tab.
3. Tap Protect Worksheet.
4. Turn on Enable Protect.
5. Add a password if needed, then confirm it.
6. Tap Done.
7. Return to the editing page and check whether a lock icon appears before the worksheet name.

Success Criteria

• Interface result: A lock icon appears before the target worksheet name.
• What you can do next: The worksheet remains open and protected for viewing.
• No side effects: The workbook stays open and no other worksheet is switched automatically.

Tips While Using

• You can also tap the worksheet name to open the floating menu for a faster entry point.
• If you set a password, you will usually need it later to remove protection.
• Keep the password safely so you can manage the worksheet again when needed.

2. Remove Protect Worksheet

Entry path:

• Path 1: Tools → Review → Remove Protect Worksheet
• Path 2: Tap the worksheet name → Floating menu → Remove Protection

1. In the workbook, switch to the protected worksheet.
2. Tap Tools at the bottom of the screen, then open the Review tab.
3. Tap Remove Protect Worksheet.
4. If prompted, enter the password.
5. Return to the editing page and check whether the lock icon before the worksheet name has disappeared.

Success Criteria

• Interface result: The lock icon no longer appears before the target worksheet name.
• What you can do next: The worksheet becomes editable again.
• No side effects: Other worksheets that you did not change keep their current status.

Tips While Using

• You can also tap the worksheet name and choose Remove Protection from the floating menu.
• If a password was set earlier, you need the correct password to continue.
• After editing, you can turn protection on again to keep the worksheet stable.