How to Edit Comments in a Worksheet in Excel 2013

To edit the contents of a comment in Excel 2013, select it by clicking the Next or Previous command button in the Comments group of the Review tab and then click the Edit Comment button or right-click the cell with the comment and select Edit Comment from the cell’s shortcut menu. You can also do this by selecting the cell with the comment and then pressing Shift+F2.

To change the placement of a comment in relation to its cell, you select the comment by clicking somewhere on it and then position the mouse pointer on one of the edges of its text box. When a four-headed arrow appears at the tip of the mouse or touch pointer, you can drag the text box to a new place in the worksheet.

When you release the mouse button, finger, or stylus, Excel redraws the arrow connecting the comment’s text box to the note indicator in the upper-right corner of the cell.

To change the size of a comment’s text box, you select the comment, position the mouse or touch pointer on one of its sizing handles, and then drag in the appropriate direction (away from the center of the box to increase its size or toward the center to decrease its size).

When you release the mouse button finger, or stylus, Excel redraws the comment’s text box with the new shape and size. When you change the size and shape of a comment’s text box, Excel automatically wraps the text to fit in the new shape and size.

To change the font of the comment text, select the text of the comment, right-click the text box, and then click Format Comment on its shortcut menu. On the Font tab of the Format Cells dialog box that appears, you can then use the options to change the font, font style, font size, or color of the text displayed in the selected comment.

To delete a comment, select the cell with the comment in the worksheet or click the Next or Previous command buttons on the Review tab of the Ribbon until the comment is selected and then click the Delete command button in the Comments group (Alt+RD). Excel removes the comment along with the note indicator from the selected cell.

You can also delete all comments in the selected range by clicking Clear Comments from the Clear button’s drop-down menu (the one with the eraser icon in the Editing group) on the Home tab of the Ribbon (Alt+HEM).

blog comments powered by Disqus
Advertisement

Inside Dummies.com