| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to create a pull down lists?
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to create a pull down lists?
Hi Eric
From menu DataValidationFrom validation criteria select 'List'In Source mention the range =$A$1:$A$10 and click OK -- Jacob (MVP - Excel) "Eric" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pull down lists | Excel Discussion (Misc queries) | |||
| Pull Down Lists | Excel Discussion (Misc queries) | |||
| populate fields based upon pull down lists | Excel Worksheet Functions | |||
| Creating Pull Down Lists in Excel cells. | Excel Discussion (Misc queries) | |||
| Pull down lists | Excel Discussion (Misc queries) | |||
Linear Mode
