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.
|