Microsoft Office Tutorials and References
In Depth Information
Use Worksheet Text to Define a Range Name
Use Worksheet Text to
Define a Range Name
If you have several ranges to name, you can speed
up the process by getting Excel to create the names
for you automatically based on each range’s text
labels.
You can create range names from worksheet text
when the labels are in the top or bottom row of the
range, or the left or right column of the range. For
example, if you have a column named Company,
using the technique in this section results in that
column’s data being assigned the range name
“Company.”
Use Worksheet Text to Define a Range Name
1 Select the range or ranges
you want to name.
A Be sure to include the text
labels you want to use for
the range names.
2 Click the Formulas tab.
3 Click Create from Selection .
Search JabSto ::




Custom Search