View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default 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?