Page 135 - Excel 2007 Bible

09_044039 ch05.qxp 11/21/06 10:56 AM Page 92
Part I
Getting Started with Excel
An Alternative to Cell Comments
ou can make use of Excel’s Data Validation feature to add a different type of comment to a cell. This type
Yof comment appears automatically when the cell is selected. Follow these steps:
1. Select the cell that will contain the comment.
2. Choose Data ➪ Data Tools ➪ Data Validation to display the Data Validation dialog box.
3. In the Data Validation dialog box, click the Input Message tab.
4. Make sure that the Show Input Message When Cell Is Selected check box is checked.
5. Type your comment in the Input Message box.
6. As an option, type a title in the Title box. (This text will appear in bold at the top of the message.)
7. 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 affect by any of the commands used to work with cell comments. In
addition, you can’t format these messages in any way.
Changing a comment’s shape
Normally, a cell comment is rectangular, but they don’t have to be. To change the shape of a cell comment,
add a command to your Quick Access Toolbar (QAT):
1. Right-click the QAT and select Customize Quick Access Toolbar. The Customization section
of the Excel Options dialog box appears.
2. In the drop-down list labeled Choose Commands From, select Drawing Tools | Format Tab.
3. In the list on the left, select Change Shape and click the Add button.
4. Click OK to close the Excel Options dialog box.
After performing these steps, your QAT has a new Change Shape icon.
To change the shape of a comment, make sure that it’s visible (right-click the cell and select Show/Hide
Comments). Then click the comment’s border to select it as a Shape (or, Ctrl+click the comment to select it
as a Shape). Click the Change Shape button on the QAT and choose a new shape for the comment. Figure
5.17 shows a cell comments with a nonstandard shape.

92