Excel Tricks

In this post we document some of the Excel tricks which you might find useful.

How to copy a formula to a range of cells

• First put your formula in F1.
• Now hit ctrl+C to copy your formula.
• Hit left, so E1 is selected.
• Now hit Ctrl+Down. This will travel all the way down until a blank is hit, in this example its E20000.
• Now hit right so F20000 is selected.
• Now hit ctrl+shift+up. Now you will be selecting F1:F20000.
• Finally either hit ctrl+V or just hit enter to fill the cells.

source: http://superuser.com/questions/180345/apply-formula-to-a-range-of-cells-without-drag-and-drop