Data Validation

This video introduces how to use data validation to create a drop-down list in Microsoft Excel. A drop-down list ensures that people can only input what you specify in the list.

You can help people work more efficiently in worksheets by using drop-down lists in cells. Drop-downs allow people to pick an item from a list that you create.