Data Validation Drop Down List Excel. Turn on data validation for selected cells. Empnames or press the f3 key to see.
Select the cell in the worksheet where you want the drop down list. Enable the developer tab then click insert combo box. On the source click on range selection button select your list range click ok.
On the source click on range selection button select your list range click ok.
Unlock specific areas of a protected workbook or stop sharing the worksheet and then try step 3 again. To create a drop down list start by going to the data tab on the ribbon and click the data validation button. You can either type your data in manually. Go to the data tab on the ribbon then data validation.
