Drop down box

  • Thread starter Thread starter Glenn
  • Start date Start date
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
 
Data/Valildation
Choose List
Enter
East Midlands,Midlands,Sussex
exactly as shown -- no quotes.
HTH
Bob Umlas
Excel MVP
 
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.
 
Back
Top