What Is a Mixed Cell Reference in Excel?
Last 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.
When writing formulas or functions, the commands in Excel that perform calculations, the cells are referenced by the column letter, which always comes first, followed by the row number. A dollar sign is used before a reference to show that it is to remain constant. For example, B$2, is a mixed cell reference. The number is column b changes and the number in row 2 remains the same.
More From Reference
What Are the Strengths & Weaknesses of Psychoanalytic Theory?
What Are the Symbols Associated With the Seven Deadly Sins?
Circuitry 101: Examples of Series Circuits & How They Work
What Are Some Examples of Similes for Love?
What Are the Pros and Cons of Restorative Justice?
Rhymes to Remember the Order of the Planets