Part I: Getting Started with Excel
98
Editing comments .....................................................................................................
To edit a comment, activate the cell, right-click, and then choose Edit Comment from the shortcut
menu. Or, select the cell and press Shift+F2. After you make your changes, click any cell.Deleting comments ...................................................................................................
To delete a cell comment, activate the cell that contains the comment and then choose Review ➪
Comments ➪ Delete. Or, right-click and then choose Delete Comment from the shortcut menu.You can make use of Excel’s Data Validation (covered in Chapter 25) feature to add a different type
of comment to a cell. This type of comment appears automatically when the cell is selected. Follow
these steps:- Select the cell that will contain the comment.
- Choose Data ➪ Data Tools ➪ Data Validation to display the Data Validation dialog box.
- Click the Input Message tab.
- Make sure that the Show Input Message When Cell Is Selected check box is selected.
- Type your comment in the Input Message box.
- As an option, type a title in the Title box. (This text will appear in bold at the top of the
message.) - Click OK to close the Data Validation dialog box.
After performing these steps, the message appears when the cell is activated, and it disappears when
any other cell is activated.Note that this message isn’t a “real” comment. For example, a cell that contains this type of message
doesn’t display a comment indicator, and it’s not affected by any of the commands used to work with
cell comments. In addition, you can’t format these messages in any way.An Alternative to Cell Comments