Forum Discussion
Message displays when selecting a cell
These are actually Data Validations. If you go to Data tab > Data Tools > Data Validation, it'll bring up a menu where you can input your own messages, clear them out of the cells, and option to display the message whenever the cell is selected.
Try it! and Click it!
In Excel for Microsoft 365, you can use Comments to have conversations with others, or use Notes to make annotations.
Add a comment to start a conversation
Right-click a cell and select New Comment.
Enter your comment and select Post.
Others can now reply to continue the discussion.
-----------------------------------------------
Additional Information, please click on it.
Insert comments and notes in Excel
Example in the attached file.
Hope I could help you at least a little.
Nikolino
I know I don't know anything (Socrates)
- These aren't comments or notes, just data validation!
Thank you so much. You are right, this is a very clever use of the data validation. I can think of many great uses for this.
