Hi, I am using Excel 2010 in my laptop. I need to send a small form to some of my vendors, but as answers to my questions, I want them to be able to select only from a pre-specified list, that I give them. For this, I want to know how to make a drop down list in Excel 2010.
To create a drop down list in Excel, first you should make a list of items in one column which you want to include in the drop down list.
Then, click on the cell in which you want your drop down list to appear ( when it is clicked). Then, click on data and go to “data validation”. When the data validation opens, click on settings. Then, you will see an “allow” option.
Click allow and in it, look for the option box which says “List” When you click list, you will get an option to choose cells.
Choose the cells containing the contents of your list box.
