Use Control-Enter for super fast formula duplication in a range
A nice quick way of applying a function or formula to a whole range in one go, and not even having to drag any cells down or across!
Step 1 : Select the range you wish to affect
Step 2 : Type the function/formula in the Formula bar
Step 3 : Press CONTROL and ENTER
You will see how the function/formula is copied to every cell automatically.