In many worksheets that you create, users will enter data to get the desired calculations and results. Ensuring valid data entry is an important task. You may want to restrict data entry to a certain range of dates, limit choices by using a list, or make sure that only positive whole numbers are entered. Providing immediate help to instruct users and clear messages when invalid data is entered is also essential to make the data entry experience go smoothly.
Once you decide what validation you want to use on a worksheet, you can set up the validation by doing the following:
- Select one or more cells to validate.
- On the Data menu, click Validation, and then click the Settings tab.
- To specify the type of validation that you want, do one of the following:
