Sometimes when we enter a formula, we need to repeat the same formula for many different cells. In the spreadsheet we can use the copy and paste command. The cell locations in the formula are
pasted relative to the position we
Copy them from.
| A | B | C |
| 1 | 5 | 3 | =A1+B1 |
| 2 | 8 | 2 | =A2+B2 |
| 3 | 4 | 6 | =A3+B3 |
| 4 | 3 | 8 | =? + ? |
| 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). |
If you have a lot of duplicate formulas you can also perform what is referred to as a FILL DOWN. (discussed next).
