Creating Drop Box Lists

[PizzaGirl]

I am trying to create a sample request form for my sales men using excel
2000. I can not figure out how to create a drop box. Please help.

 

[FSt1]

hi
excel uses 3 differents types of dropdowns. lets assume the simplests.
see this sites.
http://www.contextures.com/xlDataVal01.html
http://www.contextures.com/xlDataVal02.html
this is a very good site with a lot of good tips on a lot more that just
dropdowns. at the top of each page, click on excel tips for a complete list.

Regards
FSt1

 

[T. Valko]

Watch this 5 min video:

How to setup a data validation drop down list: