Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Bolding the subtotal lines automaticlly When using the Subtotal fu
I know how to use the subtotal function, but only the colum which I am
sorting by is bold. How do I get the whole total line to be bold so I can easiely tell what I am looking at? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Bolding the subtotal lines automaticlly When using the Subtotal fu
After you apply the subtotals, use the outlining symbols to the left to hide the
details--just show what you want bolded. Then select that range to bold Edit|Goto|special|visible cells only and format those visible cells the way you want. 06Speed6 wrote: I know how to use the subtotal function, but only the colum which I am sorting by is bold. How do I get the whole total line to be bold so I can easiely tell what I am looking at? -- Dave Peterson |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Bolding the subtotal lines automaticlly When using the Subtota
Dave,
Thanks for your help it works just as I wanted it to. "Dave Peterson" wrote: After you apply the subtotals, use the outlining symbols to the left to hide the details--just show what you want bolded. Then select that range to bold Edit|Goto|special|visible cells only and format those visible cells the way you want. 06Speed6 wrote: I know how to use the subtotal function, but only the colum which I am sorting by is bold. How do I get the whole total line to be bold so I can easiely tell what I am looking at? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I color only subtotal lines in Excel 2002? | Excel Worksheet Functions | |||
formatting subtotal lines | Excel Discussion (Misc queries) | |||
how can I print and sort JUST the subtotal lines, not the detail | Excel Discussion (Misc queries) | |||
SUBTOTAL - TJ | Excel Worksheet Functions | |||
How do I remove the individual subtotal lines from a pivot table.. | Excel Discussion (Misc queries) |