Microsoft Office Tutorials and References
In Depth Information
Apply Range Names to Formulas
Apply Range Names
You can save a great deal of time and effort by
getting Excel to replace range references in your
formulas with the corresponding range name.
If you have been using range references in your
formulas and you name those ranges later,
Excel will not automatically apply the new
names to the formulas. Fortunately, you can
get Excel to automatically replace range
addresses with the corresponding range names.
By default, Excel also renames all cell
references that can be described as the
intersection of a named row and a named
column. For example, if you have a tabular
range with a row named January and a column
named Rent, Excel applies the name January
Rent to the cell that is the intersection of these
1 Select the range in which
you want to apply the
Note: Select a single cell if you
want to apply the names to the
2 Click the Formulas tab.
3 Click the Define Name
4 Click Apply Names.