Contextures

Excel Comments - Basics

Add Excel comments to worksheets cells, to explain the contents, or to offer tips to users

Insert an Excel Comment

  1. Right-click the cell in which you want the comment.
  2. Click Insert Comment
  3. Type your comment where the cursor is flashing.
  4. Text will wrap automatically. If you want to start a new line, press the Enter key.
  5. When finished, click outside the comment box

insert comment

Display a Specific Comment

  1. Right-click the cell which contains the comment.
  2. Choose Show/Hide Comments

To hide the comment:

  1. Right-click the cell which contains the comment.
  2. Click Hide Comment

hide comment

Display All Comments

  1. On the Excel Ribbon, click the Review tab
  2. In the Comments group, click Show All Comments
    Note
    : All comments in all open workbooks will be displayed.
  3. To hide the comments, click the Show All Comments command again.

show all comments

Format Text in an Excel Comment

You can change the font, the font size, font colour and font style, for all or part of an Excel comment.

  1. Right-click the cell which contains the comment.
  2. Choose Edit Comment
  3. To format all text, click on the border of the comment shape.
    To format specific text within the comment, drag over the text to select it.
  4. Use the Font tools on the Formatting toolbar to modify the text appearance
  5. When finished, click outside the comment box.

show all comments

Printing Excel Comments

You can print Excel comments as displayed on the worksheet, or print them at the end of the worksheet

To print comments in Excel 2007, see the video quick tips tutorial: Printing Comments in Excel 2007

To print as displayed:

  1. Show specific comments or all comments.
  2. On the Excel Ribbon, click the Page Layout tab
  3. In the Page Setup section, click the Dialog Launcher at the bottom right

    page layout dialog launcher

  4. On the Sheet tab, from the Comments dropdown, choose 'As displayed on sheet'.

    print comments as displayed

  5. Click Ok
  6. Choose File|Print (or click the Print button)

display comments

To print at the end of the worksheet:

  1. Choose File|Page Setup
  2. On the Sheet tab, from the Comments dropdown, choose 'At end of sheet'.
  3. Click Ok
  4. Choose File|Print (or click the Print button)

print comments

To print a worksheet with comment indicators:

See instructions in Comments -- Programming

Related Tutorials

Excel Comments -- Tips

Excel Comments -- VBA

Search Contextures Sites

 

 

 

 

 

Excel Data Entry Popup List

 

 

 

Excel UserForms for Data Entry

 

Last updated: June 17, 2016 6:47 PM