Replace Named Ranges in Formulas with Cell References

ASAP Utilities › Range  ›  24. Replace Named Ranges in Formulas with Cell References

This tool replaces named ranges in cell formulas with their actual cell references on the selected worksheets.

For example:

  • If cell C10 is named quantity and a formula contains =A1*quantity, it becomes =A1*C10.
  • If the named range refers to another sheet (e.g., 'Input Values'!C10), the sheet name will be included in the formula: =A1*'Input Values'!C10.

This is helpful when simplifying formulas, auditing spreadsheets by making references more transparent, or preparing files for users unfamiliar with named ranges.
Some teams and organizations prefer or require raw cell references for documentation, validation, or archiving.

Starting this tool

Specify a Keyboard Shortcut: ASAP Utilities  › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Example screenshot: 1 Select the sheets and start the utility and the range names will be replaced with their cell references (Here's the English version.)
1 Select the sheets and start the utility and the range names will be replaced with their cell references
Example screenshot: 2 A report with the changes that were made (Here's the English version.)
2 A report with the changes that were made

Additional search terms to help you find this tool:
convert named ranges, replace named ranges, remove named ranges in formulas, convert names to cell addresses, replace name with reference, Excel formulas raw references, simplify Excel formulas, validation-friendly formulas, documentation-friendly formulas, replace name with cell location, formula conversion

Get Started with ASAP Utilities 9

Start saving time in Excel with practical tools you can use right away.

  • No sign-up required.

  • Free 90-day trial