Part I: Getting Started with Excel
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! (an erroneous reference). If
you use the name Interest in a formula, the formula displays #REF!.To create a list of names in a worksheet, first select a cell in 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 of the defined names, and 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.
■ (^) Press Shift+F2.
Excel inserts a comment that points to the active cell. Initially, the comment consists of
your name, as specified in the General tab of the Excel Options dialog box (choose File ➪
Options to display this dialog box). If you like, you can delete your name from the com-
ment. Enter the text for the cell comment and then click anywhere in the worksheet to
hide the comment. You can change the size of the comment by clicking and dragging any of
its borders. Figure 4.16 shows a cell with a comment.
Cells that have a comment display a small red triangle in the upper-right corner. When you
move the mouse pointer over a cell that contains a comment, the comment becomes visible.
You can force a comment to be displayed even when the mouse is not hovering over the
cell. Right-click the cell and choose Show/Hide Comments. Although this command refers
to “comments” (plural), it affects only the comment in the active cell. To return to normal
(make the comment appear only when its cell is activated or the mouse pointer hovers over
it), right-click the cell and choose Hide Comment.