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

  • Thread starter Thread starter guntergal
  • Start date Start date
G

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?
 
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
 
Back
Top