

Then add them 1 by 1 to narrow down which is the one affecting that.Ĥ. If the issue disappears in the safe mode, you may need to manually disable all add-ins Hold Ctrl key to launch Excel in safe mode, this can narrow down whether there’s any third-party add-ins affecting that. Update history for Office 365 ProPlus (listed by date) to check if you have the latest version of Excel, if not, you can update your Excel to the latest version to check if the same problem will occur.ģ. If all workbooks have the same problem, you can refer to this article:

Generally, this is the easiest way to fix an issue only affecting a specific file.Ģ. You can also create a new workbook and copy paste content to the new one and see whether you can get rid of the problem. Because the protect sheet feature may block

Go to Review tab, check whether you have “Unprotect Sheet” button. If this problem only occurs on a specific workbook, please check whether the worksheet is protected. Given this situation, I want to give you some suggestions below and hope that will help you:ġ. If so, we have tested it with the latest version of Excel and we cannot reproduce the same situation as yours. Thank you for your message in this forum.Īccording to your description, it seems that you cannot inset rows and columns in Excel.
