When using subtotals in Excel, how do you bold the dollar amount?

[guntergal]

I am trying to create a report using Excel that I use subtotals for. I sort
it by Department and I always get the department name bolded, but have to
manually bold the corresponding dollar amount. Any suggestions?

 

[Tom Hutchins]

Here is one way...

After creating all the subtotals, collapse the outline so that only the
subtotal rows are visible. Select all the data, then press Alt-: (Alt and a
colon) to select only the visible cells within the whole range you just
selected. Another way is to press F5, then Special >> Visible cells only >>
OK. Now apply Bold or any other formatting that should apply only to the
subtotals.

Hope this helps,

Hutch