Helpful Hints Find the best solution!

Drop-down lists in Microsoft Excel

If you would like to make a drop-down list in excel, select a column of cells then go to: Data → Data validation. In the Allow: drop-down choose List, then select source and hit ok.
This tutorial works on all versions of Microsoft Excel.