Grouping / Ungrouping

B

bluebadger

I have spent some time grouping rows on a large spreadsheet. Its quite
big and complicated now and there are 5 levels of grouping. What I
basically want to do is to remove the first layer of grouping so that
the second layer becomes the first. Make sense?

The first layer has 4 headings, when I open up the second layer there
is about 25, then the third its about 100 etc. I don't want to have to
undo all the levels of detail that I've creted, but whenever I use the
ungroup command on the higher level it just undoes everything.

Can anyone help?

Thanks.
 
R

RagDyeR

This can be done a couple of ways.

Play with this on a *copy* of your data:

Compress all the outlines (groups) until you only have your summary rows
displayed (only pluses visible).

Select *all* the summary rows, then:

<Shift> <Alt> <LeftArrow>

Expand everything and you should find that all your primary groupings have
been eliminated.

On a group by group basis, expand a group to the max and select all the rows
in that group.
Hold down <Shift> <Alt>,
And you'll find that each hit of the <LeftArrow> will remove the highest,
existing group.

To eliminate the lower groups, select just their rows and <Shift> <Alt>
<LeftArrow>.

Of course ... the opposite also works.

Select a range of rows (or columns), and hit
<Shift> <Alt> <RightArrow>
To *create* a group.

--

HTH,

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

in message
I have spent some time grouping rows on a large spreadsheet. Its quite
big and complicated now and there are 5 levels of grouping. What I
basically want to do is to remove the first layer of grouping so that
the second layer becomes the first. Make sense?

The first layer has 4 headings, when I open up the second layer there
is about 25, then the third its about 100 etc. I don't want to have to
undo all the levels of detail that I've creted, but whenever I use the
ungroup command on the higher level it just undoes everything.

Can anyone help?

Thanks.
 
Top