Q & A by Maninder Singh

Question:

QUESTION: What is the difference between absolute and relative cell references in Excel?

Answer:

Absolute references ($A$1) stay fixed when copied, while relative references (A1) change relative to the destination cell when copied. They're used in formulas to control which cells are affected.