I have been using the grouping and outlining feature to group data sets so
that users can expand on only the areas in which they are interested. I have
15 groups of columns in a row. I currently have 12 of them closed and excel
will not let me close down any more. It is giving me the following error:

"Cannot shfit objects off sheet"

It doesn't seem to matter which 12 I have closed. If I open up a closed
grouping, I am able to close down another one. (hope that makes sense) I am
going bananas here - does anyone know why I am getting this error?

I am using Excel 2003 on XP Pro.

Any suggestions?

Maybe...

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.

Carlsongoblue wrote:

I have been using the grouping and outlining feature to group data sets so
that users can expand on only the areas in which they are interested. I have
15 groups of columns in a row. I currently have 12 of them closed and excel
will not let me close down any more. It is giving me the following error:

"Cannot shfit objects off sheet"

It doesn't seem to matter which 12 I have closed. If I open up a closed
grouping, I am able to close down another one. (hope that makes sense) I am
going bananas here - does anyone know why I am getting this error?

I am using Excel 2003 on XP Pro.

Any suggestions?

--

Dave Peterson