Hi everybody

Excel will not let me add a column in a sheet - it states that I will
lose data if I do so. Anybody who has experienced this before? Must be
something with the settings in the sheet or something.


Thanks in advance


/Heine

Heine,

Even if you insert a column Excel will still have 256 columns. This
means that the column furthermost to the right (IV) will be deleted.
This message comes when you attempt to insert column but the
column-to-be-deleted has data. Is this the case with your sheet?

HTH
Kostis Vezerides


Heine wrote:
Hi everybody

Excel will not let me add a column in a sheet - it states that I will
lose data if I do so. Anybody who has experienced this before? Must be
something with the settings in the sheet or something.


Thanks in advance

/Heine

If you have any blank columns, select them, right click and choose
Delete. Then save your workbook. You should now be able to add a
column unless you have already used all of the columns.


--
ExcelChampion
------------------------------------------------------------------------
ExcelChampion's Profile: http://www.officehelp.in/member.php?userid=5096
View this thread: http://www.officehelp.in/showthread.php?t=1262593

Posted from - http://www.officehelp.in