When using subtotals in Excel, how do you bold the dollar amount?
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?
|