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.

Is it possible to click in a cell, a drop down appears, then whichever choice is made from the dropdown store that value. I made the dropdown and can place it on a cell but I have a lot of cell that need this dropdown and it looks real ugly with all the dropdown arrows.

share|improve this question
3  
could you please specify what software/tool you are talking about? –  Mat Apr 19 '11 at 14:14
    
What are you talking about? Are you programming? Are you working with excel? Provide more info on the matter please. –  Djerry Apr 19 '11 at 14:16
    
Sorry, I'm new to Superuser... My question relates to Excel 2007. We need a floating dropdown that can plug the result the user picks into the cell on the spread sheet. I was thinking that if the user clicks on a cell (A1) then the dropdown would come up. The user picks from the dropwdown, the value is then saved in A1. Then the user moves onto B1 and the process repeats. –  LtDan Apr 19 '11 at 14:26
    
I have updated title and tags to include Excel –  RedGrittyBrick Apr 19 '11 at 14:38

1 Answer 1

Use Excel's Data Validation feature to create dropdowns in cells. I suggest reading the following tutorial:

http://www.contextures.com/xldataval02.html

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.