Cell reference is used in a formula to refer to a specific cell or range of cells in a worksheet. It consists of the column letter and row number of the cell, such as A1 or B12.

1. When a formula is copied to other cells, the cell references may change automatically based on their relative position to the original cell. This is known as relative referencing.
2. Alternatively, cell references can be made absolute by adding a dollar sign ($) before the column letter and/or row number.
3. To create a cell reference in a formula, simply type the cell reference into the formula, or click on the cell(s) you want to reference while typing the formula.