Microsoft Office Tutorials and References
In Depth Information
Validate with
DATA ENTRY RULES
You can use data entry rules to ensure that data
entered has the correct format, and you can restrict
the data entered to whole numbers, decimals, dates,
times, or a specific text length. You can also specify
whether the values need to be between, not
between, equal to, not equal to, greater than, less
than, greater than or equal to, or less than or equal
to the values you specify.
As with all data validation, you can create an input
message that appears when the user enters the cell,
as well as an error alert that displays if the user
makes an incorrect entry. Error alerts can stop the
user, provide a warning, or just provide information.
After you create your data entry rule, copy and paste
it into the appropriate cells by using the Paste Special
Validation option. See Task #1 under Paste Your
Validation List to learn how to copy and paste
your data entry rule.
2
1 Click in the cell in which you
want to create a data entry rule.
2 Click the Data tab.
3 Click Data Validation in the Data
Tools group.
l The Data Validation Dialog box
appears.
3
1
4
5
4
Click the Settings tab.
6
5
Click here and select a validation
criterion.
7
6
Click here and select a validation
criterion.
7
Type the criteria or click and
drag to select the cells with the
criteria you want to use.
8
Click the Input Message tab.
9
Type a title for your message.
0
Type an input message.
8
9
0
6
 
Search JabSto ::




Custom Search