Question
What is relative referencing in Excel?
Answer
By default Excel uses Relative Referencing. In relative reference, you actually refer to a cell that is above or below or left or right to a number of rows or columns. For example, if you refer to cell D2 from F2, you are actually referring to a column that is two columns to the left of cell D2 and in the same row (the second 2 row). When a formula that possesses a relative reference is copied from one cell to another cell, the value in the copied cell also changes. i.e., if you copy a formula =C2+D2 from E2 to the cell F2, the formula in F2 adjusts in such a way that when the cell F2 is dragged downwards by one row, the formula automatically changes to C3+D3 and places the resulting value of C3+D3 in cell F3.
For more information about Formulas and Functions in Excel, please view the full tutorial from the CTL here: Excel Part 3
If you need further assistance, please click the CTL Support Request button on this page