G
Guest
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.
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.