![]() |
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 |
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 |
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