Excel Comment – Why and how to add and manipulate it in Excel spreadsheets?



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)


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:

    excel comment



  • 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.

    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.

    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.

    excel format comment dialog box



  • 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.

    Get FREE ebooks!
    (Click for more info)

    Subscribe to...
    MS Office Tips Newsletter

    E-mail Address:
    First Name:
    Then

    Don't worry -- your e-mail address is totally secure.
    I promise to use it only to send you MS Office Tips.

    Can't find what you're looking for? Try Google Search!

    Google
     

    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