Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Drop down lists
Hi all
Was wondering if somebody could give me some clues on how to insert a drop down list into a cell (if this can be done) This list will contain the names of a numer of' stocks of which I need to select and display one Many thanks Alex |
#2
|
|||
|
|||
Description here
http://www.contextures.com/xlDataVal01.html -- Regards, Peo Sjoblom (No private emails please) "Alex McKenzie" wrote in message ... Hi all Was wondering if somebody could give me some clues on how to insert a drop down list into a cell (if this can be done) This list will contain the names of a numer of' stocks of which I need to select and display one Many thanks Alex |
#3
|
|||
|
|||
1. Enter the list of items somewhere in the workbook.
2. Select the cell where you want the list. 3. Go to Data Validation. Select 'List' from the Allow drop-down. Select the list item range in the Source field. "Alex McKenzie" wrote in message ... Hi all Was wondering if somebody could give me some clues on how to insert a drop down list into a cell (if this can be done) This list will contain the names of a numer of' stocks of which I need to select and display one Many thanks Alex |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop Down lists | Excel Discussion (Misc queries) | |||
unrestricting drop down lists | Excel Worksheet Functions | |||
Data Validation - Drop down lists - if then? | Excel Discussion (Misc queries) | |||
Can different drop down lists be displayed depending on the value. | Excel Discussion (Misc queries) | |||
How do I change the appearance of my drop down lists? | Excel Worksheet Functions |