Microsoft Office Tutorials and References
In Depth Information
When you delete a worksheet that contains cells used in a workbook-level name, you'll find that the name is not
deleted. The name remains with the workbook, but it contains an erroneous reference in its Refers To definition.
When you add an object to a worksheet (such as a shape, an image, or a chart), the object has a default name
that reflects the type of object (for example, Rectangle 3 or Text Box 1 ).
To change the name of an object, select it, type the new name in the Name box, and press Enter.
Excel is a bit inconsistent with regard to the Name box. Although you can use the Name box to rename an object,
the Name box does not display a list of objects, so you can't use the Name box to select an object. However, you
can use the Selection Pane to list all objects and make them easy to select. To display the Selection Pan, choose
Home⇒Editing⇒Find & Select⇒Selection Pane.
Excel also allows you to define a name with the same name as an object, and two or more objects can even have
the same name. The Name Manager dialog box does not list the names of objects.
Figure 3-16 shows the Name Manager dialog box that displays an erroneous name. The workbook originally
contained a sheet named Sheet2, which had a named range (a workbook-level name, MyRange ) for A1:E12.
After deleting Sheet2, the name MyRange still exists in the workbook, but the Refers To field displays the fol-