Unlike arelative reference, an absolute reference refers to an actual fixed location on a worksheet.
To create an absolute reference in Excel, add a dollar sign before the row and column.
Absolute reference
An absolute reference in Excel refers to a reference that is "locked" so that rows and columns won't change when copied.
