drop down button

[gwen]

I had excel 2000 and just upgraded to 2007. In 2000 i set up drop down
button to allow you to choose from a list that showed up when you hit the
down arrow. How do I do this in 2007????????????/

 

[Debra Dalgleish]

On the Ribbon, click Data
Click Data Validation, then click Data Validation
For Allow, choose List
For Source, select the list, or type the list items.