| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing the Sub-Total Levels
Is there a way to remove the Numbered Levels that apear on the left of the
Row and Column Headings? I want to keep the Sub-Totals but do not want to show the "Drill Downs" + and/or - options 1 2 3... What would the command in the Macro be to hide these? -- MJM |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Removing the Sub-Total Levels
In xl2003 menus:
Tools|Options|View|uncheck Outlining symbols. If you need a macro, you can record one when you do it manually. MikeM wrote: Is there a way to remove the Numbered Levels that apear on the left of the Row and Column Headings? I want to keep the Sub-Totals but do not want to show the "Drill Downs" + and/or - options 1 2 3... What would the command in the Macro be to hide these? -- MJM -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Removing the Sub-Total Levels
Why did I not see that! THANKS!
-- MJM "Dave Peterson" wrote: In xl2003 menus: Tools|Options|View|uncheck Outlining symbols. If you need a macro, you can record one when you do it manually. MikeM wrote: Is there a way to remove the Numbered Levels that apear on the left of the Row and Column Headings? I want to keep the Sub-Totals but do not want to show the "Drill Downs" + and/or - options 1 2 3... What would the command in the Macro be to hide these? -- MJM -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing hyperlink without removing the font settings /border sett | Excel Programming | |||
| sum sub levels. | Excel Discussion (Misc queries) | |||
| sum sub levels. | Excel Programming | |||
| sum sub levels. | New Users to Excel | |||
| Removing the word "Total" from subtotal cells | Excel Programming | |||
Linear Mode
