- Picture and text skills
When we use the WPS form to enter data.
If you want to lock a certain cell from being modified or hide the formula in a certain cell, what should you do?
▪Taking this table as an example, select cell A2.
Right-click "Format Cells", its shortcut key is Ctrl+1.
In the Format Cells dialog box, click the "Protect" column, check "Lock" and confirm.
We can see that cell A2 is locked and cell B2 is unlocked.
▪Click on the upper menu bar-Review-Protect worksheet.
In the "Protect Worksheet" dialog box, check the permission setting password and click OK.
At this point, we can find that we can only edit the B2 cell that is not locked, and cannot edit the locked A2 cell.
▪How to hide the formula in a certain cell?
Take this table as an example. We can see that cell A5 contains formulas. Click the "Protect" column, check "Hide" and confirm.
Then we click on the upper menu bar-Review-Protect Worksheet to open the protected worksheet.
At this time when we place the cursorA5at.
We can find that the formula bar above will not display the formula of cell A5.
Do you understand this practical function?
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/suo-ding-dan-yuan-ge-bu-bei-bian-ji-yin-cang-dan-yuan-ge-gong-shi-bu-xian-shi.html
评论列表(196条)
测试