This issue is similar to absolute/relative references, but it's related to the data being referenced, not the cells doing the referencing. If I have a cell that references A3 then I insert a row above row 3 (making the original A3 cell now A4), my reference automatically changes to A4. How can I force the reference to say A3 regardless of any rows added or removed above row 3?