Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop down menu for excel 2007
I am familiar with drop down menus for earlier excel versions, but cannot
figure out how to create drop down menus in excel 2007. Can anyone help? Thanks, John |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop down menu for excel 2007
Setting them up is the same it's how to get to them that's different.
For a data validation list: Data tabData tools grouptop right icon For a combo box: Developer tabControls groupInsert The Developer tab isn't part of the ribbon by default. If you don't see it goto Office buttonExcel OptionsPopularTop options for working with ExcelShow Developer tab in ribbonOK -- Biff Microsoft Excel MVP "johnkemper" wrote in message ... I am familiar with drop down menus for earlier excel versions, but cannot figure out how to create drop down menus in excel 2007. Can anyone help? Thanks, John |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop down menu for excel 2007
Thank you very much. Pretty easy...with your help. :-)
"T. Valko" wrote: Setting them up is the same it's how to get to them that's different. For a data validation list: Data tabData tools grouptop right icon For a combo box: Developer tabControls groupInsert The Developer tab isn't part of the ribbon by default. If you don't see it goto Office buttonExcel OptionsPopularTop options for working with ExcelShow Developer tab in ribbonOK -- Biff Microsoft Excel MVP "johnkemper" wrote in message ... I am familiar with drop down menus for earlier excel versions, but cannot figure out how to create drop down menus in excel 2007. Can anyone help? Thanks, John |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop down menu for excel 2007
You're welcome!
-- Biff Microsoft Excel MVP "johnkemper" wrote in message ... Thank you very much. Pretty easy...with your help. :-) "T. Valko" wrote: Setting them up is the same it's how to get to them that's different. For a data validation list: Data tabData tools grouptop right icon For a combo box: Developer tabControls groupInsert The Developer tab isn't part of the ribbon by default. If you don't see it goto Office buttonExcel OptionsPopularTop options for working with ExcelShow Developer tab in ribbonOK -- Biff Microsoft Excel MVP "johnkemper" wrote in message ... I am familiar with drop down menus for earlier excel versions, but cannot figure out how to create drop down menus in excel 2007. Can anyone help? Thanks, John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop dwn menu. Formula to count selection frm menu in anoth cell? | Excel Worksheet Functions | |||
filter dropdown menu so 2nd drop menu is customized | Excel Worksheet Functions | |||
How do you create a drop down menu in excel? | Excel Worksheet Functions | |||
How do I set up a drop-down menu/list in Excel? | Excel Worksheet Functions | |||
How do I set up a drop-down menu within an Excel Spreadsheet? | Setting up and Configuration of Excel |