I am looking for a way to change the label of a subtotal label to just say total instead of group total.
So instead of this:
Group Value
A 100
A 200
A Total 300
I get this:
Group Value
A 100
A 200
Total 300
You can write a quick macro to change it. Assume that the subtotal formulas are in column B (b2:b8 in my example, easy to change), and the "group total" titles are in column A, then this should work: