Section 7 - Relative Addressing

By default all cell references are relative. When you copy a formula containing relative cell addressing, the cell addresses are adjusted to reflect the new location. For example, enter into Cell B5 a formula that sums the values in Column B (=B2:B4). When you copy this formula into Cell C5, the value in that cell is the sum of the values in Column C (=C2:C4).