Error in Inserting Column (and How to Solve It) (Excel 2013)

Let me just start off by saying, thank you very much to those of you who have been patiently waiting for my next post that seems to come once every dinosaur years. So here’s an irritating problem I recently have with Excel and the solution to it…

I was almost certain that the file was under some sort of spell! Whenever I tried to insert a new column (it doesn’t matter whether it is to the left or right), I keep getting this error message, and it was a lengthy one:

I didn’t quite understand the given instruction (especially the last sentence) but managed to solve it after a couple of attempts. Here’s how:

1.  Press the Ctrl and End buttons to jump to the end of earth last nonblank cell. In my case, it was cell XFD474.

2.  Left-click the last column XFD and drag it all the way to the left, then release the left mouse button. Depending on how bizarre is your sheet, I only dragged it till column XBE.

3.  Right-click exactly on the column XBE and not anywhere else in the sheet. Select Delete from the pop-up menu.

4.  Save your excel file. Then, go back to the column where you initially wanted to insert a new column. You should be able to do this successfully. If not, repeat Step 2 to 4.

Some important notes:

  • In Step 3, if you do not right-click on the exact column name, you will accidentally deselect all the highlighted areas
  • In Step 4, you must save the file first before you attempt to insert a new column, otherwise it wouldn’t work

 

Leave a Reply

Your email address will not be published. Required fields are marked *