Thread: drop down list
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default drop down list

Put the four value in a column (say A1 to A4) and name the list e.g. name is
"myname"

Insert==Name==Define==='myname' no quotes))

Then select cell for your drop down list, then do:

Data==Validation==Allow-list==Source "=myname" (no quotes)

HTH

"Sher" wrote:

Can someone help me with the drop down list. I saw an example on excel help
but it is not working for me. Really different from Access. I have four
choices I would lke to have people choose from.

On-Track
At-Risk
Concerns
Decision Required

Can someone help me with creating the list.