Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"cannot shift objects off sheet" error message,
I can't insert rows, I always get the above message. I also can't cut and
insert a row. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
"cannot shift objects off sheet" error message,
hi,
You have a used space problem. xl thinks you have data either in the far right column or far bottom row. Select all columns right of your data and hit the delete key. then select all rows below your data and hit the delete key. that should do it. regards FSt1 "mathewsd001" wrote: I can't insert rows, I always get the above message. I also can't cut and insert a row. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
"cannot shift objects off sheet" error message,
Make sure you save after the deleting of rows and columns or Excel won't adjust
the used range. In older versions you have to save then close and reopen to see changes. Gord Dibben MS Excel MVP On Sat, 25 Aug 2007 10:42:01 -0700, FSt1 wrote: hi, You have a used space problem. xl thinks you have data either in the far right column or far bottom row. Select all columns right of your data and hit the delete key. then select all rows below your data and hit the delete key. that should do it. regards FSt1 "mathewsd001" wrote: I can't insert rows, I always get the above message. I also can't cut and insert a row. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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) | |||
Why I am getting Error Message: "Cannot shift objects off sheet"?? | Excel Worksheet Functions | |||
Error Message: "Cannot shift objects off sheet." | Excel Discussion (Misc queries) | |||
What does the message: "Cannot shift objects off sheet" mean? | Excel Worksheet Functions |