View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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