PDA

View Full Version : [SOLVED:] Message in Every Cell



Sarfaraz
08-02-2017, 09:31 PM
Hi,
I have downloaded an excel template from Microsoft (file attached). In it I have noticed a new thing which I tried to hard to find on net and tried to resolved myself but couldn't. Whenever you select a cell it give you a message what is the purpose of this cell. I actually want to use this feature in my another worksheet. Like if I select Cell D10 it gives a message "Automatically calculate percent weight loss". Same it the case with other cells.
I look for a help that how could I use this feature in my other excel files.

Regards

Bob Phillips
08-03-2017, 12:06 AM
The guy is using Data Validation (Data>Data Tools>Data Validation) with a type of ANY (that is, not restricting the input), and an input message. I frequently use this technique, but with validation on the cell as well, such as a pick list, number bounds, etc.

Sarfaraz
08-03-2017, 12:32 AM
Great, it worked, thanks a lot xld.