drop down menu for excel 2007

  • Thread starter Thread starter johnkemper
  • Start date Start date
J

johnkemper

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
 
Setting them up is the same it's how to get to them that's different.

For a data validation list:

Data tab>Data tools group>top right icon

For a combo box:

Developer tab>Controls group>Insert

The Developer tab isn't part of the ribbon by default. If you don't see it
goto Office button>Excel Options>Popular>Top options for working with
Excel>Show Developer tab in ribbon>OK
 
Back
Top