Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
When using subtotals in Excel, how do you bold the dollar amount?
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing Row by Row - A-D dollar amounts to E dollar amount | Excel Worksheet Functions | |||
Excel subtotal function- put subtotals in bold text | Excel Discussion (Misc queries) | |||
Excel Function for max of percentage or dollar amount | Excel Worksheet Functions | |||
How do I add the same dollar amount to all cells in excel? | Excel Worksheet Functions | |||
when i enter a dollar amount of 18.40 into excel it drops the 0 | New Users to Excel |