ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   have a spreadsheet made but it wont let me add additional column (https://www.excelbanter.com/excel-discussion-misc-queries/61010-have-spreadsheet-made-but-wont-let-me-add-additional-column.html)

mari-claire

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

Stephen

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