I have inherited a spreadsheet that I did not create. I am trying to insert
columns, but when I attempt to do this, I get an error statement saying
"To prevent possible loss of data, Microsoft Excel cannot shift nonblank
cells of the worksheet. Try to delete or clear the cells to the right and
below your data. then select cell A1, and save your workbook to reset the
last cell used. Or, you can move your data to a new location and try again.
I have done everything I think I can do, including clearing out the entire
spreadsheet un-merging cells. I still get the same error statement. Can
anyone please help put me on the right track.

Thanks.

The information in the following MSKB article may help you:

Error message: To prevent possible loss of data, Microsoft Excel cannot
shift nonblank cells off the worksheet
http://support.microsoft.com/default.aspx?id=305568

GJB wrote:
I have inherited a spreadsheet that I did not create. I am trying to insert
columns, but when I attempt to do this, I get an error statement saying
"To prevent possible loss of data, Microsoft Excel cannot shift nonblank
cells of the worksheet. Try to delete or clear the cells to the right and
below your data. then select cell A1, and save your workbook to reset the
last cell used. Or, you can move your data to a new location and try again.
I have done everything I think I can do, including clearing out the entire
spreadsheet un-merging cells. I still get the same error statement. Can
anyone please help put me on the right track.

Thanks.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html