Results 1 to 4 of 4

Thread: Topic 32: Adding and Customizing Excel Comments

  1. #1
    Administrator
    Join Date
    Oct 2009
    Posts
    5,607
    Rep Power
    10

    Topic 32: Adding and Customizing Excel Comments

    Advertisement

    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 barAdvertisement

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

  2. #2
    Administrator
    Join Date
    Oct 2009
    Posts
    5,607
    Rep Power
    10
    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.

  3. #3
    Administrator
    Join Date
    Oct 2009
    Posts
    5,607
    Rep Power
    10
    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.

  4. #4
    Administrator
    Join Date
    Oct 2009
    Posts
    5,607
    Rep Power
    10
    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.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •