• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 3. Editing Worksheets > Adding and Viewing Cell Comments

Adding and Viewing Cell Comments

Right-click the cell to which you want to add a comment, and choose Insert Comment from the shortcut menu that appears.

Type the desired text into the comment area. When you're finished, click anywhere in the worksheet to accept the comment.

The cell's upper-right corner now contains a red triangle, indicating the presence of a comment. To view the comment, move the mouse pointer over the triangle.

The comment appears as a ScreenTip. To remove it from view, simply move the mouse pointer away from the triangle.

INTRODUCTION

Some cells contain data or formulas that require an explanation or special attention. Comments provide a way to attach this type of information to individual cells without cluttering the cells with extraneous information. A red triangle indicates that a cell contains a comment, which you can view in several different ways.


TIP

Displaying comments

You can make it so that Excel automatically displays the full text of a cell's comments while you work in the worksheet. To do so, right-click the commented cell and choose Show/Hide Comment from the shortcut menu that appears. To re-hide the comment, right-click the commented cell and choose Hide Comment.


  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint