pull down box

  • Thread starter Thread starter sowetoddid
  • Start date Start date
S

sowetoddid

How can I create a pull down menu to choose the contents of a cell?
want to restrict the users input to 5 different values
 
Go to Data>Validation and select LIST under the "Allow" window and in the source box type your 5 items you want people to select from each separated by a coma
Make sure your in the cell where you want the validation to show up

----- Bob Phillips wrote: ----

Take a look at Data Validation in Help

Debra Dalgleish has a good web page on i
http://www.contextures.com/xlDataVal01.htm

-

HT

Bob Phillip
... looking out across Poole Harbour to the Purbeck
(remove nothere from the email address if mailing direct
 
You must log in or register to reply here.

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

change cell contents when pull down menu choices change 3
Excel Import Comments 3
Complex search and replace macro based on input variables. 12
Receive data in column with pull down 2
if or lookup for facturations 2
Combo box? 4
To Make a Changing Data Sheet 4
Reference the same cell based on tab name 1

Back
Top