Jun 10 2021 11:30 AM
I downloaded the template for Personal Monthly Budget. They have a feature in there that I would like to be able to replicate in some of my own files. When I select cell A2 a message is displayed to the right and below that cell. When I deselect the cell it disappears. How is that done? It is not a note or comment.
Jun 10 2021 11:44 AM
SolutionThese 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.
Jun 10 2021 11:54 AM
In Excel for Microsoft 365, you can use Comments to have conversations with others, or use Notes to make annotations.
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)
Jun 10 2021 04:42 PM
Jun 14 2021 06:13 AM
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.
Jun 10 2021 11:44 AM
SolutionThese 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.