Excel - Creating drop Down Lists in Cells
Creating A Drop Down Lists For Users to Choose From In Excel
When you design an Excel workbook for users other than yourself to use you may find that it is helpful to provide drop down lists for some column values such as Status Codes, Categories, Response Codes, etc. This is surprisingly easy in Excel and requires no clever VBA code!
In the following example we can see a drop list that a user can choose from when populating a Country column value.