Excel Tricks

less than 1 minute read

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