ASAP Utilities, description of our Excel toolsEnglish (us) / Nederlands / Deutsch / Español / Français / Português do Brasil / Italiano / Русский / 中文(简体) / 日本語
Formulas » Replace the range names used in formulas with their cell references (on selected sheets)This utility replaces the range names, used in formulas in the selected sheets, with their cell references.
For example if you have a value in cell C10 with the range name 'quantity' and you used a formula such as '=A1*quantity', then this utility will replace that formula with '=A1*C10'.
Starting this utilityIn the Excel menu choose: ASAP Utilities » Formulas » Replace the range names used in formulas with their cell references (on selected sheets)
« Return to the list of “Formulas” tools.
Download ASAP Utilities
Follow ASAP Utilities on Facebook
List of all utilities
Printer friendly page
^ Back to Top