Excel 2007 Tips: How to add Comment to your worksheet
A comment is a bit of descriptive text that enables you to document your work when you add text or create a formula. If someone else maintains your worksheet, or others use it in a workgroup, your comments can provide useful information.
In Excel, Comments do not appear by default until you choose to view them. Below are few steps that i going to show your how to add comment, delete comment, edit comment and view it.
Add Comment
- Click in the cell to which you want to add a comment.
- Click the Review tab.
- Click New Comment in the Comments group.
- A comment box appears.
- A tiny red triangle appears in the upper-right corner of the cell.
- Type your comment.
- Click outside the comment box when you finish. The comment box disappears.
- Move the cursor over the cell to display your comment again.
How to edit/delete your comment
- Select the cell to with comment
- Click Edit Comment in the Comments group to edit a comment.
- Click Delete in the Comments group to delete a comment.
How to display All Comments
- Click Show All Comments in the Comments group.
- You can now see all the comments in the worksheet.
- To close the comment boxes, click Show All Comments again.
- To cycle through comments click Previous or Next in the Comments group.
Tips
When a comment gets in the way of another comment or blocks data, you can move it. Position your cursor over the comment box border until the arrow turns into a four-sided arrow. Click and drag the comment to a better location and then release the mouse button. Your comment remains in this position until you display all comments again
Comments
Leave a Reply
