Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel subtotal function- put subtotals in bold text
Is there a way to format the subtotals rows so all subtotal cells are in bold
without manually doing it one row at a time? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel subtotal function- put subtotals in bold text
If those are the only formulas in your workbook, you can do Edit--Go
To--Formulas, and Excel will highlight all those SUBTOTAL formulas, which you can then bold. -- Brevity is the soul of wit. "EPMMGR06" wrote: Is there a way to format the subtotals rows so all subtotal cells are in bold without manually doing it one row at a time? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel subtotal function- put subtotals in bold text
I use the outlining symbols at the left to show just the subtotals that I want
to bold. Then I select the range edit|Goto|special|visible cells only then format those visible cells the way I want. Other people use format|Conditional formatting to look for the word Total in the column that you used to do the subtotals. (The word could change depending on what function you used when you did data|subtotal.) Say you used column A for the subtotal key column--and you used Sum as your function. Then you could select the range (A1:x999 and with A1 the activecell): format|Conditional formatting formula is: =countif($a1,"*total*") and give it a bold format The $a means that each cell in the row will look back at column A to see if it contains the word Total. EPMMGR06 wrote: Is there a way to format the subtotals rows so all subtotal cells are in bold without manually doing it one row at a time? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get selected text within a cell to remain bold in excel? | Excel Discussion (Misc queries) | |||
Improve Excel Help Text - Make easier to Find Function Refs | Excel Worksheet Functions | |||
How to Convert Figures into Text in Excel | Excel Worksheet Functions | |||
Text records in Excel | Excel Discussion (Misc queries) | |||
in excel how to display results of a function and text in the sam. | Excel Worksheet Functions |