Microsoft Office Tutorials and References
In Depth Information
Potential Problems with Names
Name problems when deleting sheets
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.
Figure 3-15 shows the Name Manager dialog box that displays an erroneous name. The workbook
originally contained a sheet named Sheet1, which had a named range (a workbook-level name,
MyRange ) for A1:F12. After deleting Sheet1, the name MyRange still exists in the workbook, but
the Refers To field displays the following:
As far as I can tell, keeping erroneous names in a workbook doesn’t cause any harm, but it’s still a
good practice to delete or correct all names that contain an erroneous reference.
Figure 3-15: Deleting the sheet that contains the cell for MyRange causes an erroneous reference.
When you add an object to a worksheet (such as a shape or clip art), 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.
Naming charts is an exception. To rename a chart, use the Chart Tools➜Layout➜Properties➜
Chart Name command.
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. 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.