Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
in-cell dropdown menus
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
in-cell dropdown menus
Try using your windows list separator character (maybe a semicolon (;)).
Debra Dalgleish has lots of info: mahmoud wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
in-cell dropdown menus
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) mahmoud wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel dropdown menus | Setting up and Configuration of Excel | |||
Permanently extending dropdown menus | Excel Discussion (Misc queries) | |||
Are drop-down menus that allow 1 entry per cell possible? | Excel Discussion (Misc queries) | |||
New Menus - attaching but menus are reset | Excel Worksheet Functions | |||
Adding dropdown menus? | Excel Discussion (Misc queries) |