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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can I make vertical drop-down menus instead of horizontal icons? 4
How to get the full list of drop down menu 1
limit autofilter drop down menu entries 1
Multi layered drop down 1
How to make items in a drop down menu reference a number 2
Excel Drop down menu IF statement help Please 2
Drop Down Boxes 2
Lock drop down menus 1

Back
Top