First create a list of selections somewhere in the worksheet.
then select the cell you wish to have the drop down list.
then go to Data tab, Data Validation, select List
then click on the red arrow below the word 'source' and select your list
created previously. and click OK. you r done
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.