ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Data, Group got error message Cannot shift object off sheet (https://www.excelbanter.com/excel-discussion-misc-queries/48381-data-group-got-error-message-cannot-shift-object-off-sheet.html)

Matt

Data, Group got error message Cannot shift object off sheet
 
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

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


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com