Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating drop downs for multiple cells
Hello All,
I am trying to creat a spread sheet that contains dropdowns, the problem that I am having is that the cells contain the same information from the drop downs and I am wanting to know how to create drop downs for multiple cells without having to creat a drop down in every cell everytime with the same information. Thank you! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating drop downs for multiple cells
Give your list of items a defined name like MyList
Then....................... Select A1:A10 DataValidationAllowList Enter =MyList in the Source dialog. All selected cells will have the same list in a dropdown. Gord Dibben MS Excel MVP On Wed, 11 Feb 2009 11:05:03 -0800, Colee Bugg <Colee wrote: Hello All, I am trying to creat a spread sheet that contains dropdowns, the problem that I am having is that the cells contain the same information from the drop downs and I am wanting to know how to create drop downs for multiple cells without having to creat a drop down in every cell everytime with the same information. Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating drop downs for part number configuration | Excel Worksheet Functions | |||
Multiple Dependent Drop Downs | Excel Worksheet Functions | |||
How do I copy cells containing drop downs? | Excel Worksheet Functions | |||
Can you use drop downs to post multiple links? | Excel Discussion (Misc queries) | |||
Populate Data w/ Multiple Drop-Downs | Excel Discussion (Misc queries) |