Data Validation

Data validation is a feature that allows you to control the values in a cell. It is useful when providing templates to numerous users, when other cells refer to the value in a certain cell, and when you want to provide an easy way to enter data in a cell. This feature can automatically create a drop down box in the cell so the user can select a value from the list. For example, let's say that you want to restrict the value of a cell to either "Red" or "Blue". Select the cell, and choose "Validation" from the "Data" menu. Choose "List" from the "Allow" box. Enter "Red, Blue" in the "Source" box. Press OK. Now when you select the cell, notice that a drop down box appears, and you can choose one of the two values. You can also provide Input messages and Error messages which are very helpful when distributing your templates to numerous users.

You can also check out this 2 minute video that shows how to set up Data Validation.

Data Validation