When using WPS Lock Cells, common questions usually involve why locking does not take effect, how to remove locking, and how unlocked cells still work; this FAQ includes 3 common questions and a glossary.
FAQ
Why can I still edit a cell after setting it to locked?
- Check whether you only enabled the Locked property without turning on Protect Sheet.
- Open the Review tab and click Protect Sheet.
- Set and confirm the password, then test the locked cell again.
How do I remove cell locking?
- First use Unprotect Sheet or the matching remove-protection command on the Review tab, then enter the password.
- Select the target cell and right-click to open Format Cells.
- On the Protection tab, clear Locked, then protect the sheet again if needed.
Can I still edit other cells after locking some cells?
- Yes, as long as the other cells are not locked.
- When you protect the sheet, keep the needed permissions for selecting or editing unlocked cells.
- After that, users can continue entering content in unlocked areas.
Glossary
| Term | Definition |
|---|---|
| Locked | A protection property for a cell that usually takes effect only after sheet protection is enabled. |
| Sheet Protection | A protection rule applied to the current worksheet that can restrict changes to locked areas and define allowed actions. |
| Unlocked Cells | Cell areas that can still be selected or edited after sheet protection is turned on. |