Insert new columns at end of Excel spreadsheet

Jolaaled

Hi all...really hope someone can help!

I have a large Excel (MS 2007) spreadsheet that I use for my personal budgetting.

It's pretty big and finally, I have reached column 'IV'. I now need to enter new data on further columns, but, for some reason, I am unable to add anymore columns. (Have tried the usual: right click-insert-columns) I'm using MS Excel 2007 Home version.

I get an error message to say that I need to clear cells..have done that...the cells in my final column are cleared...but I still cannot add new columns.

If anyone can help, it would be really appreciated!!

THANK YOU

Andy_L

Haven't got excel on this computer to check but having reached column IV that may be the maximum number of columns (256 IIRC) you can have in your version of excel.

System

You need to save your spreadsheet as a 2007 spreadsheet (xlsx) and then re-open it. This should give you the 16k columns that Excel 2007 is capable of.

Jolaaled

!!!!!! wrote: »

You need to save your spreadsheet as a 2007 spreadsheet (xlsx) and then re-open it. This should give you the 16k columns that Excel 2007 is capable of.

It worked!!!! THANK YOU SO MUCH!!