Tom’s Tutorials For Excel: Converting Formula References From Absolute to Relative

Tom’s Tutorials For Excel: Converting Formula References From Absolute to Relative

I previously posted this manual example, and this programmed example for converting formula references from relative to absolute. The manual example showed how the row and / or column references can be kept or omitted. The programmed example showed how to convert all relative row and column references to absolute.

This time, here’s a fast and easy way to convert all absolute references to relative references, by eliminating the “$” character from your formulas.