Microsoft Office Tutorials and References
In Depth Information
TIP You can also manage comments by right-clicking a cell that contains a comment and
then using the commands on the shortcut menu.
IMPORTANT When someone other than the original user edits a comment, that person’s
input is marked with the new user’s name and is added to the original comment.
You can control whether a cell displays just the comment indicator or the indicator and
the comment itself by clicking a cell that contains a comment and then, on the Review tab,
clicking the Show/Hide Comment button. Clicking the Show/Hide Comment button again
reverses your action. If you’ve just begun to review a worksheet and want to display all of
the comments on the sheet, display the Review tab and click the Show All Comments
button. To move through the worksheet’s comments one at a time, click the Previous or Next
In this exercise, you’ll add comments to two cells. You will then highlight the cells that
contain comments, review a comment, and delete that comment.
SET UP You need the ProjectionsForComment workbook located in the Chapter14
practice file folder to complete this exercise. Open the workbook, and then follow the
Click cell E6 .
On the Review tab, in the Comments group, click New Comment . When you do, a
red comment lag appears in cell E6 and a comment box appears next to the cell.