Microsoft Office Tutorials and References
In Depth Information
Define a Range Name
4
chapter
Working with Range Names
The New Name dialog box
appears.
4 Type the name you want to
use into the Name text
box.
Note: The first character of
the name must be a letter
or an underscore . The )
name cannot include spaces
or cell references, and it
cannot be any longer than
255 characters.
Note: You can only use a
particular range name once
in a workbook.
5 Click OK.
Excel assigns the name to
the range.
A The new name appears in
the Name box whenever
you select the range.
Is there an easier way to define a range name?
Yes, you can follow these steps to bypass the New Name
dialog box:
1 Select the range you want to name.
2 Click inside the Name box.
3 Type the name you want to use.
4 Press .
Excel assigns the name to the range.
Search JabSto ::




Custom Search