Cannot Shift Objects Off Sheet

  • Thread starter Thread starter JimS
  • Start date Start date
J

JimS

All of a sudden I can't insert a new column anywhere within my
workbook. If I click on the column letter and then right
click>insert>I get the error message in the title.

Did I change a setting somehow?
 
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.
 
Thank you, Dave. Apparently I must have hit CTRL + 6 at some point.
Under advanced display options switching to all or toggling CTRL + 6
gets me back to normal and solves the problem.

I knew I did something funky.
 
Back
Top