Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
I created a command grouping several columns together by going to Data, Group.
When I go to click on the "-" sign to group. It gives me an error message;"Cannot shift object off sheet". Why? and how can I fix it. |
#2
![]() |
|||
|
|||
![]()
Maybe you have some objects that get rearranged when you hide the columns using
your grouping symbols. This may have some suggestions that work for you. It's kind of a similar problem. XL: "Cannot Shift Objects Off Sheet" Error Hiding Columns http://support.microsoft.com/default...b;en-ca;211769 Remember to look for comments and merged cells. Matt wrote: I created a command grouping several columns together by going to Data, Group. When I go to click on the "-" sign to group. It gives me an error message;"Cannot shift object off sheet". Why? and how can I fix it. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
trying to "paste special" data; why does worksheet object appear? | Excel Discussion (Misc queries) | |||
Group by Month when no data | Excel Worksheet Functions | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions |