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

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