Microsoft Office Tutorials and References
In Depth Information
Using Names to Work with Ranges
Excel also uses a few names internally for its own use. Although you can create names that override Excel’s internal
names, you should avoid doing so. To be on the safe side, avoid using the following for names: Print_Area, Print_
Titles, Consolidate_Area, and Sheet_Title. To delete a range name or rename a range, see “Managing names,” later
in this chapter.
Using the Name box
The fastest way to create a name is to use the Name box (to the left of the Formula bar).
Select the cell or range to name, click the Name box, and type the name. Press Enter to
create the name. (You must press Enter to actually record the name; if you type a name and
then click in the worksheet, Excel doesn’t create the name.)
If you type an invalid name (such as May21, which is a cell address), Excel activates that
address (and doesn’t warn you that the name is not valid). If the name you type includes an
invalid character, Excel displays an error message. If a name already exists, you can’t use
the Name box to change the range to which that name refers. Attempting to do so simply
selects the range.
The Name box is a drop-down list and shows all names in the workbook. To choose a named
cell or range, click the Name box and choose the name. The name appears in the Name box,
and Excel selects the named cell or range in the worksheet.
Using the New Name dialog box
For more control over naming cells and ranges, use the New Name dialog box. Start by
selecting the cell or range that you want to name. Then choose Formulas ➪ Deﬁ ned
Names ➪ Deﬁ ne Name. Excel displays the New Name dialog box, shown in Figure 14.21. Note
that this is a resizable dialog box. Drag a border to change the dimensions.
Create names for cells or ranges by using the New Name dialog box.