in-cell dropdown menus

[mahmoud]

Hi everybody,

I am learning how to create a in-cell dropdown menu, but I have two problems:

the first is that when I create a dropdown menu manually, it doesn't work.
It appears like this: Yes, No as I typed them in the source box. they must
appear like a menu :
Yes
No
but as I explained they appear on one line in the menu.

the second question is that creating a dropdown menu from another workbook
also doesn't work.

could anyone help?

 

[Dave Peterson]

Try using your windows list separator character (maybe a semicolon ().

Debra Dalgleish has lots of info:

 

[Dave Peterson]

Debra Dalgleish has lots of info:
http://contextures.com/xlDataVal01.html
and
http://contextures.com/xlDataVal05.html

http://contextures.com/tiptech.html
(for the index)