i have a worksheet already made up but when i try to add a column it says not
able to due to data
i have a worksheet already made up but when i try to add a column it says not
able to due to data
"mari-claire" <mari-claire@discussions.microsoft.com> wrote in message
news:1B91610D-E261-43F4-9D78-9D5D6EC8EA2D@microsoft.com...
>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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks