Microsoft Office Tutorials and References
In Depth Information
Name a Range
Name a
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.
You can add a comment or note about
the range here. For example, you might
indicate what data the range contains.
5 Click OK.
Another way to name a range is to select the cells
in the range, click in the
field to the left of the
Formula bar, type the desired name, and press
Excel assigns the name to the cells.
Search JabSto ::

Custom Search