Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
is there a way to style (color) the data subtotals command
I run the Data-Subtotals option but I also want to format the new total line
as bold and color it. Does anyone know of a way to do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
is there a way to style (color) the data subtotals command
Select Format - Auto Format and then select a format. The only cuation I
will give is that this can be a slow process. Don't do it if you have more than about 10,000 lines of source data. As opposed to subtotaling I personally would recommend a pivot table. It is (once you get the hang of it) a lot faster easier and more flexible than subtotals. Additionally the formatting is a lot nicer... That is just my two cents. -- HTH... Jim Thomlinson "Lynne Schrupp" wrote: I run the Data-Subtotals option but I also want to format the new total line as bold and color it. Does anyone know of a way to do this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
is there a way to style (color) the data subtotals command
Saved from a previous post:
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. Lynne Schrupp wrote: I run the Data-Subtotals option but I also want to format the new total line as bold and color it. Does anyone know of a way to do this? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make my borded automatic black instead of pink? | Excel Worksheet Functions | |||
Pull data from another sheet based on certain criteria | Excel Discussion (Misc queries) | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Multi-level Subtotals with Excel 5.0 data | Excel Worksheet Functions | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |