Excel's data validation tool lets you restrict a cell's inputs so that they meet certain criteria. This helps to prevent errors. As you can see, this will prevent any errors from occurring.
office.com/setup365 - This page contains data validation tips and shows you how to fix Excel data validation issues such as dropdown not working, blank selected and not showing all items. These videos and the written steps will assist you in troubleshooting data validation dropdown list problems.
