Home » Excel » Excel Switch All Pivot Value Fields To Average or Max 2498

Excel Switch All Pivot Value Fields To Average or Max 2498

Microsoft Excel Tips and Tricks

Jeremy asks Is there a way to select multiple headings and change all of their “Summarize value field by” at once? I have hundreds of headings, each time I want to change their value by Max, Min, Average, I have to select one heading at a time, it is extremely labor intensive. Is there a way to change field calculation for multiple headings at once?

Credit MrExcel.com

Please support our Sponsors here :