Replace Name In Formulas With Cell Reference in Excel 2007/2010

When a formula uses range names, and you want to convert the range name references to the actual cell reference, how can you do? Excel is not able to do that, while the Kutools for Excel's Replace Range Names can help to quickly get it done.

Usage:

Step 1：Before using Replace Range Names, select the range that contains formulas you want to convert.

Step 2：Click Kutools >> More Tools >> Replace Range Names. See screenshot (Fig. 1).

Fig. 1 Replace Range Names

Step 3：Make sure that the Range box contains the correct range you want to convert. Then select the names to be replaced in the Name(s) to replace box. Use the All button to select all names, or use the None button to deselect all names. See Screenshot (Fig.2).

Step 4：You need to choose the type of the references (absolute or relative references) to be converted to. See Screenshot (Fig.2)

Fig. 2 Specify the range and references.

Step 5：Click OK, and you will get a message box tells you how many formulas have been modified.See Screenshot (Fig.3)

Fig. 3 Message box of replace range names.

As shown in the following screenshots:


Fig.4 Before converting the names to cell address		Fig.5 After converting the names to cell address