Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Subtotals
Hello,
I use subtotals to help me sum the totals of the differing nominal accounts in my management accounts. I collapse the spreadsheet so I can see the totals of each nominal and then highlight each line so that I can format the subtotals making them bold and increase the font size to make them stand out once printed. There can be many nominals and lines that differs from time to time throughout the accounting period. Is there a way I can do this quickley? Regards, Chris. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Subtotals
If you mean that you want to bold the amount/count etc for each line that
says Total in the leftmost column? Assume you have amounts starting in B2, s elect B2 down until the end and make sure B2 is the active cell (it will be if you select from B2 down) then do formatconditional formatting, formula is then in the box put =ISNUMBER(FIND("Total",$A2)) next click the format button (while you are still in the conditional formatting dialogue box) and select fonts, click on bold and click OK twice -- Regards, Peo Sjoblom "Chris Pringle" wrote in message ... Hello, I use subtotals to help me sum the totals of the differing nominal accounts in my management accounts. I collapse the spreadsheet so I can see the totals of each nominal and then highlight each line so that I can format the subtotals making them bold and increase the font size to make them stand out once printed. There can be many nominals and lines that differs from time to time throughout the accounting period. Is there a way I can do this quickley? Regards, Chris. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Original subtotals should not be within nested subtotals in excel | Excel Worksheet Functions | |||
Subtotals: Nested subtotals below higher subtotal | Excel Discussion (Misc queries) | |||
How do I copy an outline w/ subtotals & paste just the subtotals | Excel Discussion (Misc queries) | |||
Problem with nested subtotals, placing secondary subtotals BELOW . | Excel Discussion (Misc queries) | |||
why are nested subtotals coming out below outer subtotals? | Excel Worksheet Functions |