Search Contextures Sites

Related Tutorials

Excel Comments -- Tips

Excel Comments -- VBA

Contextures
Excel news
by email

 

 

 

 

30 Excel Functions in 30 Days

 

Learn how to create Excel dashboards.

 

 

Learn how to create Excel dashboards.

 

 

Time-saving
Pivot Table add-in

 

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. format comment text

  5. Use the Font tools on the Formatting toolbar to modify the text appearance
  6. formatting toolbar

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

  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

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

 

 

Privacy Policy

 

Contextures Inc., Copyright 2014
All rights reserved.