I'm unable to insert columns into my worksheet. Message I get is "To prevent
possible loss of data, Excel cannot shift nonblank cells off the worksheet.

Try to to locate the last nonblank cell by pressing CTRL+END, and delete or
clear all in cell between the last cell and the end of your data. Then
select cell A1 and save your workbook to reset the last cell used.

Or, you can move the data to a new location and try again."

I tried this, but I'm still unable to insert columns. I've also cleared
print area, but still no success. Any suggestions? By the way, all columns
are filtered (if this matters).

Thanks in advance.

hi
sounds like excel has lost it's reference to used range.
see this site for a posible fix.
http://www.contextures.com/xlfaqApp.html#Unused

regards
FSt1

"bronxbabe" wrote:

I'm unable to insert columns into my worksheet. Message I get is "To prevent
possible loss of data, Excel cannot shift nonblank cells off the worksheet.

Try to to locate the last nonblank cell by pressing CTRL+END, and delete or
clear all in cell between the last cell and the end of your data. Then
select cell A1 and save your workbook to reset the last cell used.

Or, you can move the data to a new location and try again."

I tried this, but I'm still unable to insert columns. I've also cleared
print area, but still no success. Any suggestions? By the way, all columns
are filtered (if this matters).

Thanks in advance.

If you for sure have deleted all columns to the right of your used range and
saved the workbook then you may have an Objects problem.

See this KB Article.

http://support.microsoft.com/default...b;en-us;211769


Gord Dibben MS Excel MVP

On Thu, 11 Dec 2008 15:51:01 -0800, bronxbabe
wrote:

I'm unable to insert columns into my worksheet. Message I get is "To prevent
possible loss of data, Excel cannot shift nonblank cells off the worksheet.

Try to to locate the last nonblank cell by pressing CTRL+END, and delete or
clear all in cell between the last cell and the end of your data. Then
select cell A1 and save your workbook to reset the last cell used.

Or, you can move the data to a new location and try again."

I tried this, but I'm still unable to insert columns. I've also cleared
print area, but still no success. Any suggestions? By the way, all columns
are filtered (if this matters).

Thanks in advance.

success. i evidentally wasn't propery deleting columns/rows, but merely
clearing contents. thank you.

"bronxbabe" wrote:

I'm unable to insert columns into my worksheet. Message I get is "To prevent
possible loss of data, Excel cannot shift nonblank cells off the worksheet.

Try to to locate the last nonblank cell by pressing CTRL+END, and delete or
clear all in cell between the last cell and the end of your data. Then
select cell A1 and save your workbook to reset the last cell used.

Or, you can move the data to a new location and try again."

I tried this, but I'm still unable to insert columns. I've also cleared
print area, but still no success. Any suggestions? By the way, all columns
are filtered (if this matters).

Thanks in advance.

i wasn't properly deleting columns/rows to solve problem. thanks.

"Gord Dibben" wrote:

If you for sure have deleted all columns to the right of your used range and
saved the workbook then you may have an Objects problem.

See this KB Article.

http://support.microsoft.com/default...b;en-us;211769


Gord Dibben MS Excel MVP

On Thu, 11 Dec 2008 15:51:01 -0800, bronxbabe
wrote:

I'm unable to insert columns into my worksheet. Message I get is "To prevent
possible loss of data, Excel cannot shift nonblank cells off the worksheet.

Try to to locate the last nonblank cell by pressing CTRL+END, and delete or
clear all in cell between the last cell and the end of your data. Then
select cell A1 and save your workbook to reset the last cell used.

Or, you can move the data to a new location and try again."

I tried this, but I'm still unable to insert columns. I've also cleared
print area, but still no success. Any suggestions? By the way, all columns
are filtered (if this matters).

Thanks in advance.

Deleting then saving is the key.

Clearing contents won't do the trick as you have learned.

Thanks for the feedback.


Gord


On Thu, 11 Dec 2008 18:35:01 -0800, bronxbabe
wrote:

i wasn't properly deleting columns/rows to solve problem. thanks.

"Gord Dibben" wrote:

If you for sure have deleted all columns to the right of your used range and
saved the workbook then you may have an Objects problem.

See this KB Article.

http://support.microsoft.com/default...b;en-us;211769


Gord Dibben MS Excel MVP

On Thu, 11 Dec 2008 15:51:01 -0800, bronxbabe
wrote:

I'm unable to insert columns into my worksheet. Message I get is "To prevent
possible loss of data, Excel cannot shift nonblank cells off the worksheet.

Try to to locate the last nonblank cell by pressing CTRL+END, and delete or
clear all in cell between the last cell and the end of your data. Then
select cell A1 and save your workbook to reset the last cell used.

Or, you can move the data to a new location and try again."

I tried this, but I'm still unable to insert columns. I've also cleared
print area, but still no success. Any suggestions? By the way, all columns
are filtered (if this matters).

Thanks in advance.