Microsoft Office Tutorials and References
In Depth Information
Using Data Validation
5. Select criteria such as maximum and
minimum values, or specify a data location. Enter
values or cell addresses. Precede a value with
an equals sign (=) to specify a range name.
When you enter data into a cell that has a
validation requirement, one of two things happens:
If the data meets the validation rules, Excel
accepts the entry and moves to the next cell
6. From the Input Message tab, optionally enter
a comment to display whenever someone
clicks on the validated cell. Think of it as a
If the data does not meet the validation
rules, Excel displays an error message
similar to the one you see in Figure 8-27.
On the Error Alert tab, choose from the Style
drop-down menu whether you want Excel to
warn you or completely stop you from
entering an invalid entry (see Figure 8-26).
Customized error message
Entering invalid data into validated cells.
Depending on the setting chosen when the data
validation rule was set, choose an option:
Stop: Choose Retry or Cancel. You cannot
leave invalid data in the cell. Retry returns
you to the cell where you can change the
value. Cancel deletes your entry and returns
the cell to its previous value.
Determining the action to take when invalid
data entry occurs.
Warning: Choose Yes or No or Cancel.
Choosing Yes retains the value you entered,
choosing No goes back to the cell where
you can change the value, and choosing
Cancel deletes your entry and returns the
cell to its previous value.
Customize Error Message
Information: Choose OK or Cancel.
Choosing OK retains the value you entered,
and choosing Cancel deletes your entry and
returns the cell to its previous values.
On the Error Alert tab of the Data Validation
dialog box, you can customize the error
message Excel displays when an invalid entry is
Figure 8-28 shows a cell where, due to data
validation options, you pick from a list.
8. Click OK.