Excel Drop Down List Creation. To create a drop down list in excel execute the following steps. Enter your drop down list items in your excel workbook preferably in a separate sheet to avoid any accidental changes.
Go to the data tab on the ribbon then click data validation. First if you type a value. However do not include the header cell.
For example if you want your drop down list to include new york boston and los angeles you can type new york in cell a1 boston in cell a2 and los.
To create a drop down list in excel execute the following steps. Make sure you ve entered a heading for your list. Select the range of data input cells step 2 instead of a single excel cell. For example if you want your drop down list to include new york boston and los angeles you can type new york in cell a1 boston in cell a2 and los.
