Can't insert column; keep receiving error message

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
-----Original Message-----
I was updating a large spreadsheet and all of a sudden I
Click to expand...
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
Click to expand...
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?
 
Back
Top