Removing the Sub-Total Levels

M

MikeM

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?
 
D

Dave Peterson

In xl2003 menus:

Tools|Options|View|uncheck Outlining symbols.

If you need a macro, you can record one when you do it manually.
 
M

MikeM

Why did I not see that! THANKS!
--
MJM


Dave Peterson said:
In xl2003 menus:

Tools|Options|View|uncheck Outlining symbols.

If you need a macro, you can record one when you do it manually.
Click to expand...
 
Top