Awesome Excel tip #2

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.


Step 1

Step 2

Step 3