Subtotals not grouping?
 

I'm doing subtotals, and it's not putting them in groups that you can expand
and collapse, it's just inserting the subtotal lines, why no groups?

Answer: Subtotals not grouping?
 

It sounds like you may have missed a step in the subtotals process. Here's a

1. step-by-step guide

to help you group your subtotals:
[list=1]
1. Select the range of data that you want to add subtotals to.
2. Go to the "Data" tab in the ribbon and click on "Subtotal" in the "Outline" group.
3. In the "Subtotal" dialog box, choose the column that you want to group by in the "At each change in" dropdown menu.
4. Select the function that you want to use for the subtotals in the "Use function" dropdown menu.
5. Check the box next to the column that you want to subtotal in the "Add subtotal to" list.
6. Click "OK" to apply the subtotals.

Once you've completed these steps, you should see groups that you can expand and collapse in your worksheet. If you're still having trouble, double-check that you've selected the correct range of data and that you've chosen the right options in the "Subtotal" dialog box.

Subtotals not grouping?
 

Try this shortcut:

<Ctrl <8

BUT ... the 8 *must* be from the numbers under the function keys, *not* from
the num keypad.

It's an "on/off" toggle!

If that works, the main setting is at:
<Tools <Options <View tab,
And check or uncheck "Outline Symbols".
--

HTH,

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

"dlw" wrote in message
...
I'm doing subtotals, and it's not putting them in groups that you can expand
and collapse, it's just inserting the subtotal lines, why no groups?

Subtotals not grouping?
 

Thanks! That worked. This sheet was exported from Crystal Reports, when I
copy everything from it into a new sheet, it groups as normal, too.

"RagDyeR" wrote:

Try this shortcut:

<Ctrl <8

BUT ... the 8 *must* be from the numbers under the function keys, *not* from
the num keypad.

It's an "on/off" toggle!

If that works, the main setting is at:
<Tools <Options <View tab,
And check or uncheck "Outline Symbols".
--

HTH,

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

"dlw" wrote in message
...
I'm doing subtotals, and it's not putting them in groups that you can expand
and collapse, it's just inserting the subtotal lines, why no groups?

Subtotals not grouping?
 

Thanks for the feed-back.
--

Regards,

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

"dlw" wrote in message
...
Thanks! That worked. This sheet was exported from Crystal Reports, when I
copy everything from it into a new sheet, it groups as normal, too.

"RagDyeR" wrote:

Try this shortcut:

<Ctrl <8

BUT ... the 8 *must* be from the numbers under the function keys, *not*
from
the num keypad.

It's an "on/off" toggle!

If that works, the main setting is at:
<Tools <Options <View tab,
And check or uncheck "Outline Symbols".
--

HTH,

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

"dlw" wrote in message
...
I'm doing subtotals, and it's not putting them in groups that you can
expand
and collapse, it's just inserting the subtotal lines, why no groups?