Excel表格有锁定的表格后就不能插入行或列是为什么？

原因：因为Excel表格已经设置了工作表保护造成的。
1、首先打开需要编辑的Excel表格，进入到编辑页面中。
/iknow-pic.cdn.bcebos.com/63d0f703918fa0ec50b7997c299759ee3d6ddb4b"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/63d0f703918fa0ec50b7997c299759ee3d6ddb4b?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/63d0f703918fa0ec50b7997c299759ee3d6ddb4b"/>
2、然后在编辑的窗口中，单击右键该工作表，选择撤销工作表保护。
/iknow-pic.cdn.bcebos.com/b21bb051f8198618033412f545ed2e738bd4e654"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/b21bb051f8198618033412f545ed2e738bd4e654?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/b21bb051f8198618033412f545ed2e738bd4e654"/>
3、然后同样可以在菜单栏审阅下点击撤销工作表保护。
/iknow-pic.cdn.bcebos.com/e850352ac65c1038d9f233b3bd119313b07e8937"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/e850352ac65c1038d9f233b3bd119313b07e8937?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/e850352ac65c1038d9f233b3bd119313b07e8937"/>
4、然后就可以插入表格了。
/iknow-pic.cdn.bcebos.com/7a899e510fb30f2452e81172c795d143ad4b0354"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/7a899e510fb30f2452e81172c795d143ad4b0354?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/7a899e510fb30f2452e81172c795d143ad4b0354"/>

温馨提示：答案为网友推荐，仅供参考

当前网址：https://verywind.cn/ee/jf33y3r773xvyjf223.html