EXCEL表格为何工具栏不能用了呢?
发布网友
发布时间：2024-10-04 15:48
共1个回答
热心网友
时间：2024-12-02 14:57
1、选中单元格对单元格进行编辑，工具栏也是不可用的，如下图在编辑蓝色框框单元格时，红色框框的工具栏也是不可用的。此时只需任意点击一下，即可接触锁定。
/iknow-pic.cdn.bcebos.com/4610b912c8fcc3cee35661799f45d688d53f20e1"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/4610b912c8fcc3cee35661799f45d688d53f20e1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/4610b912c8fcc3cee35661799f45d688d53f20e1"/>
2、将EXCEL表格被锁定导致，只需撤销保护即可。撤销保护方法如下：
1）首先打开桌面上的EXCEL表格文件，如下图所示。
/iknow-pic.cdn.bcebos.com/d52a2834349b033bf08b549018ce36d3d539bd7d"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/d52a2834349b033bf08b549018ce36d3d539bd7d?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/d52a2834349b033bf08b549018ce36d3d539bd7d"/>
2）打开文件后，点击上方的菜单栏“审阅”，如下图所示。
/iknow-pic.cdn.bcebos.com/f7246b600c3387444bc687365c0fd9f9d72aa07d"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/f7246b600c3387444bc687365c0fd9f9d72aa07d?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/f7246b600c3387444bc687365c0fd9f9d72aa07d"/>
3）然后找到右手边的“撤销工作簿保护”选项，点击此选项，如下图所示。
/iknow-pic.cdn.bcebos.com/377adab44aed2e73edf72e668a01a18b87d6fa5a"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/377adab44aed2e73edf72e668a01a18b87d6fa5a?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/377adab44aed2e73edf72e668a01a18b87d6fa5a"/>
4.输入之前设置的保护密码，点击确认，如下图所示。
/iknow-pic.cdn.bcebos.com/f9198618367adab42eceb30986d4b31c8701e45a"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/f9198618367adab42eceb30986d4b31c8701e45a?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/f9198618367adab42eceb30986d4b31c8701e45a"/>
5.撤销之后，EXCEL表格中工具栏灰色就回复正常使用了。
/iknow-pic.cdn.bcebos.com/bd3eb13533fa828ba1e434a9f01f4134960a5ab0"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/bd3eb13533fa828ba1e434a9f01f4134960a5ab0?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/bd3eb13533fa828ba1e434a9f01f4134960a5ab0"/>
