A cell reference that locks either the row or the column using a single dollar sign.
Wypróbuj z SIA mixed reference combines relative and absolute referencing by placing a dollar sign ($) before either the column letter or the row number. This allows the reference to remain fixed in one dimension while adjusting in the other when the formula is copied to other cells.
=SUM($A1:A$10)In $A1, the column is locked while the row changes; in A$1, the row is locked while the column changes.
Select the cell reference in the formula bar and press F4 repeatedly to cycle through absolute, mixed, and relative options.