- Double-click the cell that contains the formula you want to change. Microsoft Excel highlights each cell or range of cells with a different color.
- Do one of the following:
- To move a cell or range reference to a different cell or range, drag the color-coded border of the cell or range to the new cell or range.
-
To include more or fewer cells in a reference, drag a corner of the border.
-
In the formula, select the reference, and type a new one.
- Press ENTER or CTRL+SHIFT+ENTER for an array formula.
Change references to a named range
- 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.