View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cturner08 cturner08 is offline
external usenet poster
 
Posts: 4
Default pivot table defaults

When adding numeric fields to the Values section of a pivot table, is there a
way to have the Value Field Settings default to Average rather than Sum?
Seems like a lot of clicks are required to change every field individually.