Microsoft Office Tutorials and References
In Depth Information
Creating Worksheet-Level Names
The Name Manager dialog box clearly identifies each name by its scope (see Figure 92-2). If the
scope of a name isn’t Workbook, the dialog box lists the sheet on which the name is defined.
Figure 92-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).