A mixed cell reference in Excel allows one part of the reference to remain fixed while the other part changes when the formula is copied. This is achieved by using a dollar sign before either the column letter or the row number, but not both. For instance, $A1 keeps the column A constant but allows the row to change when copied down, while A$1 keeps row 1 constant but allows the column to change when copied across.