Now we’ll click back on the spreadsheet ‘Questionnaire’ and create our first drop-down list.Ĭlick into the cell in which you want to create the drop-down menu. I myself added a new spreadsheet, named it ‘Months’, and made a list of months that’ll be used for our drop-down menu. So, if you want to make a drop-down menu with more options, it might be a good idea to create the list somewhere else, for example in a different spreadsheet. The answer to the first question will be a specific month of the year. How to Create a Longer Drop-Down List in Excel Those will be possible answers to our second question.īut let’s start from the beginning now. I’ll show you a way how to create a short drop-down list with only two items – ‘Yes’ and ‘No’.

Then we’ll try something a little bit different. They’ll become our options for the answer to the first question. What we can use for drop-down items here are the months of the year. We’ll use this short questionnaire to see how simple it is to create a drop-down menu and you’ll be able to use these steps to create a list with any data you need.įirst, we’ll have a look at how to create a longer drop-down list with more options. 2 How to Create a Short Drop-Down List in Excel

Creating drop down menu in excel 2016