If you define names for cell references after creating one or more formulas that use those cell references, you can update those cell references to names.

1. Do one of the following:
   • To update only certain formulas on a worksheet, select the cells that contain those formulas.

   • To update all the formulas on the worksheet, select a blank cell.

2. On the Insert menu, point to Name, and then click Apply.
3. In the Apply names box, click one or more names.