"Cannot shift objects off sheet."

Question

Suddenly I get this message every time I try to move a line on a worksheet, or to insert a line, or cell(s).  There is no way that I have used all the available lines, or anywhere close to that.  I tried deleting hundreds of empty lines at the unused bottom of the worksheet, with no effect.  I cannot operate without being able to move or add lines or cells.  How can I fix this??

Answer 1

Maybe...

XL: "Cannot Shift Objects Off Sheet" Error Hiding Columns

http://support.microsoft.com/default.aspx?scid=kb;en-ca;211769

Remember to look for comments and merged cells.

And for objects that may not be displayed:

xl2003:

tools|options|view tab|Check Show All

xl2007:

Office button|excel options|advanced

Display options for this workbook|For objects|Show|check all

ctrl-6

Should do the same in any version.

Debra Dalgleish has a blog post, too:

http://blog.contextures.com/archives/2009/03/16/cannot-shift-objects-off-sheet-in-excel-2007/

ceedeeh wrote:

 Suddenly I get this message every time I try to move a line on a worksheet, or to insert a line, or cell(s).  There is no way that I have used all the available lines, or anywhere close to that.  I tried deleting hundreds of empty lines at the unused bottom of the worksheet, with no effect.  I cannot operate without being able to move or add lines or cells.  How can I fix this??

--

Dave Peterson

Answer 2

You might try just copy and paste your data area over to a new sheet.......assuming you don't h ave a bunch of linking, you should be alright......if so, you can then delete the old sheet and just use the new one.

hth

Vaya con Dios,

Chuck, CABGx3

Answer 3

actually, rset the page breaks/clear the print area - it is one of these two, if not the other suggestions (comments, etc)

Answer 4

try changing/resetting the print area!