Getting a "Cannot shift objects off of sheet"

[ch678]

While horizontally grouping (outlining) a set of columns, I receive an
error message that reads "Cannot shift objects off of sheet" when I
press the ( - ) to collapse the columns. Please note: there are no
objects or comments that I am aware of, and the message does not appear
when the last column is ungrouped.

Also, it appears when the previous group is collapsed and
visa versa. That is, I can collapse one group and get the message when
I try to collapse the other group. It is really strange the message
pops up at some of the oddest times.

As another scenario: It seems the message pops us at a certain cell to
the very far right columns. Very close to the IV column.

Has anyone encountered this before. Anyone's help would be greatly
appreciated.


Thanks.


Carey

 

[Bob Phillips]

See

http://support.microsoft.com?kbid=170081
XL97: "Cannot Shift Objects Off Sheet" Error Hiding Columns

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Anne Troy]

Try this, Carey:
http://support.microsoft.com/default.aspx?scid=kb;en-us;211769
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com