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