Drop Down List

[Ralph M]

I would like to create a drop down list with about 10 names, so when people fill out a form they can choose which name to enter and move on. How would I create the Drop Down List?

[Anne Troy]

Type your names somewhere out of the way. I prefer a second sheet, which I can then hide.

Suppose they're in Sheet2!A2:A11

Select those 10 cells. Hit Insert-Name-Define and type something like NameList.

Go to the cell where you want the dropdown.
Hit Data-Validation. Choose List.
Type =NameList into the box.
Ok.

[Aladin Akyurek]

On 2002-05-22 11:22, Ralph M wrote:
I would like to create a drop down list with about 10 names, so when people fill out a form they can choose which name to enter and move on. How would I create the Drop Down List?

Select the cells containing the names of interest, go the Name Box on the Formula Bar, type e.g., NAMES, and hit enter.

Activate the target cell where you want a selection to be made.
Activate Data|Validation.
Select List for Allow.
Enter in the Source box:

=NAMES

Activate OK.

[wob]

The easiest way is to use validation (Data Menu, Validaton). Type the different options on a seperate section of the sheet first.

Select the option 'list', then choose the options you want the user to have by selecting where the options are kept.

One problem - as far as i know, you can only selected the options by using the mouse - there doesn't seem to be a keyboard shortcut.

[Anne Troy]

Hee hee hee.

[Ralph M]

Thanks EVERYONE!

[wob]

There’s a lot to say for consistency eh…?