Question

Difference between relative and absolute cell reference

Answer 1

The key difference between relative and absolute cells is that relative cell references move when you copy them, but absolute references do not. Absolute references are noted by a dollar sign in front of the cell reference. So a relative cell reference might look like =A1+A2 but an absolute reference might look like =$A$1+$A$2. (Actually, the formula can also look like =$A1+$A2 or =A$1+A$2, but let’s not get ahead of ourselves.)