drop down menu for excel 2007

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
 
T

T. Valko

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
Can Excel 2007 title bar be made to work/look like earlier version 1
ribbon into tool bard and drop down menus 3
How to make items in a drop down menu reference a number 2
Drop Down Boxes 2

Top