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.
On Sat, 20 Jun 2009 19:21:31 -0500, Dave Peterson
wrote:
>Maybe...
>
>XL: "Cannot Shift Objects Off Sheet" Error Hiding Columns
>[URL="http://support.microsoft.com/default.aspx?scid=kb"]http://support.microsoft.com/default.aspx?scid=kb[/URL];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.
>
>JimS wrote:
>>
>> 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? >> Stay informed about: Cannot Shift Objects Off Sheet 
FAQ
Search
Profile
Private Messages
Log in
