Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

How would I add a drop down list (or combo box) into a cell on Excel 2010?

share|improve this question
    
Yes, or drop down list, ver 2010. –  Adban Sep 17 '12 at 9:58
    
I edited your question. I suggest you try a Google search. This link currently has video and official Microsoft guides –  Dave Sep 17 '12 at 9:59

3 Answers 3

up vote 2 down vote accepted

Usually the simplest way to achieve that is to:

  • prepare the list next to your table or on other spreadsheet (just input all available values in a column) - it'll be a source for your list of values and it may be hidden later, if you want
  • mark a cell (or a range of cells) in which list should be displayed
  • select Data > Data Validation > Data Validation
  • select Allow: List
  • indicate the list prepared before as a Source
  • confirm

The drop-down list is ready. For combo-box you should use VBA, I believe. But you may also use the method described above and e.g. prepare just two-elements list containing "Yes/No" or "True/False", which is generally the same.

The method should work regardless of Excel's version.

share|improve this answer

This website was very helpful and shows step by step screenshots: http://www.functioninexcel.com/lists-arrays/create-a-dropdown-list/

share|improve this answer
    
Could you add in a small amount of detail into the answer in case the link goes dead? –  jonsca Jul 17 '13 at 18:27

Example: This example will create a vertical range of 10 cells in which each cell can be filled from values selected from a drop down list which will appear in each cell.

Setup: Select or insert a blank sheet into a workbook. Add the following letters to the associated cell locations. A in cell C1 B in cell C2 C in cell C3 D in cell C4 Select the cells A1 to A10 Within the Ribbon Bar, select 'Data, Data Validation, Data Validation' Within the resulting dialog box, select the Settings tab. Within the Settings tab select the following 'Validation criteria:' Allow: List Uncheck Ignore blank Enter C1:C4 for the Source: Select OK With your mouse select a cell in the range of cells A1:A10. A drop down arrow will appear next to any of the cells in the range A1:A10. The dropdown arrow will not appear in any other cell in the sheet.

Demonstrate: Demonstrate the results by selecting various entries in the cells within the range A1:A10.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.