I have a spreadsheet that i am trying to add a column to and i get the
following message;

To prevent possible loss of data, Microsoft Office Excel cannot shift
nonblank cells off the worksheet.

Try to locate the last nonblank cell by pressing ctrl+end, and delete or
clear all in cells 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 have tried both and still get the same message.

Note im using office 2003.

Possibly this................

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

But more likely Excel has estimated your used range to a point far below and
right of the actual data.

See Debra's site for re-setting used range.

http://www.contextures.on.ca/xlfaqApp.html#Unused


Gord Dibben MS Excel MVP

On Wed, 30 Apr 2008 14:52:22 -0400, Jason Marino <jmarino@mahoneycohen.com>
wrote:

>I have a spreadsheet that i am trying to add a column to and i get the
>following message;
>
>To prevent possible loss of data, Microsoft Office Excel cannot shift
>nonblank cells off the worksheet.
>
>Try to locate the last nonblank cell by pressing ctrl+end, and delete or
>clear all in cells 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 have tried both and still get the same message.
>
>Note im using office 2003.