pull down menu

[ben]

I am entering data into a field and would like a cell to
contain a pull-down menu to select from. For example on a
certain cell it would have a little arrow on the side and
then you could choose option 1, option 2, etc... Does
anyone know if this is possible?

 

[Gord Dibben]

Ben

Data Validation will do the trick.

For info and instructions see Debra Dalgleish'a site.

http://www.contextures.on.ca/xlDataVal01.html

Gord Dibben Excel MVP

 

[erin]

On the data menu, click validation, then click settings.
In the allow box, click list, enter a reference to your
list in the source box (precede reference by =). Select
in-cell drop-down check box. Specify whether the cell can
be left blank. You can also specify instructions and/or
error message if invalid data is entered.

 

[R-Enemy]

Which Excel do you have? I have 2002 and looked all over
trying to do the same thing but I don't think it's
possible.
I was looking at the Excel 2003 website and it says that
it has this feature.