Can't insert column; keep receiving error message

[Guest]

I was updating a large spreadsheet and all of a sudden I was unable to insert columns. I kept getting an error message that said, "...unable to shift nonblank cells off worksheet." I tried everything from unhiding all columns and rows toreformatting all the comments to move and size with their relative cells. I also removed all the comments and I was still unable to insert a column. Does anyone have a solution

Thank you

 

[jgarlington]

-----Original Message-----
I was updating a large spreadsheet and all of a sudden I

was unable to insert columns. I kept getting an error
message that said, "...unable to shift nonblank cells off
worksheet." I tried everything from unhiding all columns
and rows toreformatting all the comments to move and size
with their relative cells. I also removed all the
comments and I was still unable to insert a column. Does
anyone have a solution?

Thank you
.
I have seen this before. Try hitting ctrl-end. I think

this should take you to the bottom row and right most
column with data in it. Then hit end up to find a cell in
the column that may have data in it. Erase the data and
try again. If that does not work, what is the rightmost
column with data in it?