Replace Cell References with Defined Names in Excel Formulas
Question details
Update existing Excel formulas to use defined names instead of cell references without manually rewriting every formula.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A worksheet contains formulas that refer to cells or ranges for which defined names are available.
- Observed behavior
- The user wants existing formulas to display the defined names while preserving their calculations.
Open Formulas > Name Manager and confirm that each name refers to the intended cell or range and is available to the formulas you want to update. Select the cells containing those formulas before applying names or searching for references.
Apply existing defined names to Excel formulas
Use Excel's Apply Names command to replace matching references in selected formulas.
On the worksheet, select the cells or range containing the formulas you want to update.
Go to Formulas, open the Define Name drop-down, and select Apply Names.
In the Apply Names dialog, select the defined names you want to use, then click OK.
Select a few updated cells and inspect the formula bar to confirm that the names and calculated results are correct.

Use Find and Replace for specific formula references
Use this method when you need to replace a specific reference and can verify every match before changing it.
Replace formula references with defined names in WPS Spreadsheet
Open your workbook in WPS Spreadsheet and use Find and Replace to change verified formula references to existing defined names.
- 1. Open the workbook: In WPS Spreadsheet, choose Open and select your Excel workbook.
- 2. Check the defined name: Go to Formulas > Name Manager and confirm that the name points to the intended cell or range.
- 3. Find the reference: Select the formula cells and open Home > Find and Replace > Replace. Enter the exact reference in Find what and the defined name in Replace with.
- 4. Replace verified matches: Use Find Next to inspect each match and click Replace for the intended references. Check the updated formulas and their results before saving.

Frequently Asked Questions
Do I need to create the names before applying them?
Yes. Open Formulas > Name Manager to check existing names, or use Formulas > Define Name to create a name for the intended cell or range.
Why did Apply Names leave some references unchanged?
The reference may not match the selected name's range or reference style, or the name may have a different scope. Check the formula bar and Formulas > Name Manager.
Can Find and Replace change more than the reference I intended?
Yes. It replaces matching text, which can occur inside a longer reference or quoted text. Use Find Next and inspect each match before clicking Replace.
Will replacing a reference with a name change the calculation?
The result should stay the same if the name refers to the same cell or range in the formula's context. Check the name in Formulas > Name Manager and compare the calculated results after the change.




