View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten
 
Posts: n/a
Default Horizontal Subtotals

DataGroup and Outline
It's not exactly subtotals, though; read HELP for details

--
Kind regards,

Niek Otten

"R. Choate" wrote in message
...
I received a file that has subtotals going across instead of down, with 5
levels of subtotals. It inserted the subtotal expanding
and collapsing controls (the plus and minus signs) above the columns
headers. How can I replicate this on another worksheet? I can't
see any option for this, the subtotals dialog only shows vertical choices.

Thanks
--
RMC,CPA