Data Validation Excel. Open the data validation dialog box. Create an excel validation rule.
For example you could use data validation to make sure a value is a number between 1 and 6 make sure a date occurs in the next 30 days or make sure a text entry is less than 25 characters. Data validation allow text only data validation allow numbers only this is the best learning resource i have stumbled upon in many years during the process of my excel learning. Create an excel validation rule.
Add an input message.
Create an excel validation rule. On the settings tab in the allow box select list. On the settings tab. For example you could use data validation to make sure a value is a number between 1 and 6 make sure a date occurs in the next 30 days or make sure a text entry is less than 25 characters.
