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

2 Answers 2

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

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.