Microsoft Office Tutorials and References
In Depth Information
Establishing Data-Validation Rules
Follow these steps to establish a data-validation rule:
1. Select the cell or cells that need a rule.
2. On the Data tab, click the Data Validation button.
As shown in Figure 1-10, you see the Settings tab of the Data Validation
3. On the Allow drop-down list, choose the category of rule you want.
Table 1-1, earlier in this chapter, describes these categories.
4. Enter the criteria for the rule.
What the criteria is depends on what rule category you’re working in.
Table 1-1 describes how to enter the criteria for rules in each category.
You can refer to cells in the worksheet by selecting them. To do that,
either select them directly or click the Range Selector button and then
5. On the Input Message tab, enter a title and input message.
You can see a title (“Quit Sluffing Off”) and input message (“Enter a number
between 24,000 and 32,000”) in Figure 1-9. The title appears in boldface.
Briefly describe what kind of data belongs in the cell or cells you selected.
6. On the Error Alert tab, choose a style for the symbol in the Message Alert
dialog box, enter a title for the dialog box, and enter a warning message.
In the error message in Figure 1-9, shown previously, the Stop symbol
was chosen. The title you enter appears across the top of the dialog box,
and the message appears beside the symbol.
7. Click OK.
To remove data-validation rules from cells, select the cells, go to the
Data tab, click the Data Validation button, and on the Settings tab of the
Data Validation dialog box, click the Clear All button, and click OK.