What is Data Validation, and how does it work?
The data validation tool in Microsoft Excel allows you to limit what can be entered in your worksheet. You can, for example:
restrict entries, such as a date range or entire integers, by creating a drop down list of objects in a cell Make specific rules for what can be entered exclusively.
What Is a Drop Down List and How Do I Make One?
You can build a dropdown list of options in a cell using Data Validation. There are three simple steps to follow:
1. Make a table of contents OR a list
2. Give the List a Name
3. Make the drop-down menu
Data validation is not without flaws. It can be avoided by pasting data into the cell or using the Ribbon's Home tab's Clear > Clear All option.