PC Review


Reply
Thread Tools Rate Thread

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

 
 
NICOLAS.K.
Guest
Posts: n/a
 
      23rd Feb 2009
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.
 
Reply With Quote
 
 
 
 
Glenn
Guest
Posts: n/a
 
      23rd Feb 2009
NICOLAS.K. wrote:
> 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...b;en-us;211769
http://support.microsoft.com/kb/q170081/


And please don't SHOUT (post in all caps). It is much harder to read.
 
Reply With Quote
 
Shane Devenshire
Guest
Posts: n/a
 
      23rd Feb 2009
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.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"NICOLAS.K." wrote:

> 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.

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Closing grouping in Excel I get "Cannot shift objects off sheet"? Nasty Merasty Microsoft Excel Misc 1 1st Feb 2008 05:16 PM
Inserting new line and get "Cannot shift objects off sheet" Help! =?Utf-8?B?bGFkeWJvcmFsbGFu?= Microsoft Excel Crashes 2 19th Oct 2006 08:55 PM
Excel locks up - dislays message "Cannot shift objects off sheet" =?Utf-8?B?SkJUU1I=?= Microsoft Excel Crashes 0 17th Oct 2006 04:14 PM
"Cannot shift objects off sheet" in excel when hiding columns =?Utf-8?B?Slp5Z211bg==?= Microsoft Excel Crashes 1 6th Mar 2006 05:25 PM
Excel Error Message: "Cannot shift objects off sheet" =?Utf-8?B?c3VsaWZyYQ==?= Microsoft Excel Misc 1 17th Jan 2005 04:41 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:07 AM.