View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Sub-Totals Question

Use the outlining symbols to the left to show just what you want to format (hide
those details).

Now select the range to format
edit|goto|special|visible cells only
and format the way you like.

You could record a macro if you want the code.

Andrew Mackenzie wrote:

Using the sub-totals feature in Excel the category being subtotaled is
highlighted in bold but the subtotals themselves are not highlighted. Is
there a way to format these items either using excel "as is" or with some
simple code?

Thanks,

Andrew.


--

Dave Peterson