Replace or Change Names in Formulas with Cell Reference in Excel 365!!
Tags: kutoolsexceltutorial, replacenamesinformul, kutools
Published: 2020-11-21 08:00:38

---
title: Replace or Change Names in Formulas with Cell Reference in Excel 365!!
published: true
date: 2020-11-21 06:02:04 UTC
tags: KutoolsExcelTutorial,ReplaceNamesinFormul,Kutools
canonical_url: https://geekexcel.com/replace-or-change-names-in-formulas-with-cell-reference-in-excel-365/
---

In this article, we are going to see how to **Replace or Change Names in Formulas with Cell Reference in Excel Office 365** using **Kutools.** Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Replace Names within Formulas with Cell References in a Range:

If you want to replace names within formulas with cell references in a range, do as below steps.

- First, you need to **select the range** which contains formulas in the Excel spreadsheet.

![Select the range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-35.png)<figcaption id="caption-attachment-17774">Select the range</figcaption>

- Go to the **Kutools Tab, select** the **Name Tools** option, then **choose** the **Convert Name to Reference Range** option from the menu list.

![Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/2-34.png)<figcaption id="caption-attachment-17775">Kutools Tab</figcaption>

- It will open the **Convert Name to Reference Range Dialog Box.**
-  In this dialog box, you will see all formulas with names of the range listed under the **Range Tab.**
- You need to **check** the **formula** that **you want to replace** names with actual cell references in the list.
- Then, **click** the **Replace** button.

![Convert Name to Reference Range Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/3-33.png)<figcaption id="caption-attachment-17776">Convert Name to Reference Range Dialog Box</figcaption>

- It will display a **prompt box** to tell you how many formulas have been replaced with cell references.
- Then, **click** the **OK** button to close the prompt box.

![Prompt box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/4-29.png)<figcaption id="caption-attachment-17777">Prompt box</figcaption>

- At last, you will see that the **selected range names have been replaced with cell references** as shown in the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/5-24.png)<figcaption id="caption-attachment-17778">Result</figcaption>

## Change Names within Formulas with Cell References in a Worksheet:

To change names within formulas with cell references in a worksheet, follow the below steps.

- you need to **open the worksheet or workbook** which contains formulas.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/6-23.png)<figcaption id="caption-attachment-17781">Example</figcaption>

- Go to the **Kutools Tab, select** the **Name Tools** option, then **choose** the **Convert Name to Reference Range** option from the menu.

![Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/2-34.png)<figcaption id="caption-attachment-17775">Kutools Tab</figcaption>

- It will open the **Convert Name to Reference Range Dialog Box.**
- On the **Worksheet Tab** , you need to **select** the **All Worksheets** option in the Base Worksheet drop-down list.
- Now, you need to **check** the **formula** that **you want to replace** names with cell references.
- Then, hit the **Replace** option.

![Convert Name to Reference Range Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/7-21.png)<figcaption id="caption-attachment-17782">Convert Name to Reference Range Dialog Box</figcaption>

- It will display a **prompt box** to tell you how many formulas have been replaced with cell references.
- Then, **click** the **OK** button to close the prompt box.

![Click the OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/8-20.png)<figcaption id="caption-attachment-17783">Click the OK button</figcaption>

- Finally, all names within formulas have been replaced by the cell references as shown in the below screenshot.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/9-18.png)<figcaption id="caption-attachment-17784">Result</figcaption>

## Only Replace Specified Names within Formulas with Cell References:

If you want to replace all formulas which are used a specific name in the worksheet, then follow the below steps.

- Open the [sheet](https://geekexcel.com/how-to-use-excel-sheet-function-in-office-365-with-examples/) that contains formulas.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/6-23.png)<figcaption id="caption-attachment-17781">Example</figcaption>

- On the **Kutools Tab, select** the **Name Tools** option, then **choose** the **Convert Name to Reference Range** option from the menu.

![Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/2-34.png)<figcaption id="caption-attachment-17775">Kutools Tab</figcaption>

- It will open the **Convert Name to Reference Range Dialog Box.**
- Under the **Name Tab,** you can list all formulas according to specific names by using the **Base Name drop-down** list.
- You need to **check** the [**Sheets**](https://geekexcel.com/how-to-use-excel-sheets-function-in-office-365-with-examples/) that contain the specific formula which you want to replace. Here we choose **Quantity.**
- Then, hit the **Replace** option.

![Convert Name to Reference Range Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/10-15.png)<figcaption id="caption-attachment-17785">Convert Name to Reference Range Dialog Box</figcaption>

- It will display a **prompt box** to tell you how many formulas have been replaced with cell references.
- Then, **click** the **OK** button to close the prompt box.

![Click the OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/8-20.png)<figcaption id="caption-attachment-17783">Click the OK button</figcaption>

- At last, the range name you have specified has been replaced with the cell references as shown in the below screenshot.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/11-10.png)<figcaption id="caption-attachment-17786">Output</figcaption>

### Note:

- **View cell –** This option will help you to **view the cell when you click the item** in the **Convert Name to Reference Range Dialog box**.

![View All option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/12-10.png)<figcaption id="caption-attachment-17787">View cell option</figcaption>

## Verdict:

In this article, you can clearly understand the steps to **Replace or Change Names in Formulas with Cell Reference in Excel Office 365** using **Kutools. ** Drop your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Ahead:

- [How to find Vlookup and Return the Matching Values from Multiple Worksheets?](https://geekexcel.com/how-to-find-vlookup-and-return-the-matching-values-from-multiple-worksheets/)
- [Convert a Single Column or Row to Ranges/Vice Versa in Excel](https://geekexcel.com/how-to-convert-a-single-column-or-row-to-ranges-vice-versa-in-excel/)