Search Contextures Sites

Excel Comments -- Basics

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

Insert an Excel Comment
Display a Specific Comment
Display All Comments
Use the Reviewing Toolbar
Format Text in a Comment
Printing Excel Comments
Excel Comments -- Tips
Excel Comments -- VBA

 


Insert an Excel Comment

  1. Select the cell in which you want the comment.
  2. Choose 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 Comment

  To hide the comment:

  1. Right-click the cell which contains the comment.
  2. Choose Hide Comment
 
 show excel comment


Display All Comments

  1. Choose View|Comments
    Note    : All comments in all open workbooks will be displayed.

  2. To hide the comments, choose View|Comment
 
 display all comments


Use the Reviewing Toolbar

If you're doing extensive work with Excel comments, you might save time by using the Reviewing Toolbar. Use its buttons, instead of choosing commands from the Menu Bar.
  1. To open the Reviewing toolbar, choose View|Toolbars
  2. If the active cell contains a comment, the Reviewing Toolbar displays the following Comment buttons:

    a) Edit comment     b) Previous comment   c) Next comment
    d) Show comment  e) Show all comments  f) Delete comment

reviewing toolbar
 
 
  1. If the active cell does not contain a comment, the Reviewing Toolbar displays the following Comment buttons:

    a) New comment   b) Previous comment   c) Next comment
    d) N/A                  e) Show all comments  f) N/A

no comment toolbar

  


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.

 

  format comment text

 formatting toolbar


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. Choose File|Page Setup
  3. On the Sheet tab, from the Comments dropdown, choose 'As displayed on sheet'.
  4. Click Ok
  5. 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

 
 print excel comment

display comments

print comments

  1. Excel Comments -- Basics
  2. Excel Comments -- Tips
  3. Excel Comments -- VBA

       Home     Excel Tips     Excel Files     The Excel Store     Blog     Contact

 

Privacy Policy

 

Contextures Inc., Copyright ©2012
All rights reserved.