Drop down box
 

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

Drop down box
 

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

Drop down box
 

Select cell A1.
Go to Data - Validation. From the allow dropdown, choose "List"
In the box type the following:

East Midlands,Midlands,Sussex

click ok, good to go.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Glenn" wrote:

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