Chapter 13. SHARING YOUR WORKBOOK WITH OTHERS
Validate with a Validation List
In Excel, you can restrict the values a user can enter into a cell. By restricting values, you help ensure that all worksheet entries are valid and that calculations based on them are valid as well. During data entry, a validation list forces anyone using your worksheet to select a value from a drop-down list rather than typing and potentially entering the wrong information. Validation lists save time and reduce errors.
There are two methods that you can use to create a data validation list. First, if your list is short and does not change, you can type your list into the Source field of the Data Validation dialog box. For example, if your field collects gender, you can ...