Create A Data Validation List In Excel. Open the data validation dialog box. In this example the range is named productlist.
Add an input message. Go to the worksheet and click in the cell where you want the drop down list to appear. Create the first named range and drop down list as described above.
If you can t click data validation the worksheet might be protected or shared.
Add an input message. Go to the worksheet and click in the cell where you want the drop down list to appear. Select the cell in the worksheet where you want the drop down list. How to create a drop down data validation list.
