Thread: drop down list
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
The Toasterman
 
Posts: n/a
Default drop down list

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