grouping and outline

[rexmann]

Hi all

I have been trying to use the grouping and outlining tool in order to divide up the months on my spreadsheet into quarters. There are 12 columns (obviously!!) starting with jan up to dec. I selected the Jan,feb and march months and grouped (no problem) however when I select april, may and June and group it becomes one outline (all six months). How do I keep them separate.

any suggestions are appreciated.

kind regards

Rexmann

ps im running excel XP/2002

 

[Eva Shanley]

Hi Rexmann,
I believe the problem you're having is because you don't
have a "summary column" between your first quarter data
and the second quarter data. The following came from Help:
"Microsoft Excel assumes by default that summary rows are
below detail rows and summary columns are to the right of
detail columns." You'll find that if you add a summary
column you should be able to outline separately.

-----Original Message-----
Hi all

I have been trying to use the grouping and outlining tool

in order to divide up the months on my spreadsheet into
quarters. There are 12 columns (obviously!!) starting with
jan up to dec. I selected the Jan,feb and march months and
grouped (no problem) however when I select april, may and
June and group it becomes one outline (all six months).
How do I keep them separate.

 

[Andy]

Hi

You got me thinking so I had a go - No idea why this works
like this but if you highlight just the first two months
in each quarter and then group them, excel will add in the
third - 3 for the price of 2 or something!!! This then
allows you to group the first 2 months in the next quarter
and so on. Like I say no idea why but it worked when I
tried it.

Et Voila

Andy

-----Original Message-----
Hi all

I have been trying to use the grouping and outlining tool

in order to divide up the months on my spreadsheet into
quarters. There are 12 columns (obviously!!) starting with
jan up to dec. I selected the Jan,feb and march months and
grouped (no problem) however when I select april, may and
June and group it becomes one outline (all six months).
How do I keep them separate.

 

[RagDyeR]

You can just add a column between each group, and narrow it down, so that
you just have it wide enough to display the "+" and "-".
--

HTH,

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

Hi all

I have been trying to use the grouping and outlining tool in order to divide
up the months on my spreadsheet into quarters. There are 12 columns
(obviously!!) starting with jan up to dec. I selected the Jan,feb and march
months and grouped (no problem) however when I select april, may and June
and group it becomes one outline (all six months). How do I keep them
separate.

any suggestions are appreciated.

kind regards

Rexmann

ps im running excel XP/2002

 

[RagDyeR]

You've just made the third month the "summary" column (month).

You'll notice, that when you expand or condense the columns you *always*
display this third (summary) column.

I believe that the OP was looking to condense the *entire* calendar quarter.
--

Regards,

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



Hi

You got me thinking so I had a go - No idea why this works
like this but if you highlight just the first two months
in each quarter and then group them, excel will add in the
third - 3 for the price of 2 or something!!! This then
allows you to group the first 2 months in the next quarter
and so on. Like I say no idea why but it worked when I
tried it.

Et Voila

Andy

-----Original Message-----
Hi all

I have been trying to use the grouping and outlining tool

in order to divide up the months on my spreadsheet into
quarters. There are 12 columns (obviously!!) starting with
jan up to dec. I selected the Jan,feb and march months and
grouped (no problem) however when I select april, may and
June and group it becomes one outline (all six months).
How do I keep them separate.