When using WPS Lock Cells, common questions usually involve protection not taking effect, password handling, and editable range settings; this FAQ covers 3 frequent questions.
FAQ
Why can other people still edit cells after I locked them?
- Check whether you only set the Lock attribute without turning on Protect Worksheet.
- Go back to Tools → Review → Protect Worksheet and complete the protection setup.
- Test the locked area again to confirm whether editing is restricted.
What is the difference between Lock Cells and Protect Worksheet?
- Lock Cells marks which areas should be protected.
- Protect Worksheet makes those lock settings take effect.
- You need both together to restrict changes to specific areas.
What should I do if I forget the protection password?
- First check whether you still have an original unprotected file or a backup copy.
- If you need to continue collaboration, consider creating a new sheet and setting the protection rules again.
- For future use, store the password in a way that is easier to manage.
Glossary
| Term | Definition |
|---|---|
| Lock Cells | A protection setting applied to selected cells so they cannot be changed freely after worksheet protection is enabled. |
| Protect Worksheet | A worksheet-level protection setting that controls what users can do and makes locked-cell settings take effect. |
| Unlocked Cells | Cells that remain editable in a protected worksheet, usually used for data entry or form filling. |