Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pick from a list
I have created a list on a worksheet of 5 products. I want to create a drop
down list in several fields that references this list. How do I do that? Thanks! Alicia |
#2
|
|||
|
|||
You can use Data Validation to create a drop down list. There are
instructions in Excel's Help, and he http://www.contextures.com/xlDataVal01.html Alicia wrote: I have created a list on a worksheet of 5 products. I want to create a drop down list in several fields that references this list. How do I do that? Thanks! Alicia -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pick from a list
-- Geoff "Alicia" wrote: I have created a list on a worksheet of 5 products. I want to create a drop down list in several fields that references this list. How do I do that? Thanks! Alicia |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pick List | Excel Discussion (Misc queries) | |||
Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
Pick From List | Excel Discussion (Misc queries) | |||
How do I find out what items are in one list but not in another l. | Excel Discussion (Misc queries) | |||
Creating a list from an existing list. | Excel Worksheet Functions |