Excel Comment – Why and how to add and manipulate it in Excel spreadsheets?
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)
To insert a Comment using menu bar methodSelect 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 methodPoint 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 CommentRight-click the cell which contains the comment. Choose Show/Hide Comment.
To hide the CommentRight-click the cell which contains the comment. Choose Hide Comment.
To edit the CommentRight-click the cell which contains the comment. Choose Edit Comment.Retype your comment.
To delete the CommentRight-click the cell which contains the comment. Choose Delete Comment.
To change the Comment ShapeRight-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.
To change the others Comment attributeRight-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.
Can't find what you're looking for? Try Google Search!
Back to Top
>> Next Topic : Discover the Amazing Power of Excel 2003 Data Analysis Tools!
<< Previous Topic : Knowing the Excel Date and Time Functions!
You're viewing the Excel Comment info page, click here to go back to the Home Page