Using data, subtotal
 

Is there a way to format the subtotal lines that are created when using data,
subtotal and I need to add a line under the new subtotals?

Using data, subtotal
 

You could use conditional formatting and look for total in the cell, such as
a formula like

=ISNUMBER(FIND("Total",A1))

and format with underline.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Kathie" wrote in message
...
Is there a way to format the subtotal lines that are created when using
data,
subtotal and I need to add a line under the new subtotals?