工作表设备了保护功能导致的不能插入行和列，清除保护步骤：
所需材料：Excel。
一、在开启工作表保护的时候右键点击单元格或整行整列时，弹出的菜单中的插入是不可用的。
/iknow-pic.cdn.bcebos.com/42a98226cffc1e17fdaec5224490f603738de994"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/42a98226cffc1e17fdaec5224490f603738de994?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/42a98226cffc1e17fdaec5224490f603738de994"/>
二、要解除此保护，首先点击顶部导航栏的“审阅”。
/iknow-pic.cdn.bcebos.com/a08b87d6277f9e2f89f7531b1130e924b999f3e7"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/a08b87d6277f9e2f89f7531b1130e924b999f3e7?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/a08b87d6277f9e2f89f7531b1130e924b999f3e7"/>
三、接着在“更改”栏内点击“撤消工作表保护”。
/iknow-pic.cdn.bcebos.com/d31b0ef41bd5ad6e91802df98fcb39dbb6fd3ca3"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/d31b0ef41bd5ad6e91802df98fcb39dbb6fd3ca3?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/d31b0ef41bd5ad6e91802df98fcb39dbb6fd3ca3"/>
四、这时回到工作表右键点击行或列的时候，插入就已经可以使用了。
/iknow-pic.cdn.bcebos.com/500fd9f9d72a6059e3b7a8092634349b033bba7a"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/500fd9f9d72a6059e3b7a8092634349b033bba7a?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/500fd9f9d72a6059e3b7a8092634349b033bba7a"/>