Saving Time: Automatic fixed arrays, change multiple pivot groups?

[lord_yo]

Hello everyone

There are two things I'd love to be able to do in Excel in order to save me a lot of time -

1) When entering formulas, is there a keyboard shortcuts that, when selecting an array, includes the $ signs to fix the array?

2) When creating Pivots, is there a way to select the default summarization method (Count, Sum, Average...), or change multiple fields to the same summarization method?

Any idea if either of those is possible?
Thanks, LY

 

[mikerickson]

1) If I remember Windows Excel correctly, F4 will cycle through the variations of absolute/relative addressing when entering a formula. On a Mac it's Command+T.

 

[lord_yo]

F4 works beautifully, thank you!