Forum Discussion
steidelh
Jun 26, 2022Copper Contributor
Comment? Note? What is this message?
I downloaded an excel template with the following messages in the table titles. It is not a comment or note. What is it and how do I change, edit or get rid of them? Thanks.
HansVogelaar
Jun 26, 2022MVP
It's the input message of a Data Validation rule.
Select the cell.
On the Data tab of the ribbon. click Data Validation.
On the Settings tab, you'll see that the Allow drop-down has been set to List.
The Source box specifies what the drop-down list in the cell will display.
The Input Message tab contains the text shown in your screenshot. You can either clear the check box in this tab, or edit/clear the text.
- steidelhJun 26, 2022Copper Contributor
HansVogelaar Thank you. That data validation choices was not familiar to me. So, I practiced several conditions to master that part of the ribbon.
Thanks again.
steidelh