Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down lists in cells.....I think!!!!
Can anyone help with my little problem.
I need to find out how to add drop down lists to individual cells. If you can picture this example...... I have a list with 10 items....in any given cell I would like a control box a down arrow to select from this list of items....but....I would also like to drag this box/list down into other cells when new names are added to a main list. If this makes sense....all help will be accepted with many thanks. If it doesnt make sense....sorry. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down lists in cells.....I think!!!!
Try a data validation pull-down:
http://www.contextures.com/xlDataVal01.html -- Gary''s Student - gsnu200801 "Confuddled User!!!!!!!!!!!!!" wrote: Can anyone help with my little problem. I need to find out how to add drop down lists to individual cells. If you can picture this example...... I have a list with 10 items....in any given cell I would like a control box a down arrow to select from this list of items....but....I would also like to drag this box/list down into other cells when new names are added to a main list. If this makes sense....all help will be accepted with many thanks. If it doesnt make sense....sorry. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down lists in cells.....I think!!!!
Hi
You may try List option availble in Data validation. Data Validation Choose under allow give the range of list under source. Regards rajesh "Confuddled User!!!!!!!!!!!!!" wrote: Can anyone help with my little problem. I need to find out how to add drop down lists to individual cells. If you can picture this example...... I have a list with 10 items....in any given cell I would like a control box a down arrow to select from this list of items....but....I would also like to drag this box/list down into other cells when new names are added to a main list. If this makes sense....all help will be accepted with many thanks. If it doesnt make sense....sorry. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down lists in cells.....I think!!!!
Many thanks....as with all things that was so simple. I need to look more
closely. "Gary''s Student" wrote: Try a data validation pull-down: http://www.contextures.com/xlDataVal01.html -- Gary''s Student - gsnu200801 "Confuddled User!!!!!!!!!!!!!" wrote: Can anyone help with my little problem. I need to find out how to add drop down lists to individual cells. If you can picture this example...... I have a list with 10 items....in any given cell I would like a control box a down arrow to select from this list of items....but....I would also like to drag this box/list down into other cells when new names are added to a main list. If this makes sense....all help will be accepted with many thanks. If it doesnt make sense....sorry. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down lists in cells.....I think!!!!
Great stuff...many thanks
"rajesh" wrote: Hi You may try List option availble in Data validation. Data Validation Choose under allow give the range of list under source. Regards rajesh "Confuddled User!!!!!!!!!!!!!" wrote: Can anyone help with my little problem. I need to find out how to add drop down lists to individual cells. If you can picture this example...... I have a list with 10 items....in any given cell I would like a control box a down arrow to select from this list of items....but....I would also like to drag this box/list down into other cells when new names are added to a main list. If this makes sense....all help will be accepted with many thanks. If it doesnt make sense....sorry. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locked Cells with Data Validation Drop Down Lists | Excel Discussion (Misc queries) | |||
drop down lists that populate other cells | Excel Discussion (Misc queries) | |||
Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
Copying Cells with Drop Down Lists | New Users to Excel | |||
Copying Cells with Drop Down Lists | Excel Worksheet Functions |