When you’re ready to hide the data validation circles, click Clear Validation Circles in the
Data Validation list.Of course, it’s frustrating if you want to enter data into a cell and, when a message box
appears that tells you the data you tried to enter isn’t acceptable, you aren’t given the
rules you need to follow. With Excel, you can create a message that tells the user which
values are expected before the data is entered and then, if the conditions aren’t met,
reiterate the conditions in a custom error message.
You can turn off data validation in a cell by displaying the Settings page of the Data
Validation dialog box and clicking the Clear All button in the lower-left corner of the
dialog box.Defining Valid Sets of Values for Ranges of Cells 363