When using subtotals in Excel, how do you bold the dollar amount?
in [General]
|
Prev: Case Statement Format for getting cell value from a worksheet
Next: Input from remote 10-key and laptop numbers very slow
From: guntergal on 11 May 2010 15:44 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?
From: Tom Hutchins on 11 May 2010 16:36
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 "guntergal" wrote: > 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? |