Topic 32: Adding and Customizing Excel Comments

[seema]

Excel Comment is basically short notes that can be inserted into any cell in Excel. You cannot see it if you do not click on the comment. It’s useful for reminders, notes for others, or for cross-referencing other workbooks.

Adding comment to worksheets cells are a great way to explain the cell contents, formulas, offer tips to users or other data in the spreadsheet.
Basically there are three ways to add a comment:

1) Using Menu bar
2) Using mouse right-click
3) Using Reviewing toolbar (not explain here)

Similar Threads:

• Topic 25: Use the Excel OR() Function Correctly
• Topic 23: Using COUNT() Function in Excel
• Topic 20: Excel AND() Function
• Topic 18: How to Create an Excel Pie Chart?
• Topic 16: Using the Excel CHOOSE() Function

[seema]

To insert a Comment using menu bar method

Select the cell in which you want the comment. From the Insert menu, click on Comment. You can see something like this: Type your comment where the cursor is flashing. Text will wrap automatically. If you want to start a new line, press the Enter key. When finished, click any cell outside the comment box. To insert a Comment using right-click method Point to the cell in which you want the comment. Right-click on the cell and click Insert Comment. Type your comment where the cursor is flashing. When finished, click any cell outside the comment box. To display a specific Comment Right-click the cell which contains the comment. Choose Show/Hide Comment.

[seema]

To hide the Comment

Right-click the cell which contains the comment. Choose Hide Comment. To edit the Comment Right-click the cell which contains the comment. Choose Edit Comment. Retype your comment. To delete the Comment Right-click the cell which contains the comment. Choose Delete Comment. To change the Comment Shape Right-click the cell which contains the comment. Choose Edit Comment. Click on the border of the comment, to select it. On the Drawing toolbar, click the Draw icon, point to Change AutoShape, and choose a category. Click on a shape to select it. When finished, click outside the comment.

[seema]

To change the others Comment attribute

Right-click the cell which contains the comment. Choose Edit Comment. Click on the border of the comment, to select it. From the Format menu, click Comment. From the Format Comment dialog box displayed, click on the specific tab to change the necessary settings. You can change the comment font and background color, font size and effects, alignment, margin, etc. When finish, click OK.