Microsoft Office Tutorials and References
In Depth Information
Working with Range Names
8. Choose one of the following error message
styles from the Style drop-down menu.
Using Data Validation
Excel provides two other useful data validation
features. The first shows you all of the cells in
your spreadsheet that have validation
restrictions. The second shows you all of the cells that
contain invalid data.
Style
Purpose
Stop
Prevents users from entering
any invalid data. Displays an
error message with Retry or
Cancel options. Stop is the
most restrictive error message.
Choose Home > Editing > Find & Select >
Data Validation. All cells with any kind of
validation restrictions will be highlighted, as
if you had selected them with the mouse.
Warning
Warns users that they have
entered invalid data, but does
not prevent them from doing
so. Displays an error message
with Yes (to accept the invalid
entry), No (to edit the invalid
entry), or Cancel (to remove
the invalid data) options.
Choose Data > Data Tools > Data
Validation (arrow). Choose Circle Invalid
Data. Excel will place a red circle (see
Figure 1-31) around any cells that contain
invalid data. Choose Data Validation
(arrow) and then Clear Validation Circles
to remove the red circles.
Information
Informs users that they have
entered invalid data, but does
not prevent them from doing
so. Displays an error message
with OK (to accept the invalid
entry) or Cancel (to remove the
invalid entry). Information is
the most flexible error message.
9. Click OK to close the Data Validation dialog
box.
Figure 1-31
Excel shows you which cells contain validation errors.
Removing Data Validation
To remove data validation from a selected
cell or cell range, choose Data > Data Tools
> Data Validation. Click the Clear All button
in the Data Validation dialog box and click
OK to accept the change.
 
Search JabSto ::




Custom Search