I have a sheet full of formulas referencing various cells. I want to be able to better understand the logic by looking at the formulas, so I decide to name the cells. How do I get existing formulas to show these names?
If you have a range of cells used in a formula, and later you named that range, you can reflect this change in the formula by going to:
Formulas >> Defined Names >> Define Name >> Apply Names
Hope that helps