 |
Select the cell or cells you want to validate. Click here:
 if you don't know how to do this. Use
the Back button on your Browser to return here when you're through.
|
|
Determine how you want to restrict the entry of data. Example: Only numbers between 1 and 100 |
|
Display the Data menu and then select the Validate command. In a few moments, the Data Validation dialog box will display. If necessary, click the Settings tab. |
|
Select a value from the Allow box. Example: Whole Number |
|
Depending on what you’ve selected, other options will become available. Select or fill these in based on your criteria. |
|
If you want, click the Input Message tab and enter any message you want
to display when the cell is selected. Example: Please enter a whole number between 1 and 100. |
|
If you want, click the Error Alert tab and enter any message you want to
display when an invalid entry occurs. Example: Sorry, that entry did not meet the criteria. Please try again. |
|
Click the  button. |