Inserting new line and get "Cannot shift objects off sheet" Help!

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

Guest

I am only trying to insert a blank line in between other lines and get the
above warning message. Any suggestions please I would be very grateful. I
have tried using the Cells then insert as suggested on help. I have tried
right click and insert. I have tried high lighting another used line to cut
and insert cut cells and still get the same message. Any help would really
be appreciated. Thank you
 
Do not know what error message you are getting, but it sounds like your sheet
is too big? When you click <Ctrl><End>, where in your spreadsheet does your
cursor end up? Most likely in line 65536? If this is beyond the end of your
actual used space on the sheet, go to the last used cell - sy in line 60000,
and delete all the lines below that. Also if the last used cell is in say
Column GK, but <Ctrl><End> takes you to column KG, then delete the columns
from GL to KG. Save your file, and try to insert a line again.
 
Get rid of comments or any hidden objects that you have in the file.
Hopefully this will help.
 
Back
Top