Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
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. – Terry 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

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

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .