There are three types of cell references in Excel: relative, absolute, and mixed.
Relative cell references change when a formula is copied or moved to another cell.
Absolute cell references do not change (they are locked) when a formula is copied or moved to another cell.
Mixed cell references contain both absolute and relative components.
We suggest you head on over to take a look at this article, which goes over cell references and the dollar sign in detail.