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