Cannot shify objects off sheet

J

J R P

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

Thanks
 
R

RichN

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

Publisher adding blank page when printing my booklet... 2
Excel --> Word 4
gettin an error "Cannot shift objects off sheet" while filtering 1
Dealing with a Pivot Table (when I don't want to) 0
inserting rows in spreadsheet 1
Track Changes Settings 0
Dumb question alert! What program to use? 0
'Cannot shift objects off sheet' error message (group/outline) 2

Top