subtotal functions
No addin that I know.
Louise wrote:
Dave:
I tried this and still having trouble.
I have a file that is 10K rows. and I have to sort & subtotal 3 ways.
is there an add-in for subtotals that maybe I can download that will give me
formatting options at the same time it is subtotaling?
"Dave Peterson" wrote:
Apply the data|Subtotals
Use the outlining symbols to the left to hide the details
select the range to modify
Edit|goto|special|visible cells only
apply the formatting you like to those visible cells
Then show all the range???
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
--
Dave Peterson
--
Dave Peterson
|