Relative references adjust when copied to new cells, while absolute references remain fixed using dollar signs.
Wypróbuj z SIA 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.