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.
Leave a Reply