Locked cell reference

A

AvalancheMike

Is there a way to LOCK a cell reference to a particular cell? I don't mean
absolute reference. I want the cell reference (example 'A1') to stay
reference or locked on 'A1' even though a row or cell is added above or a
column or cell is added to the left of 'A1'.

Thanks!
 
Top