drop down button
 

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????????????/

drop down button
 

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.

gwen wrote:
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
Contextures
http://www.contextures.com/tiptech.html