When you enter or edit a formula, cell references and the borders around the corresponding cells are color-coded.
Color-coded cell references
If there are no squares at each corner of the color-coded border, then the reference is to a named range.
Change references that are not a named 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.
Change references to a named range
Select a single cell to change the references to names in all formulas on the worksheet.