SOLVED

Excel Note or Comment in Cell - Can't figure out how it was entered

Copper Contributor

 

Screenshot 2024-08-22 070121.png

 

I downloaded an excel template from create.microsoft.com. In cel 'A1', when I click that cell, a note/comment pops up. See attached image. If Im not in the cell this note/comment disappears. Normally when you enter a note/comment, when you are not in the cell there is a visual indication that a note/comment exists in that cell(i.e. for a note it is a red right pointing triangle in the upper right of the cell). when you hover over that cell the note appears. when you take your mouse away from that cell the not disappears.

 

However the note or comment in cell 'A1' doesn't have that behavior. this note or comment only appears when you click in the cell. when I right click the cell, the only option is for a new comment or new note. 

Im trying to figure out what this feature is in cell 'A1' to behave this way. Is this a note or a comment?

Whatever it is, where do I go to edit this or create another one just like it in another cell. BTW, this template, has the same feature in other cells. When I click other cells, another note/comment appears alerting the user what to input into the cell.
This is not a macro enabled workbook, so I know its not a macro.

Does anyone know how this is created and how to edit it?

2 Replies
best response confirmed by HansVogelaar (MVP)
Solution

@KeithAul  I think this is the input message option of Data Validation:

m_tarler_0-1724328725688.png

 

Thank you. That was the answer.
1 best response

Accepted Solutions
best response confirmed by HansVogelaar (MVP)
Solution

@KeithAul  I think this is the input message option of Data Validation:

m_tarler_0-1724328725688.png

 

View solution in original post