SOLVED

Insert and delete comment floanting.

%3CLINGO-SUB%20id%3D%22lingo-sub-2354534%22%20slang%3D%22en-US%22%3EInsert%20and%20delete%20comment%20floanting.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2354534%22%20slang%3D%22en-US%22%3E%3CP%3EGood%26nbsp%3Bmorning!%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22Y2IQFc%22%3EI%20would%20like%20to%20know%20how%20to%20include%20and%20exclude%20the%20comment%20linked%20to%20cell%20C3.%3C%2FSPAN%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2354534%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2354941%22%20slang%3D%22en-US%22%3ERe%3A%20Insert%20and%20delete%20comment%20floanting.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2354941%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1053824%22%20target%3D%22_blank%22%3E%40TFRodrigues%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHave%20you%20tried%20clicking%20New%20Comment%20on%20the%20Review%20tab%20of%20the%20ribbon%20while%20C3%20is%20selected%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2371641%22%20slang%3D%22en-US%22%3ERe%3A%20Insert%20and%20delete%20comment%20floanting.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2371641%22%20slang%3D%22en-US%22%3EYes%2C%20but%20didn't%20work.%20The%20annotation%20is%20as%20if%20it%20were%20not%20from%20excel.%20In%20the%20formula%20tutorials%2C%20there%20is%20a%20similar%20annotation%20%2F%20comment.%20I%20disabled%20the%20option%20not%20to%20display%20the%20annotation%2C%20which%20displays%20a%20red%20triangle%2C%20but%20did%20not%20reflect%20that%20type.%20It%20is%20also%20not%20a%20VBA.%20It%20is%20a%20message%20that%20appears%20when%20you%20hover%20over%20the%20cell%20or%20click%20on%20it.%3C%2FLINGO-BODY%3E
New Contributor

Good morning!

I would like to know how to include and exclude the comment linked to cell C3. 

4 Replies

@TFRodrigues 

Have you tried clicking New Comment on the Review tab of the ribbon while C3 is selected?

Yes, but didn't work. The annotation is as if it were not from excel. In the formula tutorials, there is a similar annotation / comment. I disabled the option not to display the annotation, which displays a red triangle, but did not reflect that type. It is also not a VBA. It is a message that appears when you hover over the cell or click on it.

@TFRodrigues 

It is the Input Message of Data Validation.

Select the cell.

Activate the Data tab of the ribbon,

Click Data Validation in the Data Tools group.

Activate the Input Message tab.

You can remove the data validation rule if you wish by clicking Clear All.

 

S0428.png

best response confirmed by TFRodrigues (New Contributor)
Solution
Thank you so much!