Microsoft Office Tutorials and References
In Depth Information
Adding Data Entry Rules
Adding Data Entry Rules
The Data Validation Allow field lets you to install a data entry rule, with the same Data drop-down
operators (greater than, equal to, etc.) for these data types:
Any Value—which really institutes no restriction
Whole number—allows you to restrict data entry via the operators to whole
numbers alone, e.g., numbers between 10 and 20. Here you’d be able to enter 12
or 17, but not 17.6.
Decimal—allowing you to restrict data entry via the operators that permit decimal
entry. Thus if the rule restricted entry to values between 10 and 20, you’d be able
to enter 12 and 17 as well as 17.6—but not 34 or 34.1, as both exceed 20.
Date—allows you to restrict data entry via the operators to dates equaling a
particular date, or to a dates falling between two dates, etc.
Time—allows you to restrict data entry via the operators to times, such as between
10:00 and 12:00, etc.
Text Length—as discussed.
There are two additional Data Validation Allow options, List and Custom . List is a rather neat
feature, giving you the option to construct a drop-down menu of data entry choices.
To explain: suppose I want to be able to enter the names of any of my five salespersons down a
range, say A1:A20, by selecting these from a drop-down menu.
1.
First, enter the salesperson names in any range, e.g., P19:P23 (Figure 6–52):
Figure 6–53. These names will appear in your customized drop-down menu, or list.
2.
Then select A1:A20.
3.
Then click Data Validation Allow List. You’ll see: (Figure 6–53):
 
Search JabSto ::




Custom Search