When using WPS Lock Cells, common questions usually focus on whether the lock takes effect, password handling, and editable range settings; this page covers 3 frequent questions.
FAQ
Why can other people still edit cells after I lock them?
- Check whether you only applied the Lock setting.
- Open Review and continue to Protect Sheet.
- After sheet protection is enabled, test the locked area again.
Can I allow only certain actions when I protect a worksheet?
- Open the Protect Sheet settings panel.
- Select the actions you want to keep available in the allowed actions list.
- After the setup is complete, users can perform only the actions you allowed.
What should I do if I forget the protection password?
- First check whether the worksheet protection password was recorded elsewhere.
- If you need to maintain the file often, use a password plan that is easier to manage when you set it.
- Keep the password safely after you set it so later unprotection is not affected.
Glossary
| Term | Definition |
|---|---|
| Lock Cells | A setting that applies a locked status to selected cells, usually to limit editing in a protected worksheet. |
| Protect Sheet | A worksheet-level protection setting that makes locked cells and allowed action rules take effect. |
| Allowed actions | The operations that remain available to users when worksheet protection is enabled, such as selecting locked or unlocked cells. |