Page 503 - Excel 2013 All-in-One For Dummies

Editing and formatting comments
When you first add a comment to a cell, its Comment box appears to the right of the cell with an arrow pointing to the red triangle in the cell’s upper-right corner. If you need to, you can reposition a cell’s Comment box and/or resize it so that it doesn’t obscure certain cells in the immediate region. You can also edit the text of a comment and change the formatting of the text font.
To reposition or resize a Comment box or edit the note text or its font, you make the cell current by putting the cell cursor in it, and then click the Edit Comment command button, which replaces the New Comment button as the first button in the Comments group on the Review tab of the Ribbon, or press Alt+RT. (You can also do this by right-clicking the cell and then choos- ing Edit Comment from the cell’s shortcut menu.)
Whichever method you use, Excel then displays the cell’s Comment box and positions the insertion point at the end of the comment text. To reposition the Comment box, position the mouse pointer on the edge of the box (indi- cated with cross-hatching and open circles around the perimeter). When the mouse or Touch pointer assumes the shape of a white arrowhead pointing to a black double-cross, you can then drag the outline of the Comment box to a new position in the worksheet. After you release the mouse button, Excel draws a new line ending in an arrowhead from the repositioned Comment box to the red triangle in the cell’s upper-right corner.
When editing and formatting the comments you’ve added to the worksheet, you can do any of the following:
✦ To resize the Comment box, you position the mouse pointer on one
of the open circles at the corners or in the middle of each edge on the box’s perimeter. When the mouse pointer changes into a double-headed arrow, you drag the handle of the Comment box until its dotted outline is the size and shape you want. (Excel automatically reflows the com- ment text to suit the new size and shape of the box.)
✦ To edit the text of the comment (when the insertion point is positioned somewhere in it), drag the I-beam mouse pointer through text that needs to be replaced or press the Backspace key (to remove characters to the left of the insertion point) or Delete key (to remove characters to the right). You can insert new characters in the comment to the right of the insertion point by simply typing them.
✦ Tochangetheformattingofthecommenttext,selectthetextbydragging the I-beam mouse pointer through it, and then click the appropriate com- mand button in the Font and Alignment groups on the Home tab of the Ribbon. (You can use Live Preview to see how a new font or font size,
on its respective drop-down menu, looks in the comment, provided that these drop-down menus don’t cover the Comment box in the worksheet.)
Workbooks on Review 485
Book IV Chapter 3
Sending Workbooks Out for Review