Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default "Cannot shift objects off sheet" in Excel when inserting row/col?

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.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,240
Default "Cannot shift objects off sheet" in Excel when inserting row/col?

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 he

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.
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,346
Default "Cannot shift objects off sheet" in Excel when inserting row/col?

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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Closing grouping in Excel I get "Cannot shift objects off sheet"? Nasty Merasty Excel Discussion (Misc queries) 1 February 1st 08 06:16 PM
how do I correct error "Can not shift objects offf sheet" MOnte Excel Discussion (Misc queries) 1 April 30th 07 04:57 PM
Excel error "Cannot shift objects off sheet", can I fix? LionHearted1952 Excel Discussion (Misc queries) 1 September 30th 06 05:27 PM
unable to hide columns -"can not shift objects off sheet" shows Pinaki Excel Worksheet Functions 2 August 4th 06 03:15 PM
Using hide in excel get "cannot shift objects off sheet" snowbounduk Excel Worksheet Functions 1 November 22nd 05 03:15 PM


All times are GMT +1. The time now is 06:56 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"