What is the difference between a relative and mixed cell reference in Excel?

Question

Microsoft Excel — Medium

What is the difference between a relative and mixed cell reference in Excel?

Accepted Answer

Relative and mixed cell references differ in how they adjust when copied. A relative reference, like A1, changes both row and column, whereas a mixed reference, such as $A1 or A$1, locks either the row or column. This distinction is key to understanding how formulas interact with data.