Microsoft Office Tutorials and References
In Depth Information
Adding Comments to Cells
Allows you to ﬁ filter the displayed names: Clicking the Filter button lets you show
only those names that meet a certain criteria. For example, you can view only the
Provides quick access to the New Name dialog box: Click the New button to
create a new name without closing the Name Manager.
Lets you edit names: To edit a name, select it in the list and then click the Edit
button. You can change the name itself, modify the Refers to range, or edit the comment.
Lets you quickly delete unneeded names: To delete a name, select it in the list
and click Delete.
Be extra careful when deleting names. If the name is used in a formula, deleting the name causes the formula to
become invalid. (It displays #NAME? .) It seems logical that Excel would replace the name with its actual address —
but that doesn’t happen. However, deleting a name can be undone, so if you i nd that formulas return #NAME? after
you delete a name, choose Undo from the Quick Access Toolbar (or press Ctrl+Z) to get the name back.
If you delete the rows or columns that contain named cells or ranges, the names contain
an invalid reference. For example, if cell A1 on Sheet1 is named Interest and you delete row
1 or column A, the name Interest then refers to =Sheet1!#REF! (that is, to an erroneous
reference). If you use Interest in a formula, the formula displays #REF .
The Name Manager is useful, but it has a shortcoming: It doesn’t let you display the list of names in a worksheet
range so you can view or print them. Such a feat is possible, but you need to look beyond the Name Manager.
To create a list of names in a worksheet, i rst move the cell pointer to an empty area of your worksheet. The list is
created at the active cell position and overwrites any information at that location. Press F3 to display the Paste
Name dialog box, which lists all the dei ned names. Then click the Paste List button. Excel creates a list of all names
in the workbook and their corresponding addresses.
Adding Comments to Cells
Documentation that explains certain elements in the worksheet can often be helpful. One
way to document your work is to add comments to cells. This feature is useful when you
need to describe a particular value or explain how a formula works.
To add a comment to a cell, select the cell and use any of these actions:
Choose Review ➪ Comments ➪ New Comment.
Right-click the cell and choose Insert Comment from the shortcut menu.