How to use drop down lists (data validation) in Excel

Description: You can make a worksheet more efficient by providing drop-down lists. Someone using your worksheet clicks an arrow, and then clicks an entry in the list. Click on the link below to learn more about how best to use and manage them.

Link: https://support.office.com/en-us/article/Create-and-manage-drop-down-lists-28db87b6-725f-49d7-9b29-ab4bc56cefc2?ui=en-US&rs=en-US&ad=US