Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filter / Drop Down Menu
I'm hoping you can help;
I'm trying to create a function I have seen on other worksheets; basically when a cell in clicked on, a small drop down menu will appear to the right hand side with pre-determined text of the aurthers choice. e.g. if I had a column into which I would only ever need to type three possible data choices i.e. "Yes", "No", "Maybe", it would allow me to scroll down and select the one of my choice. Hope you can help. Many thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filter / Drop Down Menu
See http://www.contextures.com/xlDataVal01.html
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "IGG" wrote in message ... I'm hoping you can help; I'm trying to create a function I have seen on other worksheets; basically when a cell in clicked on, a small drop down menu will appear to the right hand side with pre-determined text of the aurthers choice. e.g. if I had a column into which I would only ever need to type three possible data choices i.e. "Yes", "No", "Maybe", it would allow me to scroll down and select the one of my choice. Hope you can help. Many thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
filter dropdown menu so 2nd drop menu is customized | Excel Worksheet Functions | |||
Use dd menu choice to filter input for next ddm, etc. | Excel Discussion (Misc queries) | |||
Cross-referenced drop-down menu (nested drop-downs?) | Excel Worksheet Functions | |||
Drop Down Menu | Excel Discussion (Misc queries) |