Forum Discussion
error msg when I try to insert rows
In Excel, when I try to insert rows I get an error message "Microsoft Excel can't insert new cells because it would push non-empty cells off the end of the worksheet. These non-empty cells might app...
The issue is likely due to the 'used range' encompassing the entire sheet.
If you're running an Enterprise (work) version of M365, then you can use 'Clean Excess Formatting':
Clean excess cell formatting on a worksheet - Microsoft Support
If Inquire is not available, select the row after your data ends, press ctrl+shift+down arrow to select to the bottom of the sheet, then right-click delete. Repeat this for the columns.
Thank you. I appreciate the insight as to what may be the underlying issues.
Due to the time constraint I was under, I ended up copying all my data from the “bad” worksheet into a brand new one. It was the nuclear option, but I had no choice.
If the problem should arise again, I will know what to do.
Again, many thanks!
