ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Problems adding a column (https://www.excelbanter.com/excel-programming/377486-problems-adding-column.html)

Heine

Problems adding a column
 
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


Nigel

Problems adding a column
 
Suspect you have data in the last column (IV); Excel shift columns to the
right and discards all columns above 256

It may appear you do not have data in the cells, such as spaces etc., remove
these by deleting the columns as required.

--
Cheers
Nigel



"Heine" wrote in message
oups.com...
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

Problems adding a column
 
Thanks Nigel - I am amazed I didnīt even think about that.

Cheers
Heine
Nigel skrev:
Suspect you have data in the last column (IV); Excel shift columns to the
right and discards all columns above 256

It may appear you do not have data in the cells, such as spaces etc., remove
these by deleting the columns as required.

--
Cheers
Nigel



"Heine" wrote in message
oups.com...
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




All times are GMT +1. The time now is 01:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com