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.
More From Reference
Is the Coronavirus Crisis Increasing America's Drug Overdoses?
Fact Check: What Power Does the President Really Have Over State Governors?
Festival of Sacrifice: The Past and Present of the Islamic Holiday of Eid al-Adha
How Worried Should We Be About the Saharan Dust Cloud’s Arrival?
What Are a Tenant’s Rights During Eviction?
Has the Time Come to Abolish the Electoral College?