Excel subtotal function- put subtotals in bold text

[Guest]

Is there a way to format the subtotals rows so all subtotal cells are in bold
without manually doing it one row at a time?

 

[Guest]

If those are the only formulas in your workbook, you can do Edit--Go
To--Formulas, and Excel will highlight all those SUBTOTAL formulas, which you
can then bold.

 

[Dave Peterson]

I use the outlining symbols at the left to show just the subtotals that I want
to bold.

Then I select the range
edit|Goto|special|visible cells only
then format those visible cells the way I want.

Other people use format|Conditional formatting to look for the word Total in the
column that you used to do the subtotals. (The word could change depending on
what function you used when you did data|subtotal.)

Say you used column A for the subtotal key column--and you used Sum as your
function.

Then you could select the range (A1:x999 and with A1 the activecell):
format|Conditional formatting
formula is:
=countif($a1,"*total*")
and give it a bold format

The $a means that each cell in the row will look back at column A to see if it
contains the word Total.