Validate data in a cell or a range:
- Choose one or more cells to verify.
- Select Data Validation from the Data Tools group on the Data tab.
- Select List in the Allow box on the Settings tab.
- Type your list values in the Source field, separated by commas.
- Make sure the In-cell dropdown check box is turned on.
Share a personalized message with your friends.