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