I

P

Fill Down

N

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

  1. select the cell that has the original formula
  2. hold the shift key down and click on the last cell (in the series that needs the formula)
  3. 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).


I

P

Fill Down

N

441285