Data/Valildation
Choose List
Enter
East Midlands,Midlands,Sussex
exactly as shown -- no quotes.
HTH
Bob Umlas
Excel MVP

"Glenn" wrote in message
...
I want cell A1 to be a drop down list that the user can select one from the
list.
In the list I want the following
East Midlands
Midlands
Sussex

How do I do this.

Many thanks