![]() |
have a spreadsheet made but it wont let me add additional column
i have a worksheet already made up but when i try to add a column it says not
able to due to data |
have a spreadsheet made but it wont let me add additional column
"mari-claire" wrote in message
... i have a worksheet already made up but when i try to add a column it says not able to due to data If you have something in column IV (the 256th, or last, column) and you try to insert another column you will get a message: "To prevent possible loss of data, Microsoft Excel cannot shift nonblank cells off the worksheet." Is this what you mean? If so, you need to delete some data to free up at least one column. You can use CTRL+END to take you to the last used cell. This will show you if you have anything in column IV. Perhaps you have something there that you didn't mean to have. |
All times are GMT +1. The time now is 03:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com