Menu:
Copying
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 diagrams below:
Double click to Autofill a Formula
In the below diagram B1 contains the forumla =A1.
By double clicking with the mouse on bottom right hand corner of the cell B1, the range B2 to B9 will be
auto filled with the formula per B1.
The below diagram, shows the result after double clicking
