Home / MS-Excel / General Formatting

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.