drop down box in a cell

excelqueen · May 3rd, 2002, 01:52 AM

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 · May 3rd, 2002, 03:34 AM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 3rd, 2002, 01:52 AM	#1
excelqueen New Member Join Date: May 2002 Posts: 18	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.

May 3rd, 2002, 03:34 AM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	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.