Drop down box

G

Glenn

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
 
B

Bob Umlas

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

Luke M

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup 2
Met Office Warnings Issued For: 7
Holy flying ants Batman! 3
drop down list 2
Drop down / validation / lookup into the same cell 2
Change drop down list in one cell based on values in other cells 2
Create Drop Down Box populated by a List 1
Selecting multiple values from a drop down list box 5

Top