What Is a Mixed Cell Reference in Excel?

By Staff WriterLast Updated Mar 25, 2020 12:48:58 PM ET

A mixed cell reference in an Excel spreadsheet refers to a cell that contains both absolute and relative references. An absolute reference is a number that remains the same, and a relative references is a number that changes when a formula or function is applied to new cells.

Advertisement