Copying and Paste to a Range

A formula can be copied  and paste to a range.

1. You can highlight the cell with the formula to copy.
2. Press Control C.

3. Highlight the Range.

4. Then press Control V.

Drag and Drop a Formula

Alternatively, you can highlight the corner of the cell with the formula.
Hold the left mouse key then pull the mouse down.
See the diagram below:

Double click to Autofill a Formula

In the below diagram B2 contains the forumla =B1+1.
By double clicking with the mouse on bottom right hand corner of the cell B1, the range B2 to B6 will be auto filled with the formula per B1.