Forum Discussion
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.
3 Replies
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.
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
- Thanks to Denise_955 and DKoontz for the discussion on June 10 2021
Data Validation Message Input.
Wow!
