EXCEL RELATIVE REFERENCE

EXCEL RELATIVE REFERENCE is a type of cell reference used in formulas and functions that adjusts its location based on where the formula is copied or filled. When you use a relative reference in a formula, Excel automatically adjusts the reference when you copy the formula to another cell.

References are relative by default and are without a dollar sign ($).

In the example, we will sum the weekly score of player 1 in cell I5.

Copy the formula from cell H5 and paste it on cells H6, H7, H8.

When we paste the formula in cell I7, it selects the range E8:H8 because we didn’t lock the cells in the range E5:H5 using the dollar ($) sign.

Note: If we lock the cells using the dollar ($) sign, the range will not change in the next formula.