drop down box in a cell

[excelqueen]

is it possible to do so? i am trying to collect some data from 20 people and in order to avoid typos i want to convert the cells into drop down boxes so that people just select rather than type.

i don't want to use the drop down button from toolbox since i want the data to be stored in the cell so that i can sort/compute it later.

Any help will be much appreciated! Thanks.

 

[Mudface]

Sounds like you could use Data Validation for this. On a separate sheet, type in the values that you want to see in the drop down. Select them, click on Insert- Name -Define and call your list something like 'mylist'. On the sheet where you want the dropdowns to appear, select the appropriate cells, click on Data- Validation and change the Allow dropdown to 'List'. In the source box, type in

=mylist

Make sure In-Cell Dropdown is selected and that should do it.