is there a way to style (color) the data subtotals command

L

Lynne Schrupp

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?
 
J

Jim Thomlinson

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.
 
D

Dave Peterson

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.
 
Top