Renaming cells across entire sheet

[joejackson123]

Hi All,

I have a workbook with a lot of hardcoded formulas, many referring to different sheets. In order to clarify the formulas, I retroactively changed some of the inputs to named cells. The formulas, however, still appear as numbered cell references, and not named cells - is there a command to universally change the numbered cell references to the new cell names? Any help is much appreciated, thank you!

 

[JumpingCrab]

Go to the menu Formulas>Define Name>Apply Names (found in Define Name dropdown menu)
That allows you to select the name that you want to propagate through the formulas in the sheet.

Hope this helps.
JL

 

[joejackson123]

Perfect, thank you!

 

[JumpingCrab]

You're welcome.