Change cell reference in formulas to range names in Excel
As we know, the cell reference in the formula will change to their defined names automatically, if we have defined names for the cell reference before. However, the cell reference will not change to their defined names, if we create formulas for the cell reference before defining names. How to replace the cell reference with their defined names in the formulas quickly? You can do it with following steps:
Step 1: Go to the Defined Names group under Formulas Tab.
Step 2: Click the arrow button besides Define Name button, and select the Apply Names item from the drop down list.
Step 3: In the Apply Names dialog box, select the range names that you will apply to formulas, and click OK button.
Then you will see corresponding cell references in formulas are changed to its defined names, such as the following table shows:
|Formulas with Cell Reference||
Formulas with Names
Note: you can select multiple names in the Apply Names dialog box. The selected names will take place of corresponding cell reference in any formulas that with them.
Best Office Productivity Tools
Supports Office/Excel 2007-2021 and 365 | Available in 44 Languages | Easy to Uninstall Completely
Kutools for Excel Boasts Over 300 Features, Ensuring That What You Need Is Just A Click Away...
Supercharge Your Excel Skills: Experience Efficiency Like Never Before with Kutools for Excel (Full-Featured 30-Day Free Trial)
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day! (Full-Featured 30-Day Free Trial)