Microsoft Office Tutorials and References
In Depth Information
Apply Range Names to Formulas
Apply Range Names
to Formulas
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
two ranges.
1 Select the range in which
you want to apply the
names.
Note: Select a single cell if you
want to apply the names to the
entire worksheet.
1
2 Click the Formulas tab.
3 Click the Define Name
drop-down arrow.
4 Click Apply Names.
2
3
4
 
Search JabSto ::




Custom Search