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.