inserting rows in spreadsheet

M

Mzungucarol

When I try to insert a row I get the response "Cannot shift objects off
sheet". How do I correct this error so that rows can be inserted?

thank you
 
S

Shane Devenshire

Hi,

This means that there is something near the bottom of your spreadsheet and
when you try to insert some rows Excel doesn't know where to push those
things. Select all the row number from the last one with data you want, down
to the end of the worksheet (row 65536 or 1048376) and press Ctrl+- (control
minus). Save the file and try the insert rows command again.
 

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

Cannot shify objects off sheet 2
cannotshiftobjectsoffsheet appears when I insert columns , why? 2
gettin an error "Cannot shift objects off sheet" while filtering 1
Problem inserting rows 2
VBA - retrieve data on last create named range from previous inserted named range 0
Excel-Adding rows to master sheet that will be inserted on following worksheets 1
Excel 2007 "Can not shift objects off sheet" 4
Changes in How Code Acts After Upgrade of Excel 2

Top