Microsoft Office Tutorials and References
In Depth Information
Data Validation: Improving Your Entrée to Data Entry
Figure 6–51. Rather taciturn: A two-character data entry limit
6. Enter 2 in the Length field.
7. Click OK.
What we’ve done here is specify a character-entry limit of 2 for any cell in the range we selected.
That means you’ll only be able to enter exactly 2 characters, no more and no less (and that rule does
allow exactly two-digit numbers), in those cells—and that’s what we want, since we need to insure
that we enter the two-character state abbreviations only and be prevented from accidentally
entering expressions of any other length. If, then, we inadvertently attempt to enter CAL for
California in any cell in the range, we’ll trigger this error message (Figure 6–51):
Figure 6–52. Nice try: Can’t fool Data Validation!
because CAL is three characters. When we retry and type CA, the entry will be accepted.
That’s what Data Validation does: enable the user to establish rules to prevent certain kinds of
unwanted data entry. It can’t , of course, prevent you from entering NY when you wanted to type AZ,
because both expressions meet the two-character requirement here, but it will fend off CAL and C, for