"Cannot shift objects off sheet" in Excel when inserting row/col?

[NICOLAS.K.]

CANNOT INSERT ROWS OR COLUMNS IN WORKSHEET AS ERROR MESSAGE READS "CANNOT
SHIFT OBJECTS OFF SHEET" HOWEVER CAN MOVE EXISTING DATA AND CREATE EMPTY
ROWS/COLUMNS.

 

[Glenn]

CANNOT INSERT ROWS OR COLUMNS IN WORKSHEET AS ERROR MESSAGE READS "CANNOT
SHIFT OBJECTS OFF SHEET" HOWEVER CAN MOVE EXISTING DATA AND CREATE EMPTY
ROWS/COLUMNS.

Look here:

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


And please don't SHOUT (post in all caps). It is much harder to read.

 

[Shane Devenshire]

Writing in ALL CAPITALS is considered SHOUTING on the internet and is bad
style.

This means that there is something in your spreadsheet that would be pushed
off the spreadsheet if you inserted the desired rows or columns. Suppose
there was a text box in column IV and you tried to insert a column between B
and C. You would get the error message because the text box can't be shifted
any further to the right in 2003. Find and remove or move the object. Press
F5, Special, Objects, OK and then press Tab as many times as necessary to
locate the problem item.