You could use format|conditional formatting.

Say your labels look like "header Total" are in column A.
Select the range to format (say A2:Z99)
And with the activecell A2:
Format|conditional formatting
Formula is: =COUNTIF($A2,"*total")0
and give it a nice format.

The $A means that excel will look at that column for the "Total" indicator.
Change that if you used Average, count, or ....

========
Another way...

Use the outlining symbols to the left to hide the details
Select the range to format
Edit|goto|special|Visible cells only
And format the visible cells the way you like.



Unknown User wrote:

Is there any short cut to high light in bold the sub total after the subtotal
exercise.
Your advise is important, thank you very much.

--

Dave Peterson