- Picture and text skills
How to protect table data from being modified?
￭ For example, you want to set a certain cell range not to be selected for editing.
We can select the cell range and click the Review tab-Lock Cells.
￭ Click to protect the worksheet, where you can set the password for changing the worksheet and the scope of user operations allowed.
First set a password and uncheck "Select locked cells" within the allowed range.
At this time, it is found that the cell range cannot be selected for editing.
￭ In addition to setting the selected range, this tool can also set permissions for cell format modification, inserting rows and columns, sorting, and other operations.
Help us provide specific permissions for others to edit files together.
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/bao-hu-gong-zuo-biao-shu-ju-bu-bei-xiu-gai.html
支付宝扫一扫 
评论列表（196条）
测试