The information here is based on the assumption that you are using the default settings for comments. To edit a comment, you select the cell and then Edit Comment will be available in the Review tab. When you hover your mouse over the cell with the red triangle, your comment box will pop up like a ToolTip.Īdditional Details: To delete a comment, you select the cell and then select Review, Delete. A red triangle remains in the cell to indicate the presence of a comment there. A comment box appears, with your name in bold on line 1.

Here's how you add comments to a worksheet: If you hover the mouse over the cell, the comment will appear. Typically, a cell comment is indicated by a red triangle in the corner of the cell. In addition to having 17 billion cells on a worksheet, you can also store a comment for each cell. Strategy: You can use cell comment to leave notes in a worksheet. I want to add a note to the worksheet to remind myself how the formula works. Problem: I have figured out how to write a confusing formula in Excel.