I'd like to change the defaults of the subtotal menu - I use the same choices everytime.
S sshelton Sep 15, 2008 #1 I'd like to change the defaults of the subtotal menu - I use the same choices everytime.
D Dave Peterson Sep 15, 2008 #2 I don't think you can change that behavior. I'd like to change the defaults of the subtotal menu - I use the same choices everytime. Click to expand...
I don't think you can change that behavior. I'd like to change the defaults of the subtotal menu - I use the same choices everytime. Click to expand...
G Gord Dibben Sep 15, 2008 #3 Depends upon what type of data is in the range. If numerics it will default to Sum, if not, defaults to Count Gord Dibben MS Excel MVP
Depends upon what type of data is in the range. If numerics it will default to Sum, if not, defaults to Count Gord Dibben MS Excel MVP
