Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Horizontal Subtotals
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Horizontal Subtotals
Thank you very much! That is exactly what I needed to know. I don't know why I didn't recognize that. I've worked with grouping
before but today it just didn't enter my mind. I saw the groups and my first thought was subtotals, even though, as you mentioned there aren't really any subtotals shown. -- RMC,CPA "Niek Otten" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Horizontal Subtotals
The person who created the spreadsheet probably used the options on the Group
and Outline submenu located on the Tools menu. They likely eihter selected columns and clicked group. Or they may have used the Auto Outline command. For basic instructions, check out Excel's "Create an outline" Help topic. -- tj "R. Choate" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Applying formulas only to the subtotals of a data list | Excel Discussion (Misc queries) | |||
How do I copy an outline w/ subtotals & paste just the subtotals | Excel Discussion (Misc queries) | |||
Excel gets subtotals out of order using multiple sorts and subtot. | Excel Discussion (Misc queries) | |||
Subtotals | Excel Discussion (Misc queries) | |||
why are nested subtotals coming out below outer subtotals? | Excel Worksheet Functions |