Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Subtotal groupings
I am using 1997-2003 version of Excel
When using the subtotal on a spreadsheet and when the subtotals are shown, the spreadsheet does not list the groupings on it. The groupings are 1 which shows all the information, 2 which shows just the subtotal and grand total, then 3 just shows the grand total. This has shown up on other company PC's that I have used in the past. Would appreciate any help that can be offered. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Subtotal groupings
Maybe you're not showing the outlining symbols:
In xl2003 menus: tools|Options|view|check "Outline Symbols" Quana wrote: I am using 1997-2003 version of Excel When using the subtotal on a spreadsheet and when the subtotals are shown, the spreadsheet does not list the groupings on it. The groupings are 1 which shows all the information, 2 which shows just the subtotal and grand total, then 3 just shows the grand total. This has shown up on other company PC's that I have used in the past. Would appreciate any help that can be offered. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
subtotal groupings not appearing to the left of the row numbers? | Excel Discussion (Misc queries) | |||
Variable row groupings | Excel Discussion (Misc queries) | |||
macro excel subtotal in subtotal | Excel Discussion (Misc queries) | |||
Excel should allow tab groupings. | Excel Discussion (Misc queries) | |||
Groupings | Excel Programming |