Create Drop Down List To Enter Data. The keyboard shortcut to open the Data Validation window is Alt A V V. Create a Drop Down List in a Cell To create a drop down list in Excel you can name a list of items based on a named Excel table.
In the Toolbox click on the Label button. Unlock specific areas of a protected workbookor stop sharing the worksheet and then try step 3 again. In Source type my list name.
Use Excel Data Validation to create a drop-down list.
On the UserForm click to the left of the combobox to add a standard sized label. Click Source button to select the list Items. Unlock specific areas of a protected workbookor stop sharing the worksheet and then try step 3 again. This article explains how to create a drop-down list in Excel that pulls data from a different worksheet.