Forum Discussion
How to replace existing cell references with cell names?
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?
8 Replies
Go to name manager and then use the associated cell name to change/delete or change scope to associated workbook or sheet.
Prad1Paw , Apply Names still doesn't work for named ranges in another worksheets, even if the name with Workbook scope.
I didn't test, but perhaps this tool Excel: Name Manager (jkp-ads.com) could help
SergeiBaklan I started a new thread with pretty much the same question but with examples and more specific questions.
I'm pretty sure this is possible without add-ons or even VBAs, and am hoping to just get the function.
- Hello, I can't figure out how to rank on my two-sheet while my data is on my sheet one Thank you. Thank you. Antoine
Hi,
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
