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

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

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