Search Contextures Sites
Custom Search

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.

 

 

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. 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

Use the Excel 2003 Reviewing Toolbar

If you're doing extensive work with comments in Excel 2003, 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.

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

  1. Click Ok
  2. 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 2015
All rights reserved.