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.


-----Original Message-----
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?
.