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.

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.

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.

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.

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.