I will try this. I have not used this function. my file is over 10K rows.

Louise

"Jim Thomlinson" wrote:

You can apply an AutoFormat (Tools - Format - AutoFormat). The only caution
I would have is that for a file over 10,000 rows long the amount of time that
this takes is exorbitant and the possiblility of crashing is high...
--
HTH...

Jim Thomlinson


"Louise" wrote:

When subtotaling a large worksheet is there a way to color and line the
subtotals at the same time.


Hope someone can help

Louise