How To Use Relative References in Microsoft Excel?
How To Use Relative References in Microsoft Excel?
When we use an Absolute Reference when filling Cells, it keeps the Row and Column constant.
When we use a Mixed Reference when filling Cells, either the Row or the Column will remain constant.
A plain Cell Reference though is a Relative Reference. Meaning that the Reference is relative to the location of the Cell. By default, all Cell References are Relative References. When we copy them across multiple Cells, they change according on the relative position of Rows and Columns.