“Microsoft Excel can’t insert new cells because it would push non-empty cells off the end of the worksheet. These cells migt 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.”.
Excel can’t insert new column because it would push data of the – Microsoft Community Someone posted this problem, and I was having it too. I found the solution! It’s this: You need to delete the data AND THE FORMATTING in the cells to the right of your last used column and below your.
Our answer was merged rows/columns: When you merge entire rows or columns to make a single cell, you won’t be able to insert a new row/column. Formatting applied to an entire row/column: You may have unintentionally formatted an entire row/column. This could be the cause of the problem you are facing.
Now select the first empty row in your worksheet (below your data). You can quickly select the whole row by clicking on the row number that appears on the left of your worksheet Once you have completed these steps, try inserting a row or column.
How do I insert data from one cell to another?
For each worksheet click into a cell and press ctrl + end on your keyboard. Whatever cell is now selected is where Excel considers the last piece of data to be on the sheet (check it’s not somewhere ridiculous). Good tip about ctrl + end. What most often causes the problem where Excel can’t insert is formatting.
Why can’t I create new cells with cell protection active?
Therefore, if you have cell protection active, the creation of new cells will not be allowed in order to preserve your existing data. So all you have to do is deactivate the functionality.