Relative references adjust when copied to new cells, while absolute references remain fixed using dollar signs.
Provalo con l'IAA relative reference (e.g., A1) changes its row or column index when copied to another cell. An absolute reference (e.g., $A$1) uses dollar signs to lock the reference, ensuring it points to the same cell regardless of where the formula is pasted.
=$A$1*A2If you copy =A1*B1 down one row, it becomes =A2*B2 (relative); if you copy =$A$1*B1, it becomes =$A$1*B2 (absolute).
Select the cell reference in the formula bar and press the F4 key to cycle through absolute, mixed, and relative options.