From the cell in which you want the drop-down, select Data > Validation from
the menu bar. You can indicate allowed values (or a range of cells
containing those values), whether to show a drop-down and how to treat
entries not on the list.

"andrew openshaw" wrote:

> can i configure a drop down pick list from a cell.
>
> the combo box from the forms toolbar is not really what i am after