Microsoft Office Tutorials and References
In Depth Information
Name a Range
Name a
Range
You can assign distinctive names to the cells and
ranges of cells that you work with in a worksheet,
making it easier to identify its contents. A range
is simply a rectangular group of related cells; a
range can also consist of a single cell. Naming
ranges can also help you when deciphering
formulas. (Formulas are discussed later in
this topic.)
Name a Range
Assign a Range Name
1 Select the cells comprising the range
that you want to name.
2 Click the Formulas tab on the Ribbon.
3 Click the Define Name button.
The New Name dialog box opens.
4 Type a name for the selected range in
the Name field.
2
3
1
You can add a comment or note about
the range here. For example, you might
indicate what data the range contains.
5 Click OK.
Note:
4
Another way to name a range is to select the cells
in the range, click in the
5
field to the left of the
Formula bar, type the desired name, and press
Name
.
Excel assigns the name to the cells.
166
 
Search JabSto ::




Custom Search