bottom
Great ExcelTips!
         
Your e-mail address is safe!
Close Note

Tips.Net > ExcelTips Home > Tools > Comments > Viewing Comments

Viewing Comments

Summary: Comments can be added to individual cells in a worksheet. Excel provides several different ways you can view those comments. This tip discusses the methods and the provides the information you need to pick the best viewing method for your purposes. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

Excel allows you to add comments to the cells in your workbook. At some point you may want to view your comments. Simply follow these steps:

  1. Choose Options from the Tools menu. Excel displays the Options dialog box.
  2. Make sure the View tab is selected. (Click here to see a related figure.)
  3. Select from the three radio buttons in the Comments section of the dialog box. (The meanings of these settings are described shortly.)
  4. Click on OK to close the Options dialog box.

Notice that there are three possible settings for comments. The three radio buttons are as follows:

  • None. This option is selected by default. You can't see any indication of comments in a workbook if this option is selected.
  • Comment Indicator Only. This option results in a small red triangle displayed in the upper-right corner of cells that have comments.
  • Comment & Indicator. With this option selected, the comment indicators (red triangles) still appear, but all the comments in your workbook are visible. If you have a lot of comments, then your screen can appear very cluttered very quickly.

Tip #2856 applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003


Save Time! ExcelTips has been published weekly since late 1998. Past issues of ExcelTips are available in convenient ExcelTips archives. Have your own enhanced archive of ExcelTips at your fingertips, available to use at any time!
 
Check out ExcelTips Archives today!

Helpful Links

Ask an Excel Question
Make a Comment

Tips.Net Home

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

Bugs and Pests Tips
ExcelTips
Family Tips
Health Tips
Home Tips
Organizing Tips
WordTips

Advertise on the
ExcelTips Site

 

Great Info!

Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your e-mail address and click "Subscribe."
     
(Your e-mail address will never be shared with anyone, ever.)