As mentioned by tjtjjtjt, think
data validation (DV) could be what you're after ..

Try Debra Dalgleish's nice coverage on DV at her:
http://www.contextures.com/xlDataVal01.html

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"GBH99" wrote in message
...
I am having difficulty making a drop down list for an excel cell, I don't
want it to filter, I need it to select pre-determined values. Can anyone
help