Convert Formula References from Relative to Absolute
Change absolute formula references to relative references, vice versa, or a mix of absolute and relative columns and rows.
Wouldn't it be nice if you could easily convert your Excel formula references from absolute to relative and/or relative to absolute? Using the two methods in this tutorial, you can. You can even convert to a mix of relative row/absolute column references or absolute row/relative column references.
The fastest way works on less complicated formulas, but you'll need the second with mega and/or array formulas.