I need a way to lock excel formulas from changing when I either delete or move the cells the formulas are referencing. Using the absolute reference ($ sign) does not lock the formula from changing when the cell it references changes. It will keep is constant if you copy or move the formula...