How do I create multi choice selec drop down list in Excel please

  • Thread starter Thread starter JillyB
  • Start date Start date
J

JillyB

In Excel I need to set up a drop down list from which I can select multiple
choices please. Eg. select multiple locations from a list of locations.
UREGENT

Thanks for your help
 
Hi Jilly

In XL2002 (XP) do the following:

Select the cell in which you want the drop down
Click on Data | Validation
From the 'Allow' box select 'List'
Type in your values in the Source box seperated with a comma
(e.g. Item 1, Item 2, Item 3)
Click 'OK'

Note: You can also enter Named Ranges into the Source box

Regards

Trevor
 

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

How do you select multiple characters in a drop down list to appe. 2
Drop down list with multiple choices 6
How do I create multi choice selec drop down list in Excel please 7
Excel 07 / Data Validation / List / 1
Restrict Choice in Shared WB (drop down alternative)? 0
Drop down lists on multiple worksheets 2
Drop Down Lists 1
How do I create "IF" function with a drop down list? 10

Back
Top