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
 
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

Pull down lists 1
How to create a customized icon for specific filename within toolb 4
How to determine the value - 18 Dec? 5
Excel 2007 Pull Down List 5
Data Validation to exclude blank cells 6
Pull-down List 2
How to create a checkk box? 2
Create Macro to pull data from a warehouse management system? 1

Top