To replace references in formulas with their corresponding names, choose Insert, Name, Apply. Excel locates all cell and range references for which you have defined names and changes them.

If you select a single cell before you choose the Apply command, Excel applies names throughout the active worksheet.

if you select a range of cells, Excel applies names to only the selected cells.

The Apply Names dialog box lists all the cell and range names you have defined. If you do not want to include all the names, click a name in the list to clear it; click it again to reselect it.