Error with insert Rows and columns in MS Excel

Asked By 20 points N/A Posted on -

What’s up guys?

I made a large spreadsheet file to calculate my job expenses few months ago. It took me sometime in create this file, formatting all those cells  one by one and coding the section make it easy to use. It has been working well for a while now but I got a problem. I wanted to insert some few more rows and columns to add some additional expenses but MS Excel kind of does not allow for me to do it add more columns. I highlighted some columns and clicked on columns on the select Insert menu, the program shows the error message below:

Microsoft Excel

To prevent possible loss of data, Microsoft Office Excel cannot shift non blank cells off the worksheet.

Try to locate the last non blank cell by pressing CTRL+END, and delete or clear all in cells between the last cell and the end of your data. Then select cell A1 and save your workbook to reset the last cell used.

Or, you can move the data to a new location and try again.


The funny thing is that I can insert all the rows I want with any errors. I use to insert many rows and columns these past months as without problems. So why Excel is giving me all these errors.  Thanks in advance.

Answered By 10 points N/A #140427

Error with insert Rows and columns in MS Excel


Dear Carolfhughes,

I’ve read your problem. Do you have MS Excel 97/2003 installed on your machine? If so, then you need to know that Excel 97/2003 Spreadsheet (.xls) have a finite size of 65,536 Rows by 256 columns. If the spreadsheet has grown to the extent that all 256 columns contain required data, then this problem will be faced. Try to save your file as .xlsx Format.

If that’s not the case and you have latest MS Excel 2010 installed, then at some point you may have applied a formula or formatting to the whole sheet. Try to examine the right most column of your spreadsheet by holding Ctrl key and right arrow key. If there is nothing of importance then clear cells.

Alternatively you can also try changing the orientation of spreadsheet. But if your spreadsheet is complex then this won’t be an easy task, or it may not be practical at all.  

Hope this helps.

Login/Register to Answer

Related Questions