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

Font drop-down menu very slow 0
How to make repeating drop-down lists? 2
How can I give customized drop down in Ms Forms online or refer dropdown from excel list 0
Link a text box based on drop down box with four options MS Word 365 0
Drop down list control value in vba 2
Drop down lists in seperate columns 5
Dynamic Naming of Form Button 3
Create own tool bar Mac 2015 0

Top