Thank you that did the trick. Why can't the help menu make that simple?

"The Toasterman" wrote:

Use validation in DATA

i.e: data / validation in allow select LIST & you make your list elsewhere
in your worksheet & in the data field select the list. You can hide your list
later.



"chefmike" wrote:

Can anybody tell how to make a drop down list? I have a list of about 15
numbers I want to put into a drop down list in a specific cell. I have read
the help files and still don't understand how to do it. Any help would be
great.
Thanks in advance
mike