“Can’t Add New Row to Excel?!”

Question:

I’m getting the following error in a worksheet:

“Microsoft Excel can’t insert new cells because it would push non-empty cells off the end of the worksheet.  These cells might appear empty but have blank values, some formatting, or a formula.  Delete enough rows or columns to make room for what you want to insert and then try again.”

 

Solution:

If we assume your data in cells A1 to S50, click in cell U1 and then press Ctrl+Shift+Right-arrow. Keeping Ctrl+Shift held, right click one of the selected cells and choose Delete Entire Column. That takes care of extra columns.

Now click in any cell well past your last entry in the A column, press Ctrl+Shift+Down arrow, this will highlight a series of cells. Keeping Ctrl+Shift held, right-click one of the selected cells and choose Delete Entire Row. That takes care of extra rows.

Wha-laa… fixed.