Excel Comments - Basics

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

Note: Threaded Comments are being added to Excel, and some Legacy Comment features are not available in Threaded Comments.

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

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

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.

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.

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

   

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

   

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

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)

To print a worksheet with comment indicators:

See instructions in Comments -- Programming

Related Tutorials

Excel Comments -- Tips

Excel Comments -- VBA

Add Comments in a Pivot Table