Forum Discussion

khudson05's avatar
khudson05
Copper Contributor
Jun 03, 2022
Solved

Error message help on Excel

I am working on a spreadsheet and I am trying to add additional rows.  This error message comes up: "Can not insert new cells because it would push non-empty cells off the end of the worksheet.  These non-empty 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 try again."

How do I do this?  Thanks for any help!

  • It's only available if you're using M365 (Enterprise version) provided by an employer. Without Inquire, you must select the rows and columns beyond your data and delete. Save the workbook, close and re-open before testing.

4 Replies

Resources