excel Applying names to existing references

When you create a name for a cell or a range, Excel doesn’t automatically use the name in place
of existing references in your formulas. For example, assume that you have the following formula
in cell F10:
If you define the names Income for A1 and Expenses for A2, Excel doesn’t automatically change
your formula to
However, replacing cell or range references with their corresponding names is fairly easy. Start
by selecting the range that contains the formulas that you want to modify. Then choose
Formulas➜Defined Names➜Define Name➜Apply Names. In the Apply Names dialog box, select
the names that you want to apply and then click OK. Excel replaces the range references with the
names in the selected cells.