Microsoft Office Tutorials and References
In Depth Information
Define a Range Name
Define a
Range Name
Before you can use a range name in your formulas or
to navigate a worksheet, you must first define the
range name. You can define as many names as you
need, and you can even define multiple names for
the same range.
You can create range names manually, or you can get
Excel to create the names for you automatically
based on the existing text labels in a worksheet. To
do this, see the following section, “Use Worksheet
Text to Define a Range Name.”
Define a Range Name
1 Select the range you want
to name.
2 Click the Formulas tab.
3 Click Define Name .
Search JabSto ::




Custom Search