Microsoft Office Tutorials and References
In Depth Information
Tip 31: Creating Worksheet-Level Names
If the worksheet name contains at least one space, enclose the worksheet name in apostrophes, like
When you write a formula that uses a worksheet-level name on the sheet in which you defined it, you
don’t need to include the worksheet name in the range name. (The Name box doesn’t display the
worksheet name, either.) If you use the name in a formula on a different worksheet, however, you
must use the entire name (sheet name, exclamation point, and name).
If you copy a worksheet that has worksheet-level names, the names are duplicated as
worksheetlevel names in the new worksheet.
The Name Manager dialog box clearly identifies each name by its scope (see Figure 31-2). If the scope
of a name isn’t Workbook, the dialog box lists the sheet on which the name is defined.
Figure 31-2: The Name Manager makes it easy to distinguish between workbook-level names and
Only the worksheet-level names on the current sheet appear in the Name box. Similarly,
only worksheet-level names in the current sheet appear in the list when you open the
Paste Name dialog box (by pressing F3).