Cannot shify objects off sheet

G

Guest

I get the error cannot shift objects off sheet when trying to insert blank
rows in a spreadsheet. Any idea what this means?

Thanks
 
G

Guest

I can't explain exactly why it does this, but I do have a solution.

Delete a few blank rows before you insert some. This message (though it
doesn't exactly make sense, is Excel's way of saying "i'm full up with rows".
 
S

Simon Murphy

Do you have anything on Row 65536?
Are the scroll bars tiny?
You probably have some content right down at the bottom of the sheet.
Highlight the whole row from just after the last row that should be used
down to the end (shift +end down) and do Edit>>Delete, that should sort it.

cheers
Simon
Blog: www.smurfonspreadsheets.net
Website: www.codematic.net Excel development, support and training
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

inserting rows in spreadsheet 1
gettin an error "Cannot shift objects off sheet" while filtering 1
cannotshiftobjectsoffsheet appears when I insert columns , why? 2
How to avoid cannot shift objects off sheet when resizing columns? 3
I am trying to hide some columns 1
'Cannot shift objects off sheet' error message (group/outline) 2
Columns won't hide 1
why this message appear"cannot shift objects off sheet" ? 1

Top