Introduction
When you copy or move formulas in Excel, how the cell references behave can change your results. Understanding reference types helps you control whether formulas adjust or stay fixed, so your calculations stay correct.
When you want a formula to always refer to the same cell, even if you copy it elsewhere.
When you want a formula to adjust references automatically as you copy it down a column or across a row.
When you build a budget and want some values fixed but others to change as you copy formulas.
When you create a price list and want to multiply different quantities by a fixed price.
When you want to avoid errors caused by formulas pointing to wrong cells after copying.