I have a set of columns in a group. Within that set I've made a sub-group.
For some reason the +/- doesn't appear for the nested group, so I can't hid
just those columns. For some reason I don't have this problem with rows.
With rows if I make a group within a group the +/- boxes appear for both and
I can hide or unhide them with ease. But for columns the +/- box only
appears in the top row. How can I make it appear for the sub-group too?

Maybe you're not changing the range when you're applying the secondary grouping.

Try it with a smaller set of columns.

pspiel wrote:

I have a set of columns in a group. Within that set I've made a sub-group.
For some reason the +/- doesn't appear for the nested group, so I can't hid
just those columns. For some reason I don't have this problem with rows.
With rows if I make a group within a group the +/- boxes appear for both and
I can hide or unhide them with ease. But for columns the +/- box only
appears in the top row. How can I make it appear for the sub-group too?

--

Dave Peterson

The problem seems to be that the summary colum is the same for both the group
and the sub-group. For example, the top group is rows I through M. The sub
group is rows J through M. Sometime I want to hide I throuh L, and sometimes
I want to hide J through L and leave I showing. It won't let me do that. I
don't know why.

"Dave Peterson" wrote:

Maybe you're not changing the range when you're applying the secondary grouping.

Try it with a smaller set of columns.

pspiel wrote:

I have a set of columns in a group. Within that set I've made a sub-group.
For some reason the +/- doesn't appear for the nested group, so I can't hid
just those columns. For some reason I don't have this problem with rows.
With rows if I make a group within a group the +/- boxes appear for both and
I can hide or unhide them with ease. But for columns the +/- box only
appears in the top row. How can I make it appear for the sub-group too?

--

Dave Peterson

The problem seems to be that the summary colum is the same for both the group
and the sub-group. For example, the top group is columns I through M. The
sub
group is columns J through M. Sometimes I want to hide I throuh L, and
sometimes I want to hide J through L and leave I showing. It won't let me do
that. I don't know why.

"Dave Peterson" wrote:

Maybe you're not changing the range when you're applying the secondary grouping.

Try it with a smaller set of columns.

pspiel wrote:

I have a set of columns in a group. Within that set I've made a sub-group.
For some reason the +/- doesn't appear for the nested group, so I can't hid
just those columns. For some reason I don't have this problem with rows.
With rows if I make a group within a group the +/- boxes appear for both and
I can hide or unhide them with ease. But for columns the +/- box only
appears in the top row. How can I make it appear for the sub-group too?

--

Dave Peterson

Are you using XL97?

I remember that happening to me on occasion, and never found out why.

Starting in a new sheet usually "fixed" something!?!?

If there was too much work already in the "bad" sheet to throw it away, I
used to get rid of all the groups, and then start over, creating the subs
*first*, and then working out.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"pspiel" wrote in message
...
I have a set of columns in a group. Within that set I've made a
sub-group.
For some reason the +/- doesn't appear for the nested group, so I can't
hid
just those columns. For some reason I don't have this problem with rows.
With rows if I make a group within a group the +/- boxes appear for both
and
I can hide or unhide them with ease. But for columns the +/- box only
appears in the top row. How can I make it appear for the sub-group too?

Maybe you could insert some small empty columns to make the selection easier.

pspiel wrote:

The problem seems to be that the summary colum is the same for both the group
and the sub-group. For example, the top group is columns I through M. The
sub
group is columns J through M. Sometimes I want to hide I throuh L, and
sometimes I want to hide J through L and leave I showing. It won't let me do
that. I don't know why.

"Dave Peterson" wrote:

Maybe you're not changing the range when you're applying the secondary grouping.

Try it with a smaller set of columns.

pspiel wrote:

I have a set of columns in a group. Within that set I've made a sub-group.
For some reason the +/- doesn't appear for the nested group, so I can't hid
just those columns. For some reason I don't have this problem with rows.
With rows if I make a group within a group the +/- boxes appear for both and
I can hide or unhide them with ease. But for columns the +/- box only
appears in the top row. How can I make it appear for the sub-group too?

--

Dave Peterson


--

Dave Peterson

No, I'm using XL2003.

A fresh sheet does no good. I tried that just now. If the far right colum
of both the group and the sub-group is the same colum it just won't show the
+/- box. I don't know if they intended that or if it's a glitch.

"RagDyer" wrote:

Are you using XL97?

I remember that happening to me on occasion, and never found out why.

Starting in a new sheet usually "fixed" something!?!?

If there was too much work already in the "bad" sheet to throw it away, I
used to get rid of all the groups, and then start over, creating the subs
*first*, and then working out.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"pspiel" wrote in message
...
I have a set of columns in a group. Within that set I've made a
sub-group.
For some reason the +/- doesn't appear for the nested group, so I can't
hid
just those columns. For some reason I don't have this problem with rows.
With rows if I make a group within a group the +/- boxes appear for both
and
I can hide or unhide them with ease. But for columns the +/- box only
appears in the top row. How can I make it appear for the sub-group too?

Can't you click on the *numbers* and get the same expand and collapse
displays?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"pspiel" wrote in message
...
The problem seems to be that the summary colum is the same for both the
group
and the sub-group. For example, the top group is columns I through M.
The
sub
group is columns J through M. Sometimes I want to hide I throuh L, and
sometimes I want to hide J through L and leave I showing. It won't let me
do
that. I don't know why.

"Dave Peterson" wrote:

Maybe you're not changing the range when you're applying the secondary
grouping.

Try it with a smaller set of columns.

pspiel wrote:

I have a set of columns in a group. Within that set I've made a
sub-group.
For some reason the +/- doesn't appear for the nested group, so I
can't hid
just those columns. For some reason I don't have this problem with
rows.
With rows if I make a group within a group the +/- boxes appear for
both and
I can hide or unhide them with ease. But for columns the +/- box only
appears in the top row. How can I make it appear for the sub-group
too?

--

Dave Peterson