| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I change subtotal default settings from count to sum, for exam
I'd like to change the defaults of the subtotal menu - I use the same choices
everytime. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I change subtotal default settings from count to sum, for exam
I don't think you can change that behavior.
sshelton wrote: I'd like to change the defaults of the subtotal menu - I use the same choices everytime. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I change subtotal default settings from count to sum, for exam
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 On Mon, 15 Sep 2008 08:57:01 -0700, sshelton wrote: I'd like to change the defaults of the subtotal menu - I use the same choices everytime. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change date default settings | Excel Discussion (Misc queries) | |||
| how can i change default settings for spreadsheets | Excel Discussion (Misc queries) | |||
| Can I change my default paste settings? | Excel Discussion (Misc queries) | |||
| Change default import settings | Excel Discussion (Misc queries) | |||
| How do I change the default settings in charts? | Charts and Charting in Excel | |||
Linear Mode
