Often we have several cells that need the same formula (in relationship)
to the location it is to be typed into. There is a short cut that is
called Fill Down. There are a number of ways to perform this operation.
One of the ways is to
select the cell that has the original formula
hold the shift key down and click on the last cell (in the series
that needs the formula)
under the edit menu go down to fill and over to
down
A
B
C
1
5
3
=A1+B1
2
8
2
fill down
3
4
6
fill down
4
3
8
fill down
Cells information is copied from its relative position. In other
words in the original cell (C1) the equation was (A1+B1).
When we paste the function it will look to the two cells to the left.
So the equation pasted into (C2) would be (A2+B2).
And the equation pasted into (C3) would be (A3+B3).
And the equation pasted into (C4) would be(A4+B4).
