Copying Formulas

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).

Copying Formulas

872993

Choose:   INTEK home   I   training  I   by Jim Tracy   I