• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 3. Using Excel > Task 24 How to Add a Comment

Task 24 How to Add a Comment

If you share your Excel workbooks with other people, you might want to add comments to the data from time to time, to explain a particular figure or to request that a change be made. Comments are not visible in a cell; instead, small red triangles mark the cells that contain comments. You can use the mouse pointer to display a comment, or you can display all comments in one step. You can print comments along with worksheet data when that kind of documentation is needed.

  1. Select a Cell

    Select the cell to which you want to add a comment.



  2. Insert a Comment

    Open the Insert menu and select Comment. A yellow box appears next to the cell you selected.



  3. Type the Comment Text

    Type your comment into the yellow box.



  4. Click Outside the Box

    When you're through typing, click outside the comment box. The comment disappears, but a red triangle in the upper-right of the cell you selected in Step 1 marks the presence of the comment.



  5. View a Comment

    To view a comment, rest the mouse pointer over the cell containing the red triangle. The yellow box and its comment pop up for viewing.



  6. View All Comments

    To view all the comments that have been added to the worksheet at one time, choose View, Comments.




PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint