Mixed Cell References A mixed cell reference uses a combination of relative and absolute references in a formula. You can make either the column or row reference absolute by using the $ symbol, ...

Cell references in Excel are like addresses that point to specific cells. Three types of Excel cell references are relative, absolute, and mixed, each with unique functions.