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.

Making a drop-down list in Microsoft Excel 2007

Leave a Reply

Your email address will not be published. Required fields are marked *