Why is Excel not allowing me to insert rows? This can happen if your bottom rows aren’t clear, or if rows are protected. Add-ins and sheet protection can also cause this issue. What can I do if I can’t insert a row in Excel? If you’re in a hurry, you can copy data from ...
Microsoft has its own add-on called Clean Excess Cell Formatting, which is available on Excel's Inquire tab in Microsoft Office 365 and Office Professional Plus 2013. If you don't see the Inquire tab in Excel, do the following to enable the Inquire add-in: Click File > Options > Add-...