When you copy a formula with a mixed reference to a new loca…
When you copy a formula with a mixed reference to a new location, the absolute portion of the cell reference remains fixed and the relative portion changes.
When you copy a formula with a mixed reference to a new loca…