这是因为开启了“保护工作表”的功能,开启该功能后就无法对工作表进行编辑,需要输入密码后才能重新进行编辑,操作的步骤如下:
1、打开电脑中的一个excel表格,在正常情况下,上面的工具栏选项是高亮的,说明可以对工作表进行编辑,此时找到上面的“审阅”菜单:
![](/img.php?b=https://iknow-pic.cdn.bcebos.com/6a600c338744ebf899bce7afcbf9d72a6159a755?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、点开审阅菜单后点击“保护工作表”,会弹出一个对话框,在对话框中输入密码,然后点击确定:![](/img.php?b=https://iknow-pic.cdn.bcebos.com/d439b6003af33a877ca0838ad45c10385243b555?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、这时可以看到,上面的工具栏选项已经变成灰的了,说明不可以进行编辑:
![](/img.php?b=https://iknow-pic.cdn.bcebos.com/1b4c510fd9f9d72ae7a9938dc62a2834359bbb55?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、此时只有再次点击审阅下的“撤销工作表保护”,并输入密码,按确定才可重新恢复可编辑状态:
![](/img.php?b=https://iknow-pic.cdn.bcebos.com/6a63f6246b600c3306b45d58084c510fd8f9a155?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、这样,工具栏中的选项又变成高亮了,如下:
![](/img.php?b=https://iknow-pic.cdn.bcebos.com/bf096b63f6246b608cc331e4f9f81a4c500fa255?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)