Change cell references in formulas to names
- Do one of the following:
- Select the range of cells that contains formulas in which you want to replace references with names.
-
Select a single cell to change the references to names in all formulas on the worksheet.
- On the Insert menu, point to Name, and then click Apply.
- In the Apply names box, click one or more names.