Tip of the Day | Saturday June 6th, 2026

Discover new tools to get things done. ASAP Utilities makes YOU rock in Excel!

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.

Screenshots

Example screenshot: 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

Starting this tool

Click ASAP Utilities › Formulas › 7. Replace Named Ranges in Formulas with Cell References
Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Formulas › Replace Named Ranges in Formulas with Cell References

Choose your language preference below

English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語

Today's Tip

Download

©1999-2026 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands

🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 26 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.