在用EXCEL的时候,想要工作表中的公式不被修改,那么该如何锁定Excel表格中的公式不被编辑?
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/8718367adab44aedf22aaa77a11c8701a18bfb39?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
材料/工具
Excel表格
方法
1/9
点击左上角的小三角符号。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/0bd162d9f2d3572ce586884f9813632762d0c339?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
2/9
右击鼠标,选择“设置单元格格式”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/908fa0ec08fa513dd8ce784d2f6d55fbb2fbd939?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
3/9
点击保护选项。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d6ca7bcb0a46f21faf534ac0e4246b600c33ae39?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
4/9
点击“隐藏”选项。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/242dd42a2834349b22617a16dbea15ce36d3be39?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
5/9
点击“审阅”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/11385343fbf2b211a24991ddd88065380cd78e39?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
6/9
点击“保护工作表”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/77094b36acaf2edde7965d7a9f1001e939019339?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
7/9
输入取消工作表锁定密码并点击确定。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/37d12f2eb9389b501e98f4c19735e5dde7116e39?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
8/9
再次输入密码。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/2cf5e0fe9925bc313b3a150b4cdf8db1cb137039?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
9/9
这样就保护工作表中的公式不被修改了。
请点击输入图片描述