建立如图的工作表,其中参加工作时间是不变的,是要保护的一列;利用快捷方式Ctrl+A,全部选中整个表格,点击菜单中的“单元格设置”--“保护””--“锁定”然后把单元格属性中的“锁定”前面的勾取消掉;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/18d8bc3eb13533fa76161361aed3fd1f40345bd9?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
选中需要保护数据的那一个列,点击菜单中的“单元格设置”,“保护””,“锁定”然后把单元格属性中的“锁定”前面的勾打上;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/574e9258d109b3de771a6427cabf6c81810a4cdc?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
点击菜单“工具”,“保护”,“保护工作表”,“保护工作表及锁定的单元格内容”,将“允许次工作表的所有用户进行”下面的复选框除“选定锁定单元格”外的全部打勾就可以了,还可以设定一个保护密码;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/f31fbe096b63f624e084ba4c8144ebf81b4ca3a0?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
表格保存后即可数值锁定。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/34fae6cd7b899e5128a2b75b44a7d933c8950d54?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)