# 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

## Comments