• Excel Book Excerpt

Excel Leave Helpful Notes with Cell Comments

This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Leave Helpful Notes
with Cell Comments

Problem: I have figured out how to write a confusing formula in Excel. I want to add a note to the worksheet to remind myself how the formula works.

LE10001289.jpg 

Figure 1240 Add a note about this formula.

Strategy: You can use cell comment to leave notes in a worksheet. In addition to having 17 billion cells on a worksheet, you can also store a comment for each cell. Typically, a cell comment is indicated by a red triangle in the corner of the cell. If you hover the mouse over the cell, the comment will appear. Here’s how you add comments to a worksheet:

1. Select the cell where you want to add a comment. Select Review, New Comment. A comment box appears, with your name in bold on line 1.

LE10001290.jpg 

Figure 1241 Excel will fill in your name as the comment author.

2. Type a comment.

LE10001291.jpg

Figure 1242 Type a note.

3. Click the mouse outside the comment box to complete the entry of the comment. A red triangle remains in the cell to indicate the presence of a comment there.

LE10001292.jpg

Figure 1243 The red triangle indicates a comment.

When you hover your mouse over the cell with the red triangle, your comment box will pop up like a ToolTip.

LE10001293.jpg

Figure 1244 Hover to show the comment.

Additional Details: To delete a comment, you select the cell and then select Review, Delete. To edit a comment, you select the cell and then Edit Comment will be available in the Review tab.

The information here is based on the assumption that you are using the default settings for comments. There are additional settings available in the Advanced tab of the Excel Options dialog. On this tab, for example, you can suppress the appearance of the red comment indicator or force all comments to be shown at all times.

LE10001294.jpg

Figure 1245 You can hide the red triangles, or always show comment.

Gotcha: If you have a comment in a row above the Freeze Panes line, you will notice a bug. The comment will appear normally if you have scrolled the worksheet to the top. However, if you have scrolled down to other pages in the worksheet, the comment will be truncated.

<-Previous Topic Next Topic->

For more resources for Microsoft Excel:

privacy policy