Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Closing grouping in Excel I get "Cannot shift objects off sheet"? | Excel Discussion (Misc queries) | |||
how do I correct error "Can not shift objects offf sheet" | Excel Discussion (Misc queries) | |||
Excel error "Cannot shift objects off sheet", can I fix? | Excel Discussion (Misc queries) | |||
unable to hide columns -"can not shift objects off sheet" shows | Excel Worksheet Functions | |||
Using hide in excel get "cannot shift objects off sheet" | Excel Worksheet Functions |