Menu
I am receiving an error saying:
Microsoft Excel can't insert new cells because it would push non empty cells off the end of the worksheet.
This happens when I try to insert a new row of data. I need to keep all of the data on the sheet I already have. I only have 56 rows, so I think I should be able to add more...
735
The most probable reason you are getting this message is that in the last row or column of your worksheet, there is either formatting, data or a formula.
"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.
Please check the following methods to confirm if you have tried both to insert rows/columns: Select any cell within the row, then go to Home > Insert > Insert Sheet Rows/Columns. Alternatively, right-click the row/column number, and then select Insert.
If the Insert Options button isn't visible, then go to File > Options > Advanced > in the Cut, copy and paste group, check the Show Insert Options buttons option.
Excel has a limited number of rows and columns (which varies with version).
To find your last cell with data in it, click on any cell and then press Ctrl+End.
This will then take you to the furthest from A1 which has content. You'll need to remove what is there to add extra rows.
186
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
