SOLVED

Message displays when selecting a cell

%3CLINGO-SUB%20id%3D%22lingo-sub-2436423%22%20slang%3D%22en-US%22%3EMessage%20displays%20when%20selecting%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2436423%22%20slang%3D%22en-US%22%3E%3CP%3EI%20downloaded%20the%20template%20for%20Personal%20Monthly%20Budget.%26nbsp%3B%20They%20have%20a%20feature%20in%20there%20that%20I%20would%20like%20to%20be%20able%20to%20replicate%20in%20some%20of%20my%20own%20files.%26nbsp%3B%20When%20I%20select%20cell%20A2%20a%20message%20is%20displayed%20to%20the%20right%20and%20below%20that%20cell.%26nbsp%3B%20When%20I%20deselect%20the%20cell%20it%20disappears.%20How%20is%20that%20done%3F%20It%20is%20not%20a%20note%20or%20comment.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22denise_955_0-1623349639566.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F287905iA3D4246D09B132FA%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22denise_955_0-1623349639566.png%22%20alt%3D%22denise_955_0-1623349639566.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2436423%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2436556%22%20slang%3D%22en-US%22%3ERe%3A%20Message%20displays%20when%20selecting%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2436556%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1076059%22%20target%3D%22_blank%22%3E%40denise_955%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThese%20are%20actually%20Data%20Validations.%20If%20you%20go%20to%20Data%20tab%20%26gt%3B%20Data%20Tools%20%26gt%3B%20Data%20Validation%2C%20it'll%20bring%20up%20a%20menu%20where%20you%20can%20input%20your%20own%20messages%2C%20clear%20them%20out%20of%20the%20cells%2C%20and%20option%20to%20display%20the%20message%20whenever%20the%20cell%20is%20selected.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22DKoontz_0-1623350606283.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F287911iE78A109D23857788%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22DKoontz_0-1623350606283.png%22%20alt%3D%22DKoontz_0-1623350606283.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2437478%22%20slang%3D%22en-US%22%3ERe%3A%20Message%20displays%20when%20selecting%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2437478%22%20slang%3D%22en-US%22%3EThese%20aren't%20comments%20or%20notes%2C%20just%20data%20validation!%3C%2FLINGO-BODY%3E
New Contributor

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.

denise_955_0-1623349639566.png

 

4 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@denise_955 

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. 

 

DKoontz_0-1623350606283.png

 

@denise_955 

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

  1. Right-click a cell and select New Comment.

  2. 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!

@DKoontz 

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.