How to create a pull down lists?

E

Eric

Does anyone have any suggestions on how to create a pull down lists?
There is a list of values from cell A1 to A10, I would like to create a pull
down list to select any value from this list.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric
 
P

p45cal

Does anyone have any suggestions on how to create a pull down lists?
There is a list of values from cell A1 to A10, I would like to create pull
down list to select any value from this list.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric
Click to expand...



Check out Data Validation:
Choose List in the *Allow:* field and select your range in th
*Source:* field.
If your source range is not on the same sheet you can name the rang
and use the name in *Source:* field.. eg.:
=TheList
 
J

Jacob Skaria

Hi Eric

From menu Data>Validation>From validation criteria select 'List'>In Source
mention the range
=$A$1:$A$10

and click OK
 

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 to make repeating drop-down lists? 2
Drop down lists in seperate columns 5
Creating a Search using a combo box and then creating a report. 4
Dynamic Naming of Form Button 3
Outlook meeting location auto prompts with a suggestion list - need to disable 0
How can I give customized drop down in Ms Forms online or refer dropdown from excel list 0
Need a macro to create a separate document that lists all capitalized words 6
Remove checked items from To Do lists 0

Top